MyBatis XML使用

Mgg9702

已于 2023-05-19 14:26:41 修改

阅读量375

点赞数

文章标签： mybatis xml java

于 2022-11-14 14:50:59 首次发布

本文链接：https://blog.csdn.net/Mgg9702/article/details/127847312

版权

一、集合遍历

1、字符串逗号分隔

<if test="ids != null and ids != ''">
         AND ids in
    <foreach collection="ids.split(',')" item="item" index="index" open="(" separator="," close=")">
         #{item}
    </foreach>
</if>

2、List

<if test="ids != null and ids.size() > 0">
        AND ids in
    <foreach collection="ids" item="item" index="index" open="(" separator="," close=")">
        #{item}
    </foreach>
</if>

3、数组

<if test="ids != null and ids.length > 0">
        AND ids in
    <foreach collection="array" item="item" index="index" open="(" separator="," close=")">
        #{item}
   </foreach>
        </if>

4、其他集合

<if test="ids != null and ids.size() > 0">
        AND ids in
    <foreach collection="array" item="item" index="index" open="(" separator="," close=")">
        #{item}
   </foreach>
        </if>

二、批量插入

    <insert id="batchInsertData" useGeneratedKeys="true" keyColumn="id" keyProperty="id">
        INSERT INTO t_batch_data (
            column1,
            column2,
            column3,
            column4
        ) VALUES
        <foreach item="data" collection="list" separator=",">
            (
                #{data.column1},
                #{data.column2},
                #{data.column3},
                #{data.column4}
            )
        </foreach>
    </insert>