关于mybatis中对mysql和Oracle数据库分页插件的使用

最新推荐文章于 2024-08-19 08:45:16 发布

静风落叶

最新推荐文章于 2024-08-19 08:45:16 发布

阅读量3.5k

点赞数 1

分类专栏： mybatis 文章标签： mybatis 插件分页 oracle 数据库

本文链接：https://blog.csdn.net/qq_34178998/article/details/78753744

版权

mybatis 专栏收录该内容

12 篇文章 2 订阅

订阅专栏

首先是Oracle数据库：在mybatis相对应的mapper.xml文件里：

<sql id="OracleDialectPrefix">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Thu Nov 30 16:41:13 CST 2017.
    -->
    <if test="page != null">
      select * from ( select row_.*, rownum rownum_ from ( 
    </if>
  </sql>
  <sql id="OracleDialectSuffix">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Thu Nov 30 16:41:13 CST 2017.
    -->
    <if test="page != null">
      <![CDATA[ ) row_ ) where rownum_ > #{page.startRow} and rownum_ <= #{page.startRow} + #{page.pageSize} ]]>
    </if>
  </sql>

在Oracle数据库中要有两条sql包着的分页语句，然后具体用的时候：

 <select id="selectByExampleForCamera" parameterType="com.vrview.ssm.model.example.DeviceExample" resultMap="ResultMapForCamera">
    <include refid="OracleDialectPrefix" />
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from CFG_DEVICE
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    <include refid="OracleDialectSuffix" />
  </select>

要在查询语句一前一后。

2、再看msql的分页

分页代码：

<sql id="MysqlDialectSuffix">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Wed Jun 14 15:39:27 CST 2017.
    -->
    <if test="page != null">
      <![CDATA[ limit #{page.startRow},#{page.pageSize} ]]>
    </if>
  </sql>

用到语句中：

<select id="selectByExampleWithPolicy" parameterType="cn.vrview.sa.model.example.LevDeviceExample" resultMap="BaseResultWithPolicyMap">
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from LEV_DEVICE
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    <include refid="MysqlDialectSuffix" />
  </select>

只要放在select语句句末就行。