1、mapper中重写Page
Page<UserResult> getPage(@Param("page") Page page, @Param("query") UserQuery query);
2、xml中sql语句
<select id="getPage" resultType="com.sll.result.UserResult">
select *
from(
select u.*,c.*
from user u
inner join classroom c
on u.cid=c.id
where deleted=0) as a
<where>
<if test="query.cName!=null and query.cName!=''">
and a.cName like concat('%',#{query.cName},'%')
</if>
</where>
order by a.create_date_time desc
</select>
3、UserServiceImpl层实现分页查询
public Page<UserResult> getPage(UserQuery query) {
return this.getBaseMapper().getPage(new Page(query.getPageNo(), query.getPageSize()),query);
}