MyBatis分页查询案例
原创
©著作权归作者所有:来自51CTO博客作者蒋劲豪7的原创作品,请联系作者获取转载授权,否则将追究法律责任
// 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