@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; }