<delete id="deletes">
delete from class where id in
<foreach item="id" collection="array" open="(" separator=","
close=")">
#{id}
</foreach>
;
delete from students where classid in
<foreach item="classid" collection="array" open="(" separator="," close=")">
#{classid}
</foreach>
</delete>
当删除班级的时候,把班级所在的学生也删除
当点击(批量)删除后,需要删除好几张表
最新推荐文章于 2018-05-10 22:58:40 发布