jpa 分页功能1

最新推荐文章于 2022-09-16 11:57:55 发布

mayunyun1987100

最新推荐文章于 2022-09-16 11:57:55 发布

阅读量486

点赞数

分类专栏： jpa

本文链接：https://blog.csdn.net/mayunyun1987100/article/details/38942639

版权

jpa 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

1.service 层

public Result findAllAdvertise(Page page,String categoryId){
    	StringBuffer sql1 = new StringBuffer();
    	StringBuffer sql2 = new StringBuffer();
    	sql1.append("select count(*) from Advertise a");
    	sql2.append("from Advertise a where 1=1");
    	if(categoryId != null && !categoryId.equals("")){
    		sql1.append(" where a.categoryId = ?");
    		sql2.append(" and a.categoryId = ?");
    		sql2.append(" order by a.createtime desc");
    		
    		page = PageUtil.createPage(page, (Long) em.createQuery(sql1.toString()).setParameter(1,categoryId).getSingleResult());
    		return new Result(page,em.createQuery(sql2.toString()).setParameter(1,categoryId).setFirstResult(page.getBeginIndex()).setMaxResults(page.getEveryPage()).getResultList());
    	}else{
    		sql2.append(" order by a.createtime desc");
    		page = PageUtil.createPage(page, (Long) em.createQuery(sql1.toString()).getSingleResult());
        	return new Result(page,em.createQuery(sql2.toString()).setFirstResult(page.getBeginIndex()).setMaxResults(page.getEveryPage()).getResultList());
    	}
    }

2.action 层

@RequestMapping("/webadmin/AderviseList.htm")
public String AderviseList(HttpServletRequest request){
  String categoryId = request.getParameter("categoryId");
  if(categoryId ==null ||categoryId.equals("")){
   categoryId = (String)request.getAttribute("categoryId");
  }
  String currpage =request.getParameter("page");
  if(currpage == null || currpage.equals("")){
   currpage ="1";
  }
  Page page = new Page(20);
  page.setCurrentPage(new Integer(currpage));

  Result list = aderviseBiz.findAllAdvertise(page, categoryId);
  request.setAttribute("aderviselist", list);

  //查询所有类别
  List categoryList = aderviseBiz.findAllAdvertiseCategory();
  request.setAttribute("categoryList",categoryList);
     request.setAttribute("categoryId", categoryId);
  return "/webadmin/AderviseList.vm";
}