return MAPPER;
}
@Override
public Photo mapRow(ResultSet rs, int rowNum) throws SQLException {
Photo photo = new Photo();
photo.setId(rs.getLong(COLUMN_ID));
photo.setOwnerId(rs.getLong(COLUMN_OWNER_ID));
photo.setOwnerNickname(rs.getString(COLUMN_OWNER_NICKNAME));
photo.setOwnerPortrait(rs.getString(COLUMN_OWNER_PORTRAIT));
photo.setAlbumId(rs.getLong(COLUMN_ALBUM_ID));
photo.setAlbumName(rs.getString(COLUMN_ALBUM_NAME));
try {
photo.setDescription(rs.getString(COLUMN_DESCRIPTION));
} catch (SQLException e) {
photo.setDescription(null);
}
photo.setFile(rs.getString(COLUMN_FILE));
photo.setMiddleFile(rs.getString(COLUMN_MIDDLE_FILE));
photo.setSmallFile(rs.getString(COLUMN_SMALL_FILE));
photo.setExt(rs.getString(COLUMN_EXT));
photo.setSize(rs.getLong(COLUMN_SIZE));
photo.setOrderNo(rs.getInt(COLUMN_ORDERNO));
photo.setCommentNum(rs.getInt(COLUMN_COMMENT_NUM));
photo.setVisitNum(rs.getInt(COLUMN_VISIT_NUM));
photo.setUp(rs.getInt(COLUMN_UP));
photo.setDown(rs.getInt(COLUMN_DOWN));
photo.setShareNum(rs.getInt(COLUMN_SHARE_NUM));
photo.setCreateTime(rs.getTimestamp(COLUMN_CREATE_TIME));
photo.setUpdateTime(rs.getTimestamp(COLUMN_UPATE_TIME));
photo.setAuthority(rs.getInt(COLUMN_AUTHORITY));
photo.setActivity(Activity.valueOf(rs.getString(COLUMN_ACTIVITY)));
return photo;
}