关于注册/登录网页的总结
关于注册/登录网页连接到数据库:注册:
String id = request.getParameter("id");String member = request.getParameter("member");String pass = request.getParameter("pass");String name = request.getParameter("name");try { //1，加载驱动 Class.forName("com.mysql.jdbc.Driver"); //2，建立连接 java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht", "root", "root"); //3，创建sql传送对象 Statement stmt = conn.createStatement(); //4，将sql语句通过sql传送对象传送到数据库并执行，返还结果集String sql = "insert into member value('"+id+"','"+member+"','"+pass+"','"+name+"')"; stmt.executeUpdate(sql); stmt.close(); conn.close();
跳转代码:response.sendRedirect("login.html");//跳转到login.html
登录:
<form id="form1" name="form1" method="post" action="dologin.jsp">//表单登录提交之后跳转到dologin.jsp
显示列表sql:
try{Class.forName("com.mysql.jdbc.Driver");java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht","root","root");Statement stmt = conn.createStatement();String sql = "select * from member"; ResultSet rs = stmt.executeQuery(sql); while(rs.next()){
跳转到修改页面并且把所要修改行的“id”传过去:
<a href="update.jsp?id=<%=rs.getString(1)%>">修改</a>
其中id=<%=rs.getString(1)%>为传ID
try { //1，加载驱动 Class.forName("com.mysql.jdbc.Driver"); //2，建立连接 java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht", "root", "root"); //3，创建sql传送对象 Statement stmt = conn.createStatement(); //4，将sql语句通过sql传送对象传送到数据库并执行，返还结果集String sql = "update member set member ='"+member+"',pass='"+pass+"',name='"+name+"' where id='"+id+"'";//更新数据 stmt.executeUpdate(sql); stmt.close(); conn.close(); } catch (Exception e) { System.out.println(e); } response.sendRedirect("dolist.jsp");
跳转到删除页面并且把所要删除行的“id”传过去:
<a href="delete.jsp?id=<%=rs.getString(1)%>">
try { //1，加载驱动 Class.forName("com.mysql.jdbc.Driver"); //2，建立连接 java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht", "root", "root"); //3，创建sql传送对象 Statement stmt = conn.createStatement(); //4，将sql语句通过sql传送对象传送到数据库并执行，返还结果集String sql = "deletefrom memberwhere id='"+id1+"'";//删除数据deletefrom member stmt.executeUpdate(sql); stmt.close(); conn.close(); } catch (Exception e) { System.out.println(e); } response.sendRedirect("dolist.jsp");
页:
[1]