pageHelper分页查询

---

前言

本篇文章介绍在java中使用pageHelper完成分页的功能。
使用的数据库为mysql,持久层框架mybatis。

---

一、集成

1.引入库

<!-- pageHelper -->
<dependency>
	<groupId>com.github.pagehelper</groupId>
	<artifactId>pagehelper-spring-boot-starter</artifactId>
	<version>1.2.5</version>
</dependency>

2.配置yml

pagehelper:
    helperDialect: mysql
    reasonable: true
    supportMethodsArguments: true
    params: count=countSql

二、编码

1.Controller

@Controller
@RequestMapping("StudentInfoController")
public class StudentInfoController{
	@Autowired
	private StudentInfoService studentInfoService;

	@PostMapping("lists")
	@ResponseBody
	public Object lists(int pageNum,int pageSize,String name){
		PageInfo<StudentInfo> page=studentInfoService.lists(pageNum,pageSize,name) ;
		StudentResult result=new StudentResult(200, "请求成功", page.getList());
		return  result;
	}
}

2.Service

public class StudentInfoService{
	@Autowired
	private StudentInfoMapper studentInfoMapper;
	/**
	 * 分页查询
	 * @param pageNum
	 * @param pageSize
	 * @param name
	 * @return
	 */
	public PageInfo<StudentInfo> lists(int pageNum,int pageSize,String name){
		PageHelper.startPage(pageNum, pageSize);
		List<StudentInfo> list= studentInfoMapper.selectList(name);
		PageInfo<StudentInfo> pageInfo = new PageInfo<StudentInfo>(list);
		return  pageInfo;
	}
}

3.Mapper

@Repository
public interface StudentInfoMapper {
	List<StudentInfo> selectList(@Param("name") String name);
}

4.Mapper.xml

  <select id="selectList" resultMap="BaseResultMap">
    select * from t_student_info
    <where>
      <if test="name != null">
        name = #{name,jdbcType=VARCHAR}
      </if>
    </where>
    order by CAST(id AS SIGNED)
  </select>

5.StudentResult

public class StudentResult implements Serializable {
    private int code;
    private String msg;
    private Object data;

    public StudentResult() {
    }

    public StudentResult(int code, String msg) {
        this.code = code;
        this.msg = msg;
    }

    public StudentResult(int code, String msg, Object data) {
        this.code = code;
        this.msg = msg;
        this.data = data;
    }

    public int getCode() {
        return code;
    }

    public void setCode(int code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public Object getData() {
        return data;
    }

    public void setData(Object data) {
        this.data = data;
    }

    @Override
    public String toString() {
        return "StudentResult{" +
                "code=" + code +
                ", msg='" + msg + '\'' +
                ", data=" + data +
                '}';
    }
}

三、测试

1.根据页码和页数

2.根据name

---

总结

回到顶部