@Override
public List<User> getAll() throws DbException {
PreparedStatement ps = null;
ResultSet rs = null;
List<User> users = new ArrayList<>();
try {
prepareConnection();
ps = connection.prepareStatement(USERS_SELECT_ALL);
rs = ps.executeQuery();
while (rs.next()) {
User tempUser = new User();
int userId = rs.getInt("id");
String firstName = rs.getString("firstname");
String lastName = rs.getString("lastname");
String nickName = rs.getString("nickname");
String email = rs.getString("email");
String password = rs.getString("userpassword");
int roleId = rs.getInt("roleid");
Date hDite = rs.getDate("hiredday");
Date fDite = rs.getDate("firedday");
String userNotes = rs.getString("usernote");
UserStatus status = UserStatus.fromDataBaseVal(rs.getString("userstatus"));
UserState state = UserState.fromDataBaseVal(rs.getString("userstate"));
tempUser.setUserId(userId);
tempUser.setFirstName(firstName);
tempUser.setLastName(lastName);
tempUser.setNickName(nickName);
tempUser.setEmail(email);
tempUser.setPassword(password);
tempUser.setRoleId(roleId);
tempUser.setHiredDay(hDite);
tempUser.setFiredDay(fDite);
tempUser.setUserNote(userNotes);
tempUser.setStatus(status);
tempUser.setState(state);
users.add(tempUser);
}
} catch (SQLException e) {
throw new DbException("Can't execute SQL = '" + USERS_SELECT_ALL + "'", e);
} finally {
daoHelper.closeDataBaseEntities(ps, rs, connection);
}
return users;
}
