第八次jsp作业 

package shuju;

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.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/zuoye", "root", "123456");
        } 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 shuju;

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

public class StuDao extends BaseDao{
    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);
        } catch (Exception e) {
            e.printStackTrace();
        }
        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" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@page import="javax.xml.bind.ParseConversionEvent"%>
    
<%
    request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
    <h1>欢迎</h1>
    <form action="dologin.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="zhuce.jsp">注册</a></td>
            </tr>
        </table>
    </form>
</body>
</html>
<%@ page import="java.util.*" language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");%>
    <%@page import="shuju.StuDao" %>
    <%@page import="javax.xml.bind.ParseConversionEvent"%>s
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
    String uname=request.getParameter("uname");
    String password = request.getParameter("password");
    StuDao as = new StuDao();
    if(as.Login(uname, password)){
        request.getRequestDispatcher("index.jsp").forward(request, response);
    }else{
        out.print("登陆失败，即将跳回登陆页.....");
        response.setHeader("refresh", "2;url=login.jsp");
    }
%>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%request.setCharacterEncoding("UTF-8");
      response.setCharacterEncoding("UTF-8");
    %>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title>Insert title here</title>
    </head>
    <body>
        <h1>注册</h1>
        <form action="doregister.jsp"method="post">
            <table>
                <tr>
                    <td>用户名</td>
                    <td> <input type="text" name ="uname"></td>
                    <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 language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page import="javax.xml.bind.ParseConversionEvent"%>
<%@page import="shuju.StuDao"%>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
    String uname = request.getParameter("uname");
    String password = request.getParameter("password");
    String age =  request.getParameter("age");
    int aged=age==null?-1:Integer.parseInt(age);
    StuDao as = new StuDao();
    int i=as.Register(uname, password, aged);
    if(i>0){
        request.getRequestDispatcher("login.jsp").forward(request, response);
    }else{
        out.print("注册失败");
    }
%>
</body>
</html>

 

 

 

 

 

 

 

 

posted on 2022-05-08 19:17  不顾倾世、只倾她一  阅读(15)  评论(0)  编辑  收藏  举报

导航