Model代碼
public class AlbumClassInfoModel implements Serializable {
private static final long serialVersionUID = -3068715909100052519L;
/**分類ID*/
private Long classId;
/**分類名稱*/
private String className;
/**相冊總數*/
private int albumCountNum;
}
public class AlbumClassInfoModel implements Serializable {
private static final long serialVersionUID = -3068715909100052519L;
/**分類ID*/
private Long classId;
/**分類名稱*/
private String className;
/**相冊總數*/
private int albumCountNum;
} 使用:
使用代碼
public List<AlbumClassInfoModel> getAlbumClassInfoByUserId(String userId) {
String sql = “select classId,count(*) as albumCountNum from w_album_list t where userid=? group by classid”;
Query query = this.getCurrentSession().createSQLQuery(sql)
.addScalar(“classId”, Hibernate.LONG)
.addScalar(“albumCountNum”, Hibernate.INTEGER)
.setResultTransformer(Transformers.aliasToBean(AlbumClassInfoModel.class));
query.setParameter(0, userId);
List<AlbumClassInfoModel> list = query.list();
if (list == null || list.size() < 1)
return null;
else
return list;
}
