// these build the collections to return to the servlets, controlles private void loadUser(User user, ResultSet resultSet, int index) throws SQLException { user.setUserID(resultSet.getInt(index++)); user.setUsername(resultSet.getString(index++)); user.setPassword(resultSet.getString(index++)); user.setEmail(resultSet.getString(index++)); user.setAccountType(resultSet.getString(index++)); user.setFname(resultSet.getString(index++)); user.setLname(resultSet.getString(index++)); }