mapper.xml文件内写法
select t2.* from
(select rownum rn,t1.* from
(select rownum, routing.* from ESB_ROUTING routing
<where>
<if test="jkid != null and jkid != ''">
and JKID = #{jkid,jdbcType=VARCHAR}
</if>
<if test="jgid != null and jgid != ''">
and JGID = #{jgid,jdbcType=VARCHAR}
</if>
</where>
)t1
where rownum <=#{pageSize}) t2
where rn>#{pageInt}