// 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++));
}
