sidePagination:'client',
queryParams : function (params) {
var temp = {
name:$('#search_name').val(),
tel:$('#search_tel').val()
};
return temp;
},
▶ 定义user对象
package com.debo.common;
public class User {
private Integer id;
private String loginName;
private String name;
private String tel;
private Integer sex;
//省略Get/Set函数
}
▶ 服务器Controller层代码
/**
*直接一次性查出所有的数据,返回给前端，bootstrap-table自行分页
*/
@RequestMapping("/getUserListPage")
@ResponseBody
public List getUserListPage(User user,HttpServletRequest request){
List list = userService.getUserListPage(user);
return list;
}
▶ mabatis语句
SELECT * FROM user WHERE 1 = 1
AND name LIKE CONCAT('%',#{name},'%')
AND tel = #{tel}
package com.debo.common;
public class Page {
//每页显示数量
private int limit;
//页码
private int page;
//sql语句起始索引
private int offset;
public int getLimit() {
return limit;
}
public void setLimit(int limit) {
this.limit = limit;
}
public int getPage() {
return page;
}
public void setPage(int page) {
this.page = page;
}
public int getOffset() {
return offset;
}
public void setOffset(int offset) {
this.offset = offset;
}
}
package com.debo.common;
public class User extends Page{
private Integer id;
private String loginName;
private String name;
private String tel;
private Integer sex;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getLoginName() {
return loginName;
}
public void setLoginName(String loginName) {
this.loginName = loginName;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
public Integer getSex() {
return sex;
}
public void setSex(Integer sex) {
this.sex = sex;
}
}
▶ 封装返回数据实体类
package com.debo.common;
import java.util.ArrayList;
import java.util.List;
public class PageHelper {
//实体类集合
private List rows = new ArrayList();
//数据总条数
private int total;
public PageHelper() {
super();
}
public List getRows() {
return rows;
}
public void setRows(List rows) {
this.rows = rows;
}
public int getTotal() {
return total;
}
public void setTotal(int total) {
this.total = total;
}
}
▶ 服务器Controller层代码
@RequestMapping("/getUserListPage")
@ResponseBody
public PageHelper getUserListPage(User user,HttpServletRequest request) {
PageHelper pageHelper = new PageHelper();
// 统计总记录数
Integer total = userService.getTotal(user);
pageHelper.setTotal(total);
// 查询当前页实体对象
List list = userService.getUserListPage(user);
pageHelper.setRows(list);
return pageHelper;
}
▶ mybatis语句
SELECT count(1) FROM user WHERE 1 = 1
AND name LIKE CONCAT('%',#{name},'%')
AND tel = #{tel}
SELECT * FROM user WHERE 1 = 1
AND name LIKE CONCAT('%',#{name},'%')
AND tel = #{tel}
LIMIT #{offset},#{limit}
