jsp第十周作业

数据库test 中建个表 stu(stuid 主键 自动增长 ，用户名，密码，年龄)

1.设计一个注册页面，实现用户注册功能
2.设计一个登陆页面，实现用户名密码登陆
3.两个页面可以互相超链接

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
  <head> <!-- ten.jsp -->
  </head>
  <body>
      <h1>注册</h1>
    <form action="ten01.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>年龄</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" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
%>
<html>
  <head> <!-- ten01.jsp -->
  </head>
  <body>
      <h1>欢迎</h1>
    <form action="ten02.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="register.jsp">注册</a></td>
            </tr>
        </table>
    </form>
  </body>
  </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page import="snippet.StuDao"%>
<%@page import="javax.xml.bind.ParseConversionEvent"%>
<html>
  <head> <!-- ten02.jsp -->
  </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("login.jsp").forward(request, response);
        }
    %>
  </body>
  </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
  <head> <!-- ten03.jsp -->
  </head>
  <body>
      <%
        String uname = request.getParameter("uname");
            String password = request.getParameter("password");
            snippet.StuDao sd=new snippet.StuDao();
            if(sd.Login(uname, password)){
            request.getRequestDispatcher("index.jsp").forward(request, response);
            }else{
            out.print("登陆失败，即将跳回登陆页.....");
            response.setHeader("refresh", "5;url=login.jsp");
            }
    %>
  </body>
  </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page import="snippet.StuDao"%>
<%
request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");%>
<html>
  <head> <!-- ten04.jsp -->
  </head>
  <body>
      <h1>登录成功</h1>
  </body>
  </html>
package snippet;
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/test","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 snippet;

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);
            i = pred.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeAll(con, pred, null);
        }
        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;
    }
}

 

 

 

 

 

 

 

posted @ 2022-05-07 22:18  满目星河☆  阅读(18)  评论(0)  编辑  收藏  举报