MyBatis分页查询案例

// mybatis使用pageHelper插件分页查询
public PageResult pageQuery(EmployeePageQueryDTO employeePageQueryDTO) {
        PageHelper.startPage(employeePageQueryDTO.getPage(), employeePageQueryDTO.getPageSize());
        Page<Employee> page = employeeMapper.pageQuery(employeePageQueryDTO);
        return new PageResult(page.getTotal(), page.getResult());
}

<!-- mapper.xml文件 -->
<select id="pageQuery" resultType="com.sky.entity.Employee">
    select id,name,username,phone,sex,id_number,status,create_time,update_time,create_user,update_user from employee
    <where>
        <if test="name != null and name != ''">and name like concat('%',#{name},'%')</if>
    </where>
    order by create_time desc
</select>

# mapper配置文件
mybatis:
  mapper-locations: classpath:mapper/*.xml # mapper.xml扫描
  type-aliases-package: com.sky.entity # 包扫描
  configuration:
    #开启驼峰命名
    map-underscore-to-camel-case: true
# 开启debug日志
logging:
  level:
    com:
      sky:
        mapper: debug
        service: info
        controller: info