读书人

hibernate的使用地图返回数据

发布时间: 2013-07-09 09:50:48 作者: rapoo

hibernate的使用map返回数据
@SuppressWarnings("unchecked")public Page<?> getDisCheckunitinfoByPlanUuid(String planUuid,int pageNo,int pageSize){Page page = new Page();page.setPageNo(pageNo);page.setPageSize(pageSize);//0 未删除 1 已删除//0 未选 1已选StringBuffer sb = new StringBuffer();sb.append("select new map( ");sb.append("s.planUuid as planUuid, ");sb.append("s.checkunitName as checkunitName, ");sb.append("s.checkunitUuid as checkunitUuid, ");sb.append("s.address as address, ");sb.append("nzk.numFromCenter as numFromCenter )");sb.append("from NationCheckunitinfo s ,NationZonecheck nzk ");sb.append(" where s.isdel != 1 ");//判断选中状态为空sb.append(" and s.note = 1 ");sb.append(" and s.checkunitUuid = nzk.checkunitUuid ");if(StrUtil.isNotNull(planUuid)){sb.append(" and s.planUuid = '").append(planUuid+"'");}return this.findPage(page, sb.toString(), new HashMap<String,String>());}

?

?

?

读书人网 >其他数据库

热点推荐