@Override
public Invitation mapRow(ResultSet rs, int rowNum) throws SQLException {
Invitation in = new Invitation();
try {
in.setId(rs.getLong(COLUMN_ID));
in.setOwerId(rs.getLong(COLUMN_OWER_ID));
in.setFanId(rs.getLong(COLUMN_FAN_ID));
in.setFanNickname(rs.getString(COLUMN_FAN_NICKNAME));
in.setFanPortait(rs.getString(COLUMN_FAN_PORTRAIT));
in.setSpotId(rs.getLong(COLUMN_SPOT_ID));
in.setSpotName(rs.getString(COLUMN_SPOT_NAME));
in.setContent(rs.getString(COLUMN_CONTENT));
in.setInvitingTime(rs.getDate(COLUMN_INVITING_TIME));
in.setAppointmentTime(rs.getDate(COLUMN_APPOINTMENT_TIME));
in.setActivity(Activity.valueOf(rs.getString(COLUMN_ACTIVITY)));
} catch (Exception e) {
e.printStackTrace();
}