资源预览内容
第1页 / 共16页
第2页 / 共16页
第3页 / 共16页
第4页 / 共16页
第5页 / 共16页
第6页 / 共16页
第7页 / 共16页
第8页 / 共16页
第9页 / 共16页
第10页 / 共16页
亲,该文档总共16页,到这儿已超出免费预览范围,如果喜欢就下载吧!
资源描述
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, Ht
收藏 下载该资源
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号