SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM cul_system.up_org_user where 1=1
<if test="user_fullname!=null">
and user_fullname like '%'||#{user_fullname}||'%'
</if>
<if test="orderField!=null">
order by ${orderField} ${orderDirection}
</if>
) A
WHERE ROWNUM <= (#{numPerPage}*#{pageNum})
) B
WHERE RN > (#{numPerPage}*(#{pageNum}-1))
Mybatis中分页、排序、like
最新推荐文章于 2023-11-27 20:43:08 发布