JSP第十周作业
数据库test 中建个表 stu(stuid 主键 自动增长 ，用户名，密码，年龄)
1.设计一个注册页面，实现用户注册功能
2.设计一个登陆页面，实现用户名密码登陆
3.两个页面可以互相超链接
package a; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class b { public Connection getConnection() { Connection con = null; try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root"); } catch (Exception e) { e.printStackTrace(); } return con; } protected void closeAll(Connection con,PreparedStatement ps,ResultSet rs){ try { if(rs != null) rs.close(); if(ps != null) ps.close(); if(con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } }
package a; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class c extends b { public int Register(String uname, String password, int age) { int i = -1; Connection con = getConnection(); String sql = "insert into stu(uname,password,age)values(?,?,?)"; PreparedStatement pred = null; try { pred = con.prepareStatement(sql); pred.setString(1, uname); pred.setString(2, password); pred.setInt(3, age); i = pred.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { closeAll(con, pred, null); } return i; } public boolean Login(String uname, String password) { boolean f=false; Connection con = getConnection(); String sql = "select * from stu where uname=? and password=?"; PreparedStatement pred = null; ResultSet resultSet = null; try { pred = con.prepareStatement(sql); pred.setString(1, uname); pred.setString(2, password); resultSet = pred.executeQuery(); while (resultSet.next()) { f=true; } } catch (SQLException e) { e.printStackTrace(); } finally { closeAll(con, pred, resultSet); } return f; } }
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <h1>欢迎使用! ! !</h1> <form action="3.jsp" method="post"> <table> <tr> <td>用户名:</td> <td><input type="text" name="uname"></td> </tr> <tr> <td>密码:</td> <td><input type="password" name="password"></td> </tr> <tr> <td><input type="submit" value="登录"></td> <td><a href="2.jsp">注册</a></td> </tr> </table> </form> </body> </html>
<%@page import="a.c"%> <%@page import="javax.xml.bind.ParseConversionEvent"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP '1.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <% String uname = request.getParameter("uname"); String password = request.getParameter("password"); String age = request.getParameter("age"); int age1 = age == null ? -1 : Integer.parseInt(age); c sd=new c(); int i=sd.Register(uname, password, age1); if(i>0){ request.getRequestDispatcher("index.jsp").forward(request, response); }else{ out.print("注册失败"); } %> </body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP '2.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <h1>注册</h1> <form action="index.jsp" method="post"> <table> <tr> <td>用户名 :</td> <td><input type="text" name="uname"></td> </tr> <tr> <td>密 码 :</td> <td><input type="password" name="password"></td> </tr> <tr> <td>年 龄 :</td> <td><input type="number" name="age"></td> </tr> <tr> <td><input type="submit" value="注册"></td> <td><input type="reset" value="重置"></td> </tr> </table> </form> </body> </html>
<%@page import="a.c"%> <%@page import="javax.xml.bind.ParseConversionEvent"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP '3.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <% String uname = request.getParameter("uname"); String password = request.getParameter("password"); c sd=new c(); if(sd.Login(uname, password)){ request.getRequestDispatcher("4.jsp").forward(request, response); }else{ out.print("登陆失败，即将返回登陆页"); response.setHeader("refresh", "2;url=index.jsp"); } %> </body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8");%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP '4.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> 登录成功! ! ! </body> </html>
