Hibernate SQL写法

 

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;
        
    }