hibernate sql查询转换成VO返回list
hibernate sql查询转换成VO@Override public List<FenxiVo> getTuanDuiFenxiList(FenxiVo FenxiVo,Integer pageNo,IntegerpageSize){
String sql="SELECTb.tuanhao,"+" t.chebiao,u.name ASxiaoshouname"+" FROMBaoMing b"+" LEFT JOIN ChuInfo c ON t.id=c.fentuanid where 1=1";if(FenxiVo.getXiaoshouname()!=null){
sql+=" and u.name like '%"+FenxiVo.getXiaoshouname()+"%'";
}
Query query=this.getSession().createSQLQuery(sql);
query.setMaxResults(pageSize);
query.setFirstResult((pageNo-1)*pageSize);
List<FenxiVo> list= (List<FenxiVo>) query.setResultTransformer(Transformers.aliasToBean(FenxiVo.class)).list();//List<FenxiVo> list =query.list();returnlist;
}