基于IBATIS的自定义jsp分页标签

最新推荐文章于 2021-08-30 22:43:58 发布

iteye_10631

最新推荐文章于 2021-08-30 22:43:58 发布

阅读量166

点赞数

CC 4.0 BY-SA版权

分类专栏： Ibatis 文章标签： iBATIS JSP SQL Oracle Apache

本文链接：https://blog.youkuaiyun.com/iteye_10631/article/details/81886998

Ibatis 专栏收录该内容

8 篇文章

订阅专栏

IBATIS中SQLSERVER和ORACLE的集合通用分页代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sql id="PaginationTop">
   <isNotEmpty property="CURRENTPAGE"><isNotEmpty property="PAGESIZE">
    <![CDATA[
     SELECT TOP $PAGESIZE$ * FROM (
    ]]>
   </isNotEmpty></isNotEmpty>
</sql>


<sql id="PaginationMid">
   <isNotEmpty property="CURRENTPAGE"><isNotEmpty property="PAGESIZE">
    <![CDATA[
     ) TEMP WHERE ID NOT IN
             (SELECT TOP $CURRENTPAGE$ ID FROM (
    ]]>
   </isNotEmpty></isNotEmpty>
</sql>

<sql id="PaginationEnd">
   <isNotEmpty property="CURRENTPAGE"><isNotEmpty property="PAGESIZE">
    <![CDATA[
     ) TEMP)
    ]]>
   </isNotEmpty></isNotEmpty>
</sql>


<sql id="orderBy">
   <dynamic prepend="ORDER BY">
    <isNotEmpty prepend="," property="sortField">
     $sortField$
    </isNotEmpty>
   </dynamic>
</sql>

<sql id="paginationStart">
   <dynamic prepend="">
    <isNotEmpty property="RowNumStart">
     <![CDATA[
       select * from(select row_.*, rownum ROWNUM_ from(
       ]]>
    </isNotEmpty>
    <isEmpty property="RowNumStart">
     <![CDATA[
      select * from(select row_.*, rownum ROWNUM_ from(
       ]]>
    </isEmpty>
   </dynamic>
</sql>

<sql id="paginationEnd">
   <dynamic prepend="">
    <isNotEmpty property="RowNumEnd">
     <![CDATA[
         )row_ where rownum<=#RowNumEnd#) where ROWNUM_ >= #RowNumStart#
        ]]>
    </isNotEmpty>
    <isEmpty property="RowNumEnd">
     <![CDATA[
       )row_ where rownum<=17) where ROWNUM_ >= 1
       ]]>
    </isEmpty>
   </dynamic>
</sql>

<sql id="orderBy">
   <dynamic prepend="ORDER BY">
    <isNotEmpty prepend="," property="sortField">
     $sortField$
    </isNotEmpty>
   </dynamic>
</sql>
</sqlMap>