limit中start、count设置 jdbcType=INTEGER

liurunyu

2023-11-27 8a9a931d5f8ca0e235e0d263032e386038f917fa

limit中start、count设置 jdbcType=INTEGER

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml

@@ -76,7 +76,7 @@
    order by id DESC
    <trim prefix="limit " >
      <if test="start != null and count != null">
        #{start}, #{count}
        #{start,jdbcType=INTEGER}, #{count,jdbcType=INTEGER}
      </if>
    </trim>
  </select>

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientMapper.xml

@@ -116,7 +116,7 @@
        order by bc.id DESC
        <trim prefix="limit " >
            <if test="start != null and count != null">
                #{start}, #{count}
                #{start,jdbcType=INTEGER}, #{count,jdbcType=INTEGER}
            </if>
        </trim>
    </select>

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientTypeMapper.xml

@@ -55,7 +55,7 @@
    order by id DESC
    <trim prefix="limit " >
      <if test="start != null and count != null">
        #{start}, #{count}
        #{start,jdbcType=INTEGER}, #{count,jdbcType=INTEGER}
      </if>
    </trim>
  </select>

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaDivideMapper.xml

@@ -97,7 +97,7 @@
    order by bd.id DESC
    <trim prefix="limit " >
      <if test="start != null and count != null">
        #{start}, #{count}
        #{start,jdbcType=INTEGER}, #{count,jdbcType=INTEGER}
      </if>
    </trim>
  </select>

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaRoleMapper.xml

@@ -65,7 +65,7 @@
    order by id DESC
    <trim prefix="limit " >
      <if test="start != null and count != null">
        #{start}, #{count}
        #{start,jdbcType=INTEGER}, #{count,jdbcType=INTEGER}
      </if>
    </trim>
  </select>

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml

@@ -86,7 +86,7 @@
        order by id DESC
        <trim prefix="limit " >
            <if test="start != null and count != null">
                #{start}, #{count}
                #{start,jdbcType=INTEGER}, #{count,jdbcType=INTEGER}
            </if>
        </trim>
    </select>