用java工具MyEclipse实现的ums项目代码！

package com.tarena.ums.biz; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.tarena.ums.entity.User; import com.tarena.util.ConnectionFactory; import com.tarena.util.IdGenerator; import com.tarena.util.JdbcUtil; /** * 系统的业务处理层 该层要独立于交互层，只负责将数据进行处理，不关心实现 * * @author tarena * @version 1.0 */ public class UserBiz { public List<User> findAll() { Connection con = null; Statement st = null; ResultSet rs = null; List<User> users = null; try { con = ConnectionFactory.getConnection(); String sql = "select id,uname,pwd,gender,degree,birthday,hobbies,introduction from user_0807"; System.out.println(sql); st = con.createStatement(); rs = st.executeQuery(sql); users = getUser(rs); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(); } finally { JdbcUtil.close(rs, st, con); } return users; } private List<User> getUser(ResultSet rs) throws SQLException { List<User> users = new ArrayList<User>(); while (rs.next()) { User user = new User(); user.setId(rs.getInt(1)); user.setUserName(rs.getString(2)); user.setPassword(rs.getString(3)); user.setGender(rs.getString(4)); user.setDegree(rs.getString(5)); user.setBirthday(rs.getDate(6)); user.setHobbies(rs.getString(7)); user.setIntroduction(rs.getString(8)); users.add(user); } return users; } public void add(User user) { Connection con = null; PreparedStatement ps = null; try { con = ConnectionFactory.getConnection(); user.setId(IdGenerator.generateIdBySequence(con, "user_sequence")); String sql = "insert into user_0807(id,uname,pwd,gender,degree,birthday,hobbies,introduction) values(?,?,?,?,?,?,?,?)"; System.out.println(sql); ps = con.prepareStatement(sql); int index = 1; ps.setInt(index++, user.getId()); ps.setString(index++, user.getUserName()); ps.setString(index++, user.getPassword()); ps.setString(index++, user.getGender()); ps.setString(index++, user.getDegree()); ps.setDate(index++, user.getBirthday()); ps.setString(index++, user.getHobbies()); ps.setString(index++, user.getIntroduction()); ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(); } finally { JdbcUtil.close(ps, con); } } public void modify(User user) { Connection con = null; PreparedStatement ps = null; try { con = ConnectionFactory.getConnection(); String sql = "update user_0807 set pwd=?,gender=?,degree=?,birthday=?,hobbies=?,introduction=? where id = ?"; System.out.println(sql); ps = con.prepareStatement(sql); int index = 1; ps.setString(index++, user.getPassword()); ps.setString(index++, user.getGender()); ps.setString(index++, user.getDegree()); ps.setDate(index++, user.getBirthday()); ps.setString(index++, user.getHobbies()); ps.setString(index++, user.getIntroduction()); ps.setInt(index++, user.getId()); ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(); } finally { JdbcUtil.close(ps, con); } } public void remove(int id) { Connection con = null; PreparedStatement ps = null; try { con = ConnectionFactory.getConnection(); String sql = "delete from user_0807 where id = ?"; System.out.println(sql); ps = con.prepareStatement(sql); ps.setInt(1, id); ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(); } finally { JdbcUtil.close(ps, con); } } public User find(String userName, String password) { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; List<User> users = null; try { con = ConnectionFactory.getConnection(); String sql = "select id,uname,pwd,gender,degree,birthday,hobbies,introduction from user_0807 "; sql += "where uname=? and pwd=?"; System.out.println(sql); ps = con.prepareStatement(sql); ps.setString(1, userName); ps.setString(2, password); rs = ps.executeQuery(); users = getUser(rs); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(); } finally { JdbcUtil.close(rs, ps, con); } return users.isEmpty() ? null : users.iterator().next(); } public User findById(int id) { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; List<User> users = null; try { con = ConnectionFactory.getConnection(); String sql = "select id,uname,pwd,gender,degree,birthday,hobbies,introduction from user_0807 "; sql += "where id=?"; System.out.println(sql); ps = con.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); users = getUser(rs); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(); } finally { JdbcUtil.close(rs, ps, con); } return users.isEmpty() ? null : users.iterator().next(); } }