mybatis分页实现

最新推荐文章于 2021-03-08 19:59:15 发布

原创最新推荐文章于 2021-03-08 19:59:15 发布 · 199 阅读

0 ·

CC 4.0 BY-SA版权

j2ee 专栏收录该内容

36 篇文章

订阅专栏

    <select id="selectCamerasByPage"  resultMap="BaseResultMap">
        <!--
          WARNING - @mbggenerated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        select  c.*
        FROM dev_device_camera AS c
        LEFT JOIN dev_device AS d ON c.device_id=d.id
        LEFT JOIN iod_equipment e ON c.`device_id`=e.`id`
        <where>
            <if test="groupId != null">
                AND c.group_id=#{groupId,jdbcType=CHAR}
            </if>
            <if test="nodeId != null">
                AND c.node_id=#{nodeId,jdbcType=CHAR}
            </if>
            <if test="searchList != null">
                AND
                <foreach close=")" open="(" collection="searchList" index="index" item="search" separator=" or ">
                    c.name LIKE "%"#{search}"%" OR c.gb_id LIKE "%"#{search}"%"
                    OR c.pin_yin LIKE "%"#{search}"%" OR c.pin_yin_ad LIKE "%"#{search}"%"
                    OR e.ip LIKE "%"#{search}"%" or e.gb_id  LIKE "%"#{search}"%"
                </foreach>
            </if>
        </where>
        <if test="offset != null and pageSize !=null">
            ORDER BY c.modify_time DESC
            limit #{offset,jdbcType=INTEGER},#{pageSize,jdbcType=INTEGER}
        </if>
    </select>

<select id="getCamerasCount"  resultType="java.lang.Integer">
        <!--
          WARNING - @mbggenerated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        SELECT count(1)
        FROM dev_device_camera AS c
        LEFT JOIN dev_device AS d ON c.device_id=d.id
        LEFT JOIN iod_equipment e ON c.`device_id`=e.`id`
        <where>
            <if test="groupId != null">
                AND c.group_id=#{groupId,jdbcType=CHAR}
            </if>
            <if test="nodeId != null">
                AND c.node_id=#{nodeId,jdbcType=CHAR}
            </if>
            <if test="searchList != null">
                AND
                <foreach close=")" open="(" collection="searchList" index="index" item="search" separator=" or ">
                    c.name LIKE "%"#{search}"%" OR c.gb_id LIKE "%"#{search}"%"
                    OR c.pin_yin LIKE "%"#{search}"%" OR c.pin_yin_ad LIKE "%"#{search}"%"
                    OR e.ip LIKE "%"#{search}"%" or e.gb_id  LIKE "%"#{search}"%"
                </foreach>
            </if>
        </where>
    </select>

对应mapper 增加如下接口

    List<Camera> selectCamerasByPage(@Param("offset") Integer var1, @Param("pageSize") Integer var2, @Param("groupId") String var3, @Param("searchList") List<String> var4, @Param("nodeId") String var5);

    int getCamerasCount(@Param("groupId") String var1, @Param("searchList") List<String> var2, @Param("nodeId") String var3);