@Cache(keyPattern = "photo-l-f-album:aid-auth:auth", type = CacheCategoryType.PHOTO)
public List<Photo> queryPhotoFilesOfAlbum(@Param("aid") @Fk long albumId,
@Param("auth") int authority) {
return jdbcTemplate.query(queryPhotoFilesOfAlbumSql, new RowMapper<Photo>() {
public Photo mapRow(ResultSet rs, int rowNum) throws SQLException {
Photo photo = new Photo();
photo.setId(rs.getLong(PhotoMapper.COLUMN_ID));
photo.setMiddleFile(rs.getString(PhotoMapper.COLUMN_MIDDLE_FILE));
photo.setSmallFile(rs.getString(PhotoMapper.COLUMN_SMALL_FILE));
photo.setExt(rs.getString(PhotoMapper.COLUMN_EXT));
photo.setSize(rs.getLong(PhotoMapper.COLUMN_SIZE));
photo.setOrderNo(rs.getInt(PhotoMapper.COLUMN_ORDERNO));
return photo;
}
}, albumId, authority, Activity.NORMAL.toString(), Activity.UNDELETABLE.toString());
}