第十周作业

数据库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>
    
    <title>My JSP 'login.jsp' starting page</title>
    

  </head>
  
  <body>
<script type="text/javascript">
        function validate(){
            if(loginForm.stuname.value==""){
                alert("账号不能为空!");
                return;
            }
            if(loginForm.stupwd.value==""){
                alert("密码不能为空!");
                return;
            }
            loginForm.submit();
        }
    </script>


    <form name="loginForm" action="dologin.jsp" method="post">
        
    用户名:<input type="text" name="stuname" value=""><br> 
    密码: <input  type="password" name="stupwd"  value="">
    
        <input type="button" value="登录" onClick="validate()">    
        <a href="register.jsp">注册</a>

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

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

  </head>
  
  <body>
   <%
    StuDao sd=new StuDao();
    request.setCharacterEncoding("utf-8");
    String stuname = request.getParameter("stuname");
    String stupwd = request.getParameter("stupwd");
    if (sd.login(stuname, stupwd)){
        session.setAttribute("stuname", stuname);
        request.getRequestDispatcher("main.jsp").forward(request, response);
    }else{
        out.print("登陆失败,即将跳回登陆页.....");
        response.setHeader("refresh", "2;url=login.jsp");
    }
 %>
  </body>
</html>
<%@ 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>
    <script type="text/javascript">
        function validate(){
            if(loginForm.stuname.value==""){
                alert("账号不能为空!");
                return;
            }
            if(loginForm.stupwd.value==""){
                alert("密码不能为空!");
                return;
            }
            if(loginForm.stupwd1.value==""){
                alert("确认密码不能为空!");
                return;
            }
            if(loginForm.stuage.value==""){
                alert("年龄不能为空!");
                return;
            }
            loginForm.submit();
        }
    </script>


    <form name="loginForm" action="jump.jsp" method="post">
    用户名:<input type="text" name="stuname" value=""><br> 
    密码: <input  type="password" name="stupwd"  value=""><br> 
    确认密码: <input  type="password" name="stupwd1"  value=""><br> 
    年龄:<input type="text" name="stuage" value=""><br> 
    <a href="login.jsp">返回登录</a>
        <input type="button" value="注册" onClick="validate()">    
    </form>

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


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>My JSP 'jump.jsp' starting page</title>


</head>

<body>
    <%
        StuDao sd=new StuDao();
        request.setCharacterEncoding("utf-8");
        String stuname = request.getParameter("stuname");
        String stupwd = request.getParameter("stupwd");
        String stuages = request.getParameter("stuage");
        int stuage = Integer.parseInt(stuages);
      
        if(sd.reg(stuname, stupwd, stuage)){
        request.getRequestDispatcher("login.jsp").forward(request, response);
        }else{
        out.print("注册失败");
        }
    %>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <title>My JSP 'main.jsp' starting page</title>
    
  </head>
  
  <body>
    登陆成功! <br>
  </body>
</html>

 

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 name, String pwd) {
        boolean f = false;
        Connection conn = getConnection();
        String sql = "select * from stu where uname=? and upwd=?";
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, name);
            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 upwd,int uage) {
        Connection conn = getConnection();
        PreparedStatement ps = null;
        try {
            String sql = "insert into stu(uname,upwd,uage) values(?,?,?)";
            
            ps = conn.prepareStatement(sql);
            ps.setString(1, uname);
            ps.setString(2, upwd);
            ps.setInt(3, uage);
            ps.executeUpdate();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            closeAll(conn, ps, null);
        }

    }

}
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/test", "root", "123456");
            } 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();
        }
    }
}

 

posted @ 2022-05-08 15:17  马宇航1  阅读(23)  评论(0编辑  收藏  举报