@Override public User mapRow(ResultSet rs, int rowNum) throws SQLException { // id, username, email, password, salt, identity_verified, nickname, // gender, job, phone, telephone, avatar, signature, speciality, // preference, province, city, district, address, created_on, // version, enable User user = new User(); user.setId(rs.getInt("id")); user.setUsername(rs.getString("username")); user.setEmail(rs.getString("email")); user.setPassword(rs.getString("password")); user.setSalt(rs.getString("salt")); user.setIdentityVerified(rs.getBoolean("identity_verified")); user.setNickname(rs.getString("nickname")); user.setGender(rs.getString("gender")); user.setJob(rs.getString("job")); user.setPhone(rs.getString("phone")); user.setTelephone(rs.getString("telephone")); user.setAvatar(rs.getString("avatar")); user.setSignature(rs.getString("signature")); user.setSpeciality(rs.getString("speciality")); user.setPreference(rs.getString("preference")); user.setProvince(rs.getString("province")); user.setCity(rs.getString("city")); user.setDistrict(rs.getString("district")); user.setAddress(rs.getString("address")); user.setCreatedOn(rs.getTimestamp("created_on")); user.setEnable(rs.getBoolean("enable")); return user; }