基于Oracle数据库的Ibatis分页sql配置

最新推荐文章于 2021-04-15 20:52:07 发布

sungang1120

最新推荐文章于 2021-04-15 20:52:07 发布

阅读量182

点赞数

分类专栏：细细品味-Ibatis 文章标签：数据库

本文链接：https://blog.csdn.net/sungang1120/article/details/84393280

版权

细细品味-Ibatis 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

select * from
        (select top $endCount$ * from sys_news
        where news_type = #newsType# and isdelete=#isdelete#
          <dynamic prepend=" and ">
         <isNotEmpty prepend=" and " property="title">title like '%$title$%'</isNotEmpty>
         </dynamic>
         order by create_date desc
         ) ns
    where ns.newsid not in
        ( select top $startCount$ newsId from sys_news
          where news_type = #newsType# and isdelete=#isdelete#
          <dynamic prepend=" and ">
         <isNotEmpty prepend=" and " property="title">title like '%$title$%'</isNotEmpty>
         </dynamic>
         order by create_date desc
         )

            select * from (
             select sn.*,rownum r from sys_news sn
                where rownum <= $endCount$ and sn.news_type =#newsType# and sn.isdelete=#isdelete#

                    <dynamic prepend=" and ">
                         <isNotEmpty prepend=" and " property="title">title like '%$title$%'</isNotEmpty>
                       </dynamic>
                order by create_date desc) where r > $startCount$

二

<![CDATA[
               SELECT * FROM (SELECT row_.*, rownum r FROM
                 (select sn.* from sys_news sn
                   where sn.news_type =#newsType# and sn.isdelete =#isdelete#

                     ) row_ WHERE rownum <= $endCount$ )row_ WHERE r > $startCount$
                       ORDER BY create_date desc
                       ]]>

三

select * from (
             select sn.*,rownum r from sys_news sn
                where rownum <= $endCount$ and sn.news_type ='$newsType$' and sn.isdelete='$isdelete$'

                    <dynamic prepend=" and ">
                         <isNotEmpty prepend=" and " property="title">title like '%$title$%'</isNotEmpty>
                       </dynamic>
                order by create_date desc) where r > $startCount$