controller:
/**
* 分页查询方法
*/
@ResponseBody
@GetMapping("/smsUserMaintenancePlanReview/dataPage")
@ApiOperation(value = "获取分页数据", notes = "获取分页数据")
public ResultData dataPage(@RequestParam(required = false, defaultValue = "0", value = "pageNum") int pageNum,@RequestParam(required = false, defaultValue = "10", value = "pageSize") int pageSize){
Page<SmsUserMaintenancePlanReview> smsUserMaintenancePlanReviewPage;
try{
Map<String, Object> queryMap=new HashMap<>(2);
queryMap.put("delFlag_EQ",false);
Sort sort=new Sort(Sort.Direction.DESC,"createDate");
smsUserMaintenancePlanReviewPage = smsUserMaintenancePlanReviewService.findAll(queryMap,pageNum,pageSize,sort);
}catch(Exception e){
return ResultData.getFailResult(e.getMessage());
}
return ResultData.getSuccessResult(smsUserMaintenancePlanReviewPage);
}
分页帮助类:
package com.byzx.vo;
import java.util.List;
public class PageUtil {
// 每页显示条数
private Integer pageSize ;
// 总条数
private Integer totalNum ;//= 0;
// 当前页码
private Integer pageNum ;//= 1;
// 总页数
private Integer pageCount ;//= 0;
// limit下标,limit第一个参数
private Integer limitIndex ;//= 0;
// 存储返回的集合对象
private List<?> resultList;
// 请求地址, user/list.action
private String url;
// 请求参数(搜索条件参数的封装), userCode=admin&userType=1&userState=1
private StringBuffer params;
//定义无参构造
public PageUtil(){
}
// 有参构造(每页显示条数,当前页)
public PageUtil(Integer pageSize,Integer pageNum){
this.pageSize = pageSize;
this.pageNum = pageNum;
}
//有参构造 (每页显示条数,总条数,当前页码,返回集合对象,请求地址,模糊查询输入的参数)
public PageUtil(Integer pageSize,Integer totalNum,Integer pageNum,List<?> resultList,String url,StringBuffer params){
this.pageSize = pageSize;
this.totalNum = totalNum;
this.pageNum = pageNum;
this.resultList = resultList;
this.url = url;
this.params = params;
}
public Integer getPageSize() {
return pageSize;
}
public void setPageSize(Integer pageSize) {
this.pageSize = pageSize;
}
public Integer getPageNum() {
return pageNum;
}
public void setPageNum(Integer pageNum) {
this.pageNum = pageNum;
}
public Integer getTotalNum() {
return totalNum;
}
public void setTotalNum(Integer totalNum) {
this.totalNum = totalNum;
}
// 获取总页数
public Integer getPageCount() {
pageCount=(totalNum%pageSize==0)?(totalNum/pageSize):(totalNum/pageSize)+1;
return pageCount;
}
public void setPageCount(Integer pageCount) {
this.pageCount = pageCount;
}
// 获取limit第一个下标的值
public Integer getLimitIndex() {
limitIndex = pageSize*(pageNum-1);
return limitIndex;
}
public void setLimitIndex(Integer limitIndex) {
this.limitIndex = limitIndex;
}
public List<?> getResultList() {
return resultList;
}
public void setResultList(List<?> resultList) {
this.resultList = resultList;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public StringBuffer getParams() {
return params;
}
public void setParams(StringBuffer params) {
this.params = params;
}
@Override
public String toString() {
return "PageUtil [pageSize=" + pageSize + ", totalNum=" + totalNum + ", pageNum=" + pageNum + ", pageCount="
+ pageCount + ", limitIndex=" + limitIndex + ", resultList=" + resultList + ", url=" + url + ", params="
+ params + "]";
}
}
mapper:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.byzx.dao.PlaceMapper">
<resultMap id="PlaceMap" type="Place" >
<id column="place_id" property="placeId" />
<result column="place_name" property="placeName" />
<result column="place_num" property="placeNum" />
<result column="introduce" property="introduce" />
</resultMap>
<select id="fullCheckPlace" parameterType="HashMap" resultMap="PlaceMap">
select * from place
<where>
<if test="Place.placeNum != null and Place.placeNum != '' " >
AND place_num LIKE concat("%",#{Place.placeNum},"%")
</if>
<if test="Place.placeName != null and Place.placeName != ''">
AND place_name LIKE concat("%",#{Place.placeName},"%")
</if>
</where>
<if test="PageUtil != null">
LIMIT #{PageUtil.limitIndex},#{PageUtil.pageSize}
</if>
</select>
<!-- 添加产地 -->
<insert id="addPlace" parameterType="Place">
INSERT INTO `shopping`.`place` (`place_name`, `place_num`, `introduce`) VALUES (#{placeName}, #{placeNum}, #{introduce});
</insert>
<!-- 查询产地和编号是否存在 -->
<select id="isPlace" parameterType="Place" resultType="Integer">
select count(*) sum from place
<where>
<if test="placeName != null and placeName != ''">
place_name=#{placeName}
</if>
<if test="placeNum != null and placeNum != ''">
place_num=#{placeNum}
</if>
</where>
</select>
<!-- 删除产地 -->
<delete id="deletePlace" parameterType="String">
delete from place where place_id=#{placeId}
</delete>
<!-- 更新产地 -->
<update id="updatePlace" parameterType="Place">
UPDATE `shopping`.`place` SET `place_name` = #{placeName} , `place_num` = #{placeNum} , `introduce` = #{introduce} WHERE `place_id` = #{placeId};
</update>