usersmapper层,这里写个简单查询语句,参数中加上page参数,
@Select("SELECT * FROM users")
List<Users> selectAllPages(@Param("page") Page<Users> page);
业务简单,这里省略了service层
下面是controller层,实体类名字是Users
@RequestMapping(value = "/list")
@ResponseBody
public Object list(String condition) {
Page<Users> page=new PageFactory<Users>().defaultPage();
List<Users> list=usersMapper.selectAllPages(page);
return super.packForBT(page.setRecords(list));
}
值得注意的是前端页面,一定要把type改成server
$(function () {
var defaultColunms = Users.initColumn();
var table = new BSTable(Users.id, "/users/list", defaultColunms);
table.setPaginationType("server");
Users.table = table.init();
});