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