return MAPPER;
}
public SpotCharacteristic mapRow(ResultSet rs, int rowNum)
throws SQLException {
SpotCharacteristic sc = new SpotCharacteristic();
sc.setId(Long.valueOf(rs.getString(COLUMN_ID)));
sc.setPortrait(rs.getString(COLUMN_PORTRAIT));
sc.setSpotId(rs.getLong(COLUMN_SPOT_ID));
sc.setSpotName(rs.getString(COLUMN_SPOT_NAME));
sc.setSpotPortrait(rs.getString(COLUMN_SPOT_PORTRAIT));
sc.setOwnerId(Long.valueOf(rs.getString(COLUMN_OWNER_ID)));
sc.setOwnerNickname(rs.getString(COLUMN_OWNER_NICKNAME));
sc.setOwnerPortrait(rs.getString(COLUMN_OWNER_PORTRAIT));
sc.setCreatorId(Long.valueOf(rs.getString(COLUMN_CREATOR_ID)));
sc.setCreatorNickname(rs.getString(COLUMN_CREATOR_NICKNAME));
sc.setCreatorPortrait(rs.getString(COLUMN_CREATOR_PORTRAIT));
sc.setCharacteristicTitle(rs.getString(COLUMN_CHARA_TITLE));
sc.setCharacteristicDetail(rs.getString(COLUMN_CHARA_DETAIL));
sc.setConsume(rs.getInt(COLUMN_CONSUME));
sc.setAlbumId(rs.getLong(COLUMN_ALBUM_ID));
sc.setStar(rs.getFloat(COLUMN_STAR));
sc.setVotes(rs.getInt(COLUMN_VOTES));
sc.setCreateTime(rs.getDate(COLUMN_CREATETIME));
sc.setUpdateTime(rs.getDate(COLUMN_UPDATETIME));
sc.setActivity(Activity.valueOf((rs.getString(COLUMN_ACTIVITY))));
return sc;
}