xml里面批量遍历和单个遍历

哦219

已于 2023-12-13 11:30:22 修改

阅读量513

点赞数 6

文章标签： xml java

于 2023-12-13 11:14:47 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_55733979/article/details/134967319

版权

//批量
<insert id="inserBeatch">
    insert into table_name(table_name,tabel_code)
        values
        <foreach collection="param" index="i" item="item" separator=",">
            (#{item.tableName},
            #{item.tabelCode})
        </foreach>
</insert>

mapper层中的传参
List<xxxx> findInfo(@Param("param")List<String> applyId);
//单个
<select id="findInfo" resultType="xxxxx">
    select * 
        from table_name where table_id in
            <foreach collection="param" separator="," open="(" close=")" item="item" index="i">
                #{item}
            </foreach>
</select>