分页
来源:互联网 发布:开淘宝店没有营业执照 编辑:程序博客网 时间:2024/06/05 11:24
需要两个jar包
jsqlparser-0.9.4.jar
pagehelper-4.1.1.jar
在beans.xml中的sqlsessionfactory中加
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageHelper">
<property name="properties">
<value>
dialect=mysql
</value>
</property>
</bean>
</array>
</property>
<!--controller-->
@RequestMapping("/page")
public String showCityList(HttpServletRequest request,
@RequestParam(required=true,defaultValue="1") Integer page,
@RequestParam(required=false,defaultValue="10") Integer pageSize) throws Exception{
PageHelper.startPage(page,pageSize);
List<Score> list = scoreService.findAll();
PageInfo<Score> p=new PageInfo<Score>(list);
//System.out.println(p.getList());
request.setAttribute("list", list);
request.setAttribute("page", p);
return "jsp/admin/index2";
}
<!--request域中p的属性->
p{pageNum=1, pageSize=10, size=10, startRow=1, endRow=10, total=16, pages=2, list=Page{count=true, pageNum=1, pageSize=10, startRow=0, endRow=10, total=16, pages=2, countSignal=false, orderBy='null', orderByOnly=false, reasonable=false, pageSizeZero=false}, firstPage=1, prePage=0, nextPage=2, lastPage=2, isFirstPage=true, isLastPage=false, hasPreviousPage=false, hasNextPage=true, navigatePages=8, navigatepageNums=[1, 2]}