環(huán)境

框架：spring+springmvc+mybatis

pom.xml

<!-- 引入mybatis的 pagehelper 分頁插件 --> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>5.1.2</version> </dependency>

配置全局配置文件

在mybatis的全局配置文件中配置PageHelper分頁插件

<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE configurationPUBLIC '-//mybatis.org//DTD Config 3.0//EN''http://mybatis.org/dtd/mybatis-3-config.dtd'><configuration> <!-- 引入 pageHelper插件 --> <!--注意這里要寫成PageInterceptor, 5.0之前的版本都是寫PageHelper, 5.0之后要換成PageInterceptor--> <plugins> <plugin interceptor='com.github.pagehelper.PageInterceptor'> <!--reasonable：分頁合理化參數(shù)，默認(rèn)值為false,直接根據(jù)參數(shù)進(jìn)行查詢。 當(dāng)該參數(shù)設(shè)置為 true 時，pageNum<=0 時會查詢第一頁， pageNum>pages（超過總數(shù)時），會查詢最后一頁。--> <!--<property name='reasonable' value='true'/>--> </plugin> </plugins></configuration>

使用

例如：實(shí)現(xiàn)對用戶的多條件查詢

package com.szfore.model;import java.util.Date;import java.util.List;public class User {private Integer id;private String uname;private String pwd;private String name;private Integer sex;private String phone;private String company;private String jobtitle;private String birth;private Date createdate;private Date lastlogintime;private List<Role> roleList;public List<Role> getRoleList() {return roleList;}public void setRoleList(List<Role> roleList) {this.roleList = roleList;}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUname() {return uname;}public void setUname(String uname) {this.uname = uname == null ? null : uname.trim();}public String getPwd() {return pwd;}public void setPwd(String pwd) {this.pwd = pwd == null ? null : pwd.trim();}public String getName() {return name;}public void setName(String name) {this.name = name == null ? null : name.trim();}public Integer getSex() {return sex;}public void setSex(Integer sex) {this.sex = sex;}public String getPhone() {return phone;}public void setPhone(String phone) {this.phone = phone == null ? null : phone.trim();}public String getCompany() {return company;}public void setCompany(String company) {this.company = company == null ? null : company.trim();}public String getJobtitle() {return jobtitle;}public void setJobtitle(String jobtitle) {this.jobtitle = jobtitle == null ? null : jobtitle.trim();}public String getBirth() {return birth;}public void setBirth(String birth) {this.birth = birth == null ? null : birth.trim();}public Date getCreatedate() {return createdate;}public void setCreatedate(Date createdate) {this.createdate = createdate;}public Date getLastlogintime() {return lastlogintime;}public void setLastlogintime(Date lastlogintime) {this.lastlogintime = lastlogintime;}}

UserMapper

注意：mapper中就按不分頁的那種寫法就好

package com.szfore.dao;import com.szfore.model.User;import com.szfore.model.UserExample;import java.util.List;import org.apache.ibatis.annotations.Param;import org.springframework.stereotype.Repository;@Repositorypublic interface UserMapper { /** * 多條件分頁查詢 * @param userParam * @return */ public List<User> queryByPage(User userParam);}

UserMapper.xml

注意：sql中就不要寫limit了，pageHelp會自己處理，sql就按不分頁的那種寫法就好

<!--多條件分頁查詢用戶--> <select resultType='com.szfore.model.User'> SELECT * FROM `user` <WHERE> <if test='id != null and id != ’’'> AND id = #{id} </if> <if test='uname != null and uname != ’’'> AND uname = #{uname} </if> <if test='name != null and name != ’’'> AND name like ’%${name}%’ </if> <if test='phone != null and phone != ’’'> AND phone like ’%${phone}%’ </if> <if test='company != null and company != ’’'> AND company like ’%${company}%’ </if> <if test='jobtitle != null and jobtitle != ’’'> AND jobTitle like ’%${jobtitle}%’ </if> <if test='birth != null and birth != ’’'> AND birth like ’%${birth}%’ </if></WHERE> </select>

UserServiceImpl

package com.szfore.service.impl;import com.github.pagehelper.PageHelper;import com.github.pagehelper.PageInfo;import com.szfore.dao.MenuMapper;import com.szfore.dao.UserMapper;import com.szfore.dao.UserRoleMapper;import com.szfore.model.*;import com.szfore.service.IUserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import javax.servlet.http.HttpSession;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;@Servicepublic class UserServiceImpl implements IUserService{ @Autowired private UserMapper userMapper; @Autowired private MenuMapper menuMapper; @Autowired private UserRoleMapper userRoleMapper; /** * 多條件分頁查詢用戶 * @param userParam * @param pageNum * @param pageSize * @return */ public Json queryByPage(User userParam,Integer pageNum,Integer pageSize) { //利用PageHelper分頁查詢 注意：這個一定要放查詢語句的前一行,否則無法進(jìn)行分頁,因?yàn)樗鼘o隨其后第一個sql語句有效 PageHelper.startPage(pageNum, pageSize); List<User> userList = userMapper.queryByPage(userParam); PageInfo<User> pageInfo = new PageInfo<User>(userList); Json json = new Json(); json.setMsg('成功！'); json.setObj(pageInfo); json.setSuccess(true); return json; }}

說明：PageInfo是PageHelper自帶的分頁對象類，詳情如下：

當(dāng)前頁private int pageNum;每頁的數(shù)量private int pageSize;當(dāng)前頁的數(shù)量private int size;//由于startRow和endRow不常用，這里說個具體的用法 //可以在頁面中'顯示startRow到endRow 共size條數(shù)據(jù)'

當(dāng)前頁面第一個元素在數(shù)據(jù)庫中的行號private int startRow;當(dāng)前頁面最后一個元素在數(shù)據(jù)庫中的行號private int endRow;總記錄數(shù)private long total;總頁數(shù)private int pages;結(jié)果集private List<T> list;

第一頁private int firstPage;前一頁private int prePage;

是否為第一頁private boolean isFirstPage = false;是否為最后一頁private boolean isLastPage = false;是否有前一頁private boolean hasPreviousPage = false;是否有下一頁private boolean hasNextPage = false;導(dǎo)航頁碼數(shù)private int navigatePages;所有導(dǎo)航頁號private int[] navigatepageNums;

通過PageInfo獲取其他信息

PageHelper.startPage(req.getCurrentPage(), req.getPageSize(), true);List<SecurityRiskLibary> list=securityRiskLibaryDAO.queryList(srl);PageInfo page=new PageInfo(list);page.getTotal();page.xxxx

以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持好吧啦網(wǎng)。