JSP第八次作业
数据库test 中建个表 stu(stuid 主键 自动增长 ,用户名,密码,年龄)
1.设计一个注册页面,实现用户注册功能
2.设计一个登陆页面,实现用户名密码登陆
3.两个页面可以互相超链接
<body> <form method="post" action="zc.jsp"> 输入用户名:<input type="text" name="username"><br> 输入年龄:<input type="text" name="userage"><br> 输入密码:<input type="text" name="userpwd"><br> 确认密码:<input type="text" name="cuserpwd"><br> <input type="submit" value="注册"> </form> </body>
<body> <form action="logoin_yz.jsp" method="post"> 用户名:<input type="text" name="username"><br> 密码:<input type="password" name="userpwd" ><br> <input type="submit" value="登录"> </form> </body>
<body> <% //获取用户输入信息 request.setCharacterEncoding("utf-8"); String username=request.getParameter("username"); String userpwd=request.getParameter("userpwd"); Connection conn = null; Statement stmt = null; try { //连接驱动 Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } //建立数据库连接 String url = "jdbc:mysql://localhost:3306/bookstore_demo"; //数据库账号 String uname="root"; //数据库密码 String upwd="016205"; try { conn = DriverManager.getConnection(url, uname, upwd); //创建发射器 stmt = conn.createStatement(); //创建sql语句 String sql = "select*from bookstore_demo.yonghu where username='"+username+"' and userpwd='"+userpwd+"'"; //发送sql语句并接收结果 ResultSet rs = stmt.executeQuery(sql); if (rs.next()) { out.print("登陆成功"); } else { out.print("登陆失败"); } rs.close(); } catch (SQLException e) { e.printStackTrace(); } %> </body>
<body> <% //获取用户输入信息 request.setCharacterEncoding("utf-8"); String username=request.getParameter("username"); String userpwd=request.getParameter("userpwd"); String userage=request.getParameter("userage"); String cuserpwd=request.getParameter("cuserpwd"); //判断两次密码是否相同 if (cuserpwd.equals(userpwd)) { Connection conn = null; Statement stmt = null; try { //连接驱动 Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } //建立数据库连接 String url="jdbc:mysql://localhost:3306/bookstore_demo"; //数据库账号 String user="root"; //数据库密码 String upwd="016205"; try { conn= DriverManager.getConnection(url,user,upwd); //创建发射器 stmt=conn.createStatement(); //创建sql语句 String sql="insert into yonghu(username,userpwd) value ('"+username+"','"+userpwd+"')"; //发送sql语句并接收结果 int count = stmt.executeUpdate(sql); if (count>0){ out.print("注册成功"); out.print("<a href='logoin.jsp'>登录</a>"); } else{ out.print("注册失败"); } //关闭资源 stmt.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } else { out.print("注册失败"); } %> </body>