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>
