用户表: 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>