JSP第十周作业
数据库test 中建个表 stu(stuid 主键 自动增长 ,用户名,密码,年龄)
1.设计一个注册页面,实现用户注册功能
2.设计一个登陆页面,实现用户名密码登陆
3.两个页面可以互相超链接
package aaa; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class BaseDao { protected Connection getConnection(){ Connection conn=null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/mysql", "root", "001010Chen"); } catch (Exception e) { e.printStackTrace(); } return conn; } 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 aaa; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class StuDao extends BaseDao { public boolean login(String uname, String pwd) { boolean f = false; Connection conn = getConnection(); String sql = "select * from stu where uname=? and pwd=?"; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(sql); ps.setString(1, uname); ps.setString(2, pwd); rs = ps.executeQuery(); if (rs.next()) f = true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { closeAll(conn, ps, rs); } return f; } public void reg(String uname, String pwd, int age) { Connection conn = getConnection(); PreparedStatement ps = null; try { String sql = "insert into stu(uname,pwd,age) values(?,?,?)"; ps = conn.prepareStatement(sql); ps.setString(1, uname); ps.setString(2, pwd); ps.setInt(3, age); ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { closeAll(conn, ps, null); } } <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%<html<head>
<title>My JSP 'slogon_link.jsp' starting page</title> </head> <%@ page import="r.stuDao"%> <% String sname = request.getParameter("sname"); String spwd = request.getParameter("spwd"); String sage = request.getParameter("sage"); String name=new String(sname.getBytes("ISO-8859-1"),"utf-8"); int pwd = Integer.parseInt(spwd); int age = Integer.parseInt(sage); stuDao s = new stuDao(); if (s.reg(sname, pwd, age) != -1) { out.println("注册成功!"); out.println("三秒后跳转到主页"); response.setHeader("refresh", "3;url=student.jsp"); } else { out.println("注册失败!"); out.println("三秒后跳转到主页"); response.setHeader("refresh", "3;url=student.jsp"); } %> <body> </body> </html> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <html> <head> <title>My JSP 'slogon.jsp' starting page</title> </head> <% %> <body> <h3>请输入信息</h3> <form action="slogon_link.jsp"> 用户名:<input type="text" name="sname" />
密码: <input type="password" name="spwd" />
年龄: <input type="text" name="sage" />
<input type="submit" value="注册" /> </form> <a href="student.jsp">返回</a> </body> </html>