}
return users;
}
public User loadUser(Integer id) {
User user = null;
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("SELECT ID,FIRSTNAME,LASTNAME,NICKNAME FROM USERS WHERE ID = ");
sqlBuffer.append(id);
ResultSet resultSet = null;
try {
resultSet = excecuteQuery(sqlBuffer.toString());
if(resultSet.next()){
user = new User();
user.setId(new Integer(resultSet.getInt("ID")));
user.setFirstname(resultSet.getString("FIRSTNAME"));
user.setLastname(resultSet.getString("LASTNAME"));
user.setNickname(resultSet.getString("NICKNAME"));
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
finally {