Hibernate SQL写法

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 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 list = query.list();
if (list == null || list.size() < 1)
return null;
else
return list;

}