JSP第七周作业

用户表：  uid (主键，自动增长)   uname  upwd

使用分层实现注册。（必做）

使用分层实现登录。（选做）

User.java

package com.ee.bean;

public class User {
    private int uid;
    private String uname;
    private String upwd;
    //访问器
    public int getUid() {
        return uid;
    }
    public void setUid(int uid) {
        this.uid = uid;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getUpwd() {
        return upwd;
    }
    public void setUpwd(String upwd) {
        this.upwd = upwd;
    }
    //构造器
    public User(int uid, String uname, String upwd) {
        super();
        this.uid = uid;
        this.uname = uname;
        this.upwd = upwd;
    }
    public User() {
        super();
    }
    
}

UserDao.java

package com.ee.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import javax.resource.cci.ResultSet;

import com.ee.bean.User;

public class UserDao {

    public int addUser(User u){
        int i=0;
        
        try {
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //建立连接
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=utf8", "root", "123456");            
            //写SQL语句
            String sql="insert into user2(uname,upwd) values(?,?)";            
            //执行
            PreparedStatement ps=con.prepareStatement(sql);
            ps.setString(1, u.getUname());
            ps.setString(2, u.getUpwd());
            i=ps.executeUpdate();
            
            
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return i;
        
                
    }
    public int selectUser(User u){
        int n=0;
        try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=utf8", "root", "123456");    
            String sql="select uname,upwd from user2 where uname=?and upwd=?";    
            PreparedStatement ps=con.prepareStatement(sql);
            ps.setString(1, u.getUname());
            ps.setString(2, u.getUpwd());
            n=ps.executeUpdate();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
        return n;
        
                
    }            
}

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<style>
    body{
    width:600px;
    height:500px;
    overflow: hidden;
    position: relative;
    background-repeat: no-repeat;
    background-image:url(chengshi_yejing-007.jpg);
    }
    
    form{
    width: 300px;
    height: 150px;
    padding-top: 10px;
    margin: 150px auto;                                          
    background: #00000000;                                     
    border-radius: 20px;                                        
    border: 3px solid #f8fcfc;
    opacity: 0.9;}
    table{
    width: 300px;
    height: 80px;
    padding-top: 0px;
    margin: 50px auto; 
    background: #00000000; 
    position:relative;

    }
}
</style>
  <head>
    
  </head>
  
  <body>
    <form name="form1" method="post" action="control.jsp" >
        <table>
        <tr>    
            
            <tr>    
                <td>用户名：</td>
                <td> <input type="text" name="uname" id="userName"  ></td>
            </tr>
            <tr>    
                 <td>输入登录密码：</td>
                <td><input type="password" name="upwd" id="pwd"></td>
            </tr>
            
            <tr>    
                <td colspan="2">&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;<input type="submit" value="注册">&emsp;<input type="submit" value="登录"></td>
            </tr>

               
        </table>
    </form>
  </body>
</html>

control.java

<%@page import="com.ee.dao.UserDao"%>
<%@page import="com.ee.bean.User"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    User u = new User();
    
    String uname = request.getParameter("uname");
    u.setUname(uname);
    String upwd = request.getParameter("upwd");
    u.setUpwd(upwd);
    UserDao ud=new UserDao();
    if(ud.addUser(u)>0){
        //跳转注册成功页面 
    }else{
        //错误页面 
    }    
%>
<%    
    if(uname.equals("zs")&&upwd.equals("123")){
    //跳转成功登录页面
    request.getRequestDispatcher("welcome.jsp").forward(request, response);
    session.setAttribute("uname",uname);
    }
    else{
    //错误页面
    request.getRequestDispatcher("index.jsp").forward(request, response);
    }
%>

welcome.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  </head>
  
  <body>
    您已成功登录！
  </body>
</html>

posted @ 2021-04-14 21:35  可爱小李没脑袋  阅读(92)  评论(0)  编辑  收藏  举报