JSP第八次作业

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>My JSP 'register.jsp' starting page</title>    
  </head>
  
  <body>

    <form  action="2.jsp" method="post">

        用户名:<input type="text" name="uname"><br> 
        密   码: <input type="password" name="password"> <br>
        确认密码: <input type="password" name="password"> <br>
        年   龄:<input type="text" name="age"><br>
        <input type="submit" value="注册">
        <a href="3.jsp">登录</a>
    </form>
    
  </body>
</html>

  

<%@page import="mld.StuDao"%>
<%@page import="javax.xml.bind.ParseConversionEvent"%>
<%@page language="java" import="java.util.*" pageEncoding="utf-8"%>

<!DOCTYPE HTML>
<html>
<head>
<title></title>
</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);
        StuDao sd=new StuDao();
        int i=sd.Register(uname, password, age1);
        if(i>0){
        request.getRequestDispatcher("1.jsp").forward(request, response);
        }else{
        out.print("注册失败");
        }
    %>
</body>
</html>

  

<%@page import="mld.StuDao"%>
<%@page import="javax.xml.bind.ParseConversionEvent"%>
<%@page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML>
<html>
<head>
<title></title>
</head>
<body>
    <%
        String uname = request.getParameter("uname");
        String password = request.getParameter("password");
        StuDao sd=new StuDao();
        if(sd.Login(uname, password)){
        request.getRequestDispatcher("4.jsp").forward(request, response);
        }else{
        out.print("登陆失败,即将跳回登陆页.....");
        response.setHeader("refresh", "2;url=1.jsp");
        }
        
    %>
</body>
</html>

  

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML>
<html>
  <head>
    <title></title>
  </head>
  <body>
  <h1>登录成功</h1>
  </body>
</html>

  

package mld;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class StuDao {
	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;
    }
    private Connection getConnection() {
		// TODO Auto-generated method stub
		return null;
	}
	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;
    }
	private void closeAll(Connection con, PreparedStatement pred,
			ResultSet resultSet) {
		// TODO Auto-generated method stub
		
	}

}

  

package mld;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BaseDao {
	public Connection getConnection() {
        Connection con = null;
        try {
            Class.forName("com.mysql.zqj.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();
            }
        }

}

  

 

 

 

 

posted @ 2022-05-08 13:54  MaLD  阅读(11)  评论(0编辑  收藏  举报