javaweb动态表格.docx

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(HttpServletRequest 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();request.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 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 javax.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.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(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.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.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, IOExceptionPrintWriter 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,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, HttpServletResponse response)throws ServletException, IOExceptionPrintWriter 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,HR,oracle);PreparedStatement pst=con.prepareStatement(select * from workers where w_name=+s+);ResultSet rs=pst.executeQuery();out=response.getWriter();rs.next();String w_name=rs.getString(1);int w_salary=rs.getInt(2);int w_age=rs.getInt(3);out.println(Insert title here);out.println(); out.println(); out.println(); out.println(雇员信息更改); out.println(姓名： ); out.println(薪水：); out.println(年龄：); out.println(); out.println(); out.close(); pst.close(); con.close();catch(Exception e)e.printStackTrace();代码2.import java.io.IOException;import java.io.PrintWriter;import java.sql.*;import javax.servlet.ServletException;import javax.servlet.http.*;public class updata2 extends HttpServlet public void service(HttpServletRequest 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();request.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(update workers set w_salary=+salary+,w_age=+age+ where=+name+);rs.next();response.sendRed