ibatis自带批量删除

来源:互联网 发布:淘宝网的流程图解 编辑:程序博客网 时间:2024/05/11 00:11

ibatis普通删除:

<delete id = "delete" parameterType = "test">      <![CDATA[         delete from tests where id = #id#      ]]>  </delete>

ibatis自带的批量删除:

<delete id = "delete" parameterType = "java.util.List">      <![CDATA[         delete from tests where id in      ]]>      <foreach collection="list" item = "list" open="(" separator="," close=")">#list.id#       </foreach>  </delete> 

collection里表示类型,这里是list,还可以是array。list不用管,相当于一个变量。











0 0
原创粉丝点击