java bean设计_数据库访问JavaBean的设计

packagedao;import java.sql.*;importjava.util.ArrayList;importjava.util.List;importvo.User;importdbc.JdbcUtil;public classUserDao {public void add(User user)throwsException{

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)throwsException{

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.getUserid());

ps.setString(2,user.getUsername());

ps.setString(3,user.getSex());

ps.executeUpdate();

}finally{JdbcUtil.free(null,ps,conn);}

}public void delete(String userId)throwsException{

Connection conn=null;

PreparedStatement ps=null;try{

conn=JdbcUtil.getConnection();

String sql="delete from user where userid=?";

ps=conn.prepareStatement(sql);

ps.setString(1,userId);

ps.executeUpdate();

}finally{JdbcUtil.free(null,ps,conn);}

}public User findUserById(String userId)throwsException{

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=newUser();

user.setUserid(rs.getString(1));

user.setUsername(rs.getString(2));

user.setSex(rs.getString(3));

}

}finally{JdbcUtil.free(null,ps,conn);}returnuser;

}public List QueryAll()throwsException{

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=newUser();

user.setUserid(rs.getString(1));

user.setUsername(rs.getString(2));

user.setSex(rs.getString(3));

userList.add(user);

}

}finally{

JdbcUtil.free(rs, ps, conn);

}returnuserList;

}

}