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; } }

转载于:https://www.cnblogs.com/jgrs/p/7763274.html