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>

 

posted @ 2022-05-08 13:29  刘源丰  阅读(2)  评论(0)  编辑  收藏  举报