public List<SelectItem> PBingCount(Integer dbid) {
// TODO Auto-generated method stub
String sql = " select COUNT(t.ptypeid) value ,ty.typename name "+
" from sheet_info i ,sheet_item t ,item_type ty "+
" where t.ptypeid = ty.id and t.sheetid = i.id and i.delflag =1 ";
if(dbid!=null){
sql+="and i.dbid=2 ";
}
sql+="GROUP BY t.ptypeid ,ty.typename ";
NativeQuery query = super.getSession().createNativeQuery(sql);
//指定返回对象类型
query.unwrap(NativeQueryImpl.class).setResultTransformer(Transformers.aliasToBean( SelectItem.class));
return query.list();
}
HQL-查询返回Object 类型 修改 返回对象
最新推荐文章于 2021-10-19 17:05:02 发布