Jfinal数据库基本操作(四) 分页

使用Template模板

#for(user : page.getList())
#(user.name)———— ${user.password!}

//记得文件需要引入 _paginate.html

#include("_paginate.html")
#@paginate(page.pageNumber, page.totalPage, "/action3/")

 

UserService类

public static Page<UserModel> paginate(int page,int pageSize,Integer sex,String name,String address) {

String select = "select * ";
StringBuffer sqlExceptSelect = new StringBuffer("from user");
boolean addWhere = false;
List<Object> parList = new ArrayList<Object>();
addWhere = AppendFiled(sex, "sex",sqlExceptSelect, addWhere, parList);
addWhere = AppendLike(name, "name",sqlExceptSelect, addWhere, parList);
addWhere = AppendLike(address, "address",sqlExceptSelect, addWhere, parList);
return DAO.paginate(page, pageSize, select , sqlExceptSelect.toString(),parList.toArray());
}

UserController类

public void action3() {

//基于当前页面自动更新

//pageNumber开始的数据，pageSize每页显示的数据熟
int pageNumber = getParaToInt(0, 1);
Page<UserModel> page = UserService.paginate(pageNumber, 2,null,"h",null);

setAttr("page", page);
render("/test.html");
}