public User mapRow(ResultSet rs, int rowNum) throws SQLException { User user = new User(); user.setId(rs.getLong("id")); user.setUserName(rs.getString("username")); user.setFirst_name(rs.getString("first_name")); user.setLast_name(rs.getString("last_name")); user.setName(rs.getString("name")); return user; }