bean
public class User {
String userid,username,sex;
public String getUserid(){return userid;}
public void setUserid(String userid){this.userid=userid;}
public String getUsername(){return username;}
public void setUsername(String username){this.username=username;}
public String getSex(){return sex;}
public void setSex(String sex){this.sex=sex;}
}
package dao;
import java.sql.*;
import java.util.ArrayList;
import vo.User;
import dbc.JdbcUtil;
public class UserDao {
public void add(User user)throws Exception{
Connection conn=null;
PreparedStatement ps=null;
try{
conn=JdbcUtil.getConnection();
String sql="insert into user values(?,?,?)";
ps=conn.prepareStatement(sql);
ps.setString(1,user.getUserid());
ps.setString(2,user.getUsername());
ps.setString(3,user.getSex());
ps.executeUpdate();
}finally{JdbcUtil.free(null,ps,conn);}
}
public void update(User user)throws Exception{
Connection conn=null;
PreparedStatement ps=null;
try{
conn=JdbcUtil.getConnection();
String sql="update user set username=?,sex=? where userid=?";
ps=conn.prepareStatement(sql);
ps.setString(1,user.getUsername());
ps.setString(2,user.getSex());
ps.setString(3,user.getUserid());
ps.executeUpdate();
}finally{JdbcUtil.free(null,ps,conn);}
}
public void delete(String userId)throws Exception{
Connection conn=null;
PreparedStatement ps=null;
try{
conn=JdbcUtil.getConnection();
String sql="delete from user where userid=?";
ps=conn.prepareStatement(sql);
ps.executeUpdate();
}finally{JdbcUtil.free(null,ps,conn);}
}
public User findUserById(String userId)throws Exception{
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
User user=null;
try{
conn=JdbcUtil.getConnection();
String sql="select * from user where userid=?";
ps=conn.prepareStatement(sql);
ps.setString(1,userId);
rs=ps.executeQuery();
if(rs.next()){
user=new User();
user.setUserid(rs.getString(1));
user.setUsername(rs.getString(2));
user.setSex(rs.getString(3));
}
}finally{JdbcUtil.free(rs,ps,conn);}
return user;
}
public ListQueryAll()throws Exception{
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
ListuserList=new ArrayList();
try{
conn=JdbcUtil.getConnection();
String sql="select * from user";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
User user=new User();
user.setUserid(rs.getString(1));
user.setUsername(rs.getString(2));
user.setSex(rs.getString(3));
userList.add(user);
}
}
finally{JdbcUtil.free(rs,ps,conn);}
return userList;
}
}
