JSP第七次作业4/14

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

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

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

<form action="dologin.jsp" method="post">
    用户名：<input id="username" type="text" name="username"/><br/>
    密码：<input id="password" type="password" name="password"/><br/>
<%--    验证码：<input type="text" name="inputVcode"/><img src="/WebProject_war_exploded/createCode"><br/>--%>
    <input type="submit" value="注册">
</form>
UserDao.java

package com.tao.dao;

import com.tao.entity.User;

public class UserDao extends BaseDao{
    public User dologin(String name,String pass){ 
        User u=null;
        try {
            super.connect();
            String sql="select * from user where name=? and pass=?";
            pstmt=conn.prepareStatement(sql);
            pstmt.setString(1, name);
            pstmt.setString(2,pass);
            rs=pstmt.executeQuery();
            while(rs.next()){
                u=new User();
                u.setId(rs.getInt(1));
                u.setName(rs.getString(2));
                u.setPass(rs.getString(3));
                u.setAge(rs.getInt(4));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            super.closeAll();
        }
        return u;
    }
    public int insert(User u){
        int row=0;
        try {
            super.connect();
            String sql="insert into user(name,pass,age) values(?,?,?)";
            pstmt=conn.prepareStatement(sql);
            pstmt.setString(1, u.getName());
            pstmt.setString(2,u.getPass());
            pstmt.setInt(3, u.getAge());
            row=pstmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            super.closeAll();
        }
        return row;
    }
}
package com.dx.entity;

public class dlBean {
    private int uid;
    private String uname;
    private String upwd;

    public dlBean() {
    }

    public dlBean(int uid, String uname, String upwd) {
        this.uid = uid;
        this.uname = uname;
        this.upwd = upwd;
    }

    @Override
    public String toString() {
        return "dlBean{" +
                "uid=" + uid +
                ", uname='" + uname + '\'' +
                ", upwd='" + 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;
    }
}
<html>
<body bgcolor=cyan>
<p style="font-family:黑体;font-size:36;color:bule">
<%        
        custom s=new custom();
        int id=Integer.paseInt(request.getParameter("uid"));
        s.setUid(id);
        String uname=request.getParameter("uname");
        s.setUname(uname);
        int upwd=Integer.paseInt(request.getParameter("upwd"));
        s.setUpwd(upwd);
        customDao ss=new customDao();
        ss.addcustom(s);
 %>
         编号： <%=id %><br/>
          用户名 ： <%=uname %><br/>
            密码  ： <%=upwd %>
</body>
</html>

　　

posted @ 2021-04-17 23:39  杨博文  阅读(69)  评论(0)    收藏  举报