人員管理程序

1、（1）public interface IUserDAO /* 表示數據庫的增加操作* param user* return* throws Exception*/public boolean doCreate(User user) throws Exception;public boolean doUpdate(User user) throws Exception;/* 表示刪除操作，按編號刪除* param id* return* throws Exception*/public boolean doDelete(int id) throws Exception;/* 表示數據庫的查詢操

2、作* param id* return* throws Exception*/public User findById(intid) throws Exception;/* 查詢的時候將返回一組對象* param keyWord* return* throws Exception*/public List<User> findAll(StringkeyWord) throws Exception;（2）public class IUserDAOImpl implements IUserDAO private DataBaseConnection dbc = null;private

3、 Connection conn = null;public IUserDAOImpl()this.dbc = new DataBaseConnection();Overridepublic boolean doCreate(User user) throws Exception boolean flag = false;PreparedStatementpstmt = null;String sql = "INSERT INTO user(name,sex,birthday) VALUES (?,?,?) " try pstmt.setString(1, user.get

4、Name(); / 所有的內容從user 類中取出pstmt.setString(2, user.getSex();/ 所有的內容從 user 類中取出至少已經更新了一行flag = true; catch (Exception e) throw e; finally / 不管如何拋出，最終肯定是要進行數據庫的關閉操作的 if (pstmt != null) try pstmt.close(); catch (Exception e1) return flag;Overridepublic boolean doDelete(int id) throws Exception boolean fl

5、ag = false;PreparedStatementpstmt = null;String sql = "DELETEFROM userWHERE id=? "try pstmt.setInt(1, id); / 所有的內容從user 類中取出if (pstmt.executeUpdate() > 0) /至少已經更新了一行flag = true; catch (Exception e) throw e; finally / 不管如何拋出，最終肯定是要進行數據庫的關閉操作的 if (pstmt != null) try pstmt.close(); catch (

6、Exception e1) return flag;Overridepublic boolean doUpdate(User user) throws Exception boolean flag = false;PreparedStatementpstmt = null;String sql = "UPDA TE user SET name=?,sex=?,birthday=? WHERE id=?" try pstmt.setString(1, user.getName(); / 所有的內容從user 類中取出pstmt.setString(2, user.getSex

7、();/ 所有的內容從user 類中取出if (pstmt.executeUpdate() > 0) /至少已經更新了一行flag = true; catch (Exception e) throw e; finally / 不管如何拋出，最終肯定是要進行數據庫的關閉操作的 if (pstmt != null) try pstmt.close(); catch (Exception e1) return flag;Overridepublic List<User> findAll(String keyWord) throws Exception List<User>

8、; all = new ArrayList<User>(); PreparedStatementpstmt = null;String sql = "SELECT id,name,sex,birthday FROM user WHERE name LIKE ? OR sex LIKE ? OR birthday LIKE ?"try pstmt.setString(1, "%" + keyWord + "%");pstmt.setString(2, "%" + keyWord + "%&quo

9、t;);pstmt.setString(3, "%" + keyWord + "%");ResultSet rs = pstmt.executeQuery(); / 執(zhí)行查詢操作while (rs.next() User user = new User();user.setId(rs.getInt(1);user.setName(rs.getString(2);user.setSex(rs.getString(3);user.setBirthday(rs.getDate(4);all.add(user); / 所有的內容向集合中插入rs.close()

10、; catch (Exception e) throw e; finally / 不管如何拋出，最終肯定是要進行數據庫的關閉操作的 if (pstmt != null) try pstmt.close(); catch (Exception e1) return all;Overridepublic User findById(intid) throws Exception User user =null ;PreparedStatementpstmt = null;String sql = "SELECT id,name,sex,birthday FROM user WHERE i

11、d=?" try pstmt.setInt(1, id) ;ResultSet rs = pstmt.executeQuery(); / 執(zhí)行查詢操作if (rs.next() user= new User();user.setId(rs.getInt(1);user.setName(rs.getString(2);user.setSex(rs.getString(3);user.setBirthday(rs.getDate(4);rs.close() ; catch (Exception e) throw e; finally / 不管如何拋出，最終肯定是要進行數據庫的關閉操作的

12、if (pstmt != null) try pstmt.close(); catch (Exception e1) return user;（3）public class DataBaseConnection private static final String DBPASS = "mysqladmin" ;private Connection conn = null ;public DataBaseConnection()try Class.forName(DBDRIVER); catch (ClassNotFoundException e) / TODO Auto

13、-generatedcatch blocke.printStackTrace();try conn = DriverManager.getConnection(DBURL, DBUSER,DBPASS) ; catch (SQLException e) / TODO Auto -generatedcatch block e.printStackTrace();public Connection getConnection()return this.conn ;public void close()if(this.conn!=null)try catch (SQLException e) / T

14、ODO Auto -generatedcatch blocke.printStackTrace();（4）public class DAOFactory public static IUserDAO getIUserDAOInstance()return new IUserDAOImpl();（5）public class TestAll public static void main(String args) throws Exception List<User> allUser = DAOFactory.getIUserDAOInstance().findAll("&

15、quot;)Iterator<User> iter = allUser.iterator() ;while(iter.hasNext()User user = iter.next() ;public class TestDelete public static void main(String args) throws Exception DAOFactory.getIUserDAOInstance().doDelete(2);public class TestId public static void main(String args) throws Exception publ

16、ic class TestInsert public static void main(String args) throws Exception User user = new User();user.setName("李興華 ");user.setSex("男");user.setBirthday(new Date();DAOFactory.getIUserDAOInstance().doCreate(user);public class TestUpdate public static void main(String args) throws E

17、xception User user = new User();user.setName("張心 ");user.setSex("女");user.setId(2) ;user.setBirthday(new Date();DAOFactory.getIUserDAOInstance().doUpdate(user);6user ;（ ）DROP TABLECREATE TABLE user(idINTAUTO_INCREMENTPRIMARY KEY ,nameVARCHAR(50)NOT NULL ,sexVARCHAR(10)NOT NULL,bi

18、rthdayDATE) ;（7）public class User private int id;public int getId() return id;public void setId(int id) this.id = id;public String getName() return name;public void setName(String name) = name;public String getSex() return sex;public void setSex(String sex) this.sex = sex;public Date getBirthday() return birthday;public