Hibernate SQL写法

最新推荐文章于 2022-06-17 10:38:35 发布

wenjinglian

最新推荐文章于 2022-06-17 10:38:35 发布

阅读量653

点赞数

分类专栏： Hibernate 文章标签： SQL Hibernate

本文链接：https://blog.csdn.net/wenjinglian/article/details/83945221

版权

Hibernate 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

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