mybatis批量查询

2024-09-08 16:02:47

<foreach collection="list" item="item" open="(" separator="," close=")">

			#{item}

		</foreach>

　　批量删除

<delete id="delByIds" parameterType="java.lang.String">

        DELETE FROM trust_ip_segment

        WHERE

            id in

            <foreach collection="array" item="item" index="index" separator="," open="(" close=")">

                #{item}

            </foreach>

    </delete>

最新文章

热门文章