gpt4 book ai didi

Java之MyBatis 批量删除数据,两种方式(注解,XML)

转载 作者:知者 更新时间:2024-03-13 07:06:53 25 4
gpt4 key购买 nike

1、MyBatis之 XML 批量删除数据

public int deleteSysStudentStuIds(Long[] stuIds);
<delete id="deleteSysStudentStuIds" parameterType="String">
        delete from sys_student where stu_id in
        <foreach item="stuId" collection="array" open="(" separator="," close=")">
            #{stuId}
        </foreach>
</delete>

2、MyBatis之 注解 批量删除数据

@Delete("<script>
        delete from sys_student where stu_id in 
        <foreach collection='array' item='stuId' open='(' separator=',' close=')'>#{stuId}</foreach>
                  </script>")
        
void delete(Long[] stuIds);

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com