关于springboot分页查询

```java
1.pom依赖
<!--分页-->
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper-spring-boot-starter</artifactId>
			<version>1.2.3</version>
		</dependency>
2.控制层
  //设置分页信息，分别是当前页数和每页显示的总记录数【记住：必须在mapper接口中的方法执行之前设置该分页信息】
           @RequestMapping("/findByPage")
    public ResultInfo getHeeltourList(sDistributionGrowth record, @RequestParam("page") Integer page, @RequestParam("size") Integer size) {
        try {
            PageHelper.startPage(page, size);
            List<sDistributionGrowth> list = sDistributionGrowthService.growthList(record);
            int count = sDistributionGrowthService.growthCount(record);
            return new ResultInfo(ServerMsgEnum.SUCCESS.getServerCode(), ServerMsgEnum.SUCCESS.getServerMsg(), count, list);
        } catch (Exception e) {
            return new ResultInfo(ServerMsgEnum.FAIL.getServerCode(), ServerMsgEnum.FAIL.getServerMsg());
        }
    }
    }

模糊查询
1、mysql ：LIKE CONCAT(’%’,#{empname},’%’ ) 或者 LIKE CONCAT(’%’,‘${empname}’,’%’ )

2、oracle：LIKE ‘%’||#{empname}||’%’
3.like ‘%$customnameconcat{(}^{\prime }${customname}’,’%’)

sdr.setCheckStatusStr(sdr.getCheckstatus()==0?“未检”:“已检”);