day02 mybatis

九品印相

于 2024-08-07 20:06:55 发布

阅读量46

点赞数 1

分类专栏： tmooc 文章标签： mybatis

本文链接：https://blog.csdn.net/m0_68935893/article/details/141000121

版权

tmooc 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

mybatis

`insert`

`mapper`

`collection`

循环 `<foreach>`标签

`<sql>`重复抽取标签

`<include>`标签复用

<!-- 1.重复SQL抽取-sql标签 -->
<sql id="deleteSql">
    DELETE FROM comment WHERE id in
</sql>


<delete id="deleteByIds1">
    <!--2.通过include标签复用-include标签-->
    <include refid="deleteSql"></include>(
    <foreach collection="array" item="id" separator=",">
        #{id}
    </foreach>
    )
</delete>

<delete id="deleteByIds2">
    <!--2.通过include标签复用-include标签-->
    <include refid="deleteSql"></include>(
    <foreach collection="list" item="id" separator=",">
        #{id}
    </foreach>
    )
</delete>