mybatisplus分页查询
1、mapper层接口需要定义param
Page<Employee> employeePage(Page<Employee> page,
@Param("employeePageQueryDTO")EmployeePageQueryDTO employeePageQueryDTO);
需要先封装一个Page对象,第二个查询条件值上需要加上@Param(“employeePageQueryDTO”)
2、mapper.xml文件
<mapper namespace="com.sky.mapper.EmployeeMapper">
<select id="employeePage" resultType="com.sky.entity.Employee">
select * from employee
<where>
<if test="employeePageQueryDTO.name != null and employeePageQueryDTO.name != ''">
and name like concat('%',#{employeePageQueryDTO.name}),'%')
</if>
</where>
order by create_time desc
</select>
</mapper>
注意,test语句里面不是test="name != null and name != ''"
而是test="employeePageQueryDTO.name != null and employeePageQueryDTO.name != ''"
需要加上对象.属性。不然识别不出来。