flex中的UserInfoSys源码

package flex.userinfosys.db.user; 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 flex.userinfosys.db.ConnectionHelper; import flex.userinfosys.db.DAOException; public class UserService { public List getUsers() { System.out.println("——————UserService——————1——————————"); ArrayList list = new ArrayList(); Connection c = null; try { System.out.println("——————UserService——————2——————————"); c = ConnectionHelper.getConnection(); Statement s = c.createStatement(); ResultSet rs = s .executeQuery("SELECT * FROM USERPROFILE ORDER BY name"); while (rs.next()) { list.add(new UserProfile(rs.getInt("user_id"), rs.getString("name"), rs.getString("title"), rs.getString("image"), rs.getString("imagebref"), rs.getString("description"))); } } catch (Exception e) { e.printStackTrace(); } finally { try { c.close(); } catch (SQLException e) { e.printStackTrace(); } } System.out.println("——————UserService——————6——————————"); return list; } public UserProfile getUserProfile(int userId) throws DAOException { return null; } public void update(UserProfile user) throws DAOException,ConcurrencyException { Connection c = null; System.out.println("updating ... "); try { c = ConnectionHelper.getConnection(); PreparedStatement ps = c.prepareStatement("UPDATE USERPROFILE SET " + "name=?, title=?, image=?, imagebref=?, " + "description=? WHERE user_id=?"); ps.setString(1, user.getName()); ps.setString(2, user.getTitle()); ps.setString(3, user.getImage()); ps.setString(4, user.getImagebref()); ps.setString(5, user.getDescription()); ps.setInt(6, user.getUserId()); if (ps.executeUpdate() == 0) { throw new ConcurrencyException("Item not found"); } } catch (Exception e) { e.printStackTrace(); throw new DAOException(e); } finally { try { c.close(); } catch (SQLException e) { e.printStackTrace(); } } } }