<select id="pageQuery" resultType="java.util.HashMap" parameterType="java.util.HashMap">
select *
from
(select rownum resnum,
字段
from 表
where 条件
<if test="sort != null">
order by ${sort} ${order} //sort:字段 order:正倒序 easyui配置sortable : true,直接在controller里接就行,用sort和order
</if>
) res
<![CDATA[
where res.resnum>#{startNumber,jdbcType=DECIMAL } and res.resnum<=#{endNumber,jdbcType=DECIMAL }
]]>
</select>
mybatis+easyui+Oracle分页查询
最新推荐文章于 2024-08-18 02:19:06 发布