《javaweb动态表格.docx》由会员分享,可在线阅读,更多相关《javaweb动态表格.docx(16页珍藏版)》请在金锄头文库上搜索。
1、Java web 动态表格制作一信息登录(html)Insert title here 雇员信息 姓名: 薪水: 年龄: 二、数据库连接及动态表格界面显示(Java servlet)import java.io.IOException;import java.io.PrintWriter;import java.sql.*;import javax.servlet.ServletException;import javax.servlet.http.*;public class test1 extends HttpServlet public void service(HttpServletR
2、equest request, HttpServletResponse response)throws ServletException, IOExceptionPrintWriter out=null;tryClass.forName(oracle.jdbc.driver.OracleDriver);String url=jdbc:oracle:thin:localhost:1522:orcl11gr2; Connection con=DriverManager.getConnection(url,HR,oracle);Statement st=con.createStatement();r
3、equest.setCharacterEncoding(utf-8);response.setContentType(text/html;charset=utf-8);out = response.getWriter();String name = request.getParameter(name);double salary=Double.parseDouble(request.getParameter(salary);int age=Integer.parseInt(request.getParameter(age);ResultSet rs=st.executeQuery(insert
4、 into workers values(+name+,+salary+,+age+);response.sendRedirect(table);out.close();catch(Exception e)e.printStackTrace();throw new ServletException();finally三、动态表格( Java servlet)import java.io.IOException;import java.io.PrintWriter;import java.sql.*;import javax.servlet.ServletException;import jav
5、ax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class cdx extends HttpServletpublic void service(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionPrintWriter out=null;tryrequest.
6、setCharacterEncoding(utf-8);response.setContentType(text/html;charset=utf-8);Class.forName(oracle.jdbc.driver.OracleDriver);String url=jdbc:oracle:thin:localhost:1522:orcl11gr2; Connection con=DriverManager.getConnection(url,HR,oracle);Statement st=con.createStatement();ResultSet rs=st.executeQuery(
7、select * from workers);out=response.getWriter();out.println();out.println();out.println();out.println();out.println();out.println(ID);out.println(姓名);out.println(薪水);out.println(年龄);out.println(操作);out.println();int id=1;while(rs.next()out.println(+id+);out.println(+rs.getString(1)+);out.println(+rs
8、.getInt(2)+);out.println(+rs.getInt(3)+);out.println(删除 );out.println(修改);out.println();id+;out.println();out.println(添加新雇员);out.println();out.println();catch(Exception e)e.printStackTrace();四、删除操作(Java servlet)import java.io.IOException;import java.io.PrintWriter;import java.sql.*;import javax.
9、servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class delete extends HttpServletpublic void service(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExc
10、eptionPrintWriter out=null;String s=request.getParameter(w_name);tryrequest.setCharacterEncoding(utf-8);response.setContentType(text/html;charset=utf-8);Class.forName(oracle.jdbc.driver.OracleDriver);String url=jdbc:oracle:thin:localhost:1522:orcl11gr2; Connection con=DriverManager.getConnection(url
11、,HR,oracle);Statement st=con.createStatement();ResultSet rs1=st.executeQuery(delete from workers where w_name=+s+);rs1.next();response.sendRedirect(table);catch(Exception e)e.printStackTrace();五、表格数据更新代码1.import java.io.IOException;import java.io.PrintWriter;import java.sql.*;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class updata extends HttpServletpublic void service(HttpServletRequest request, Ht