ibatis批量插入、修改、删除

<parameterMap class="com.entity.File" id="fileMap"> <parameter property="fileId" /> <parameter property="title" /> <parameter property="brief" /> <parameter property="content" /> <parameter property="url" /> </parameterMap>

批量插入

<span style="white-space:pre"> </span><insert id="insertList" parameterClass="java.util.List"> <span style="white-space:pre"> </span>insert into files (fileID,title,brief,content,url) values <span style="white-space:pre"> </span><iterate conjunction=","> <span style="white-space:pre"> </span>(#files[].fileId#,#files[].title#,#files[].brief#,#files[].content#,#files[].url#) <span style="white-space:pre"> </span></iterate> <span style="white-space:pre"> </span></insert> 批量删除

<!-- 批量删除一 --> <delete id="delList" parameterClass="java.util.List"> delete from files <iterate prepend="where" conjunction="OR"> fileId = #fileIds[]# </iterate> </delete> <!-- 批量删除二 --> <delete id="delList" parameterClass="java.util.List"> delete from files where fileId in <iterate open="(" close=")" conjunction=","> #fileIds[]# </iterate> </delete> 批量修改

<update id="updateFiles" parameterClass="java.util.HashMap"> update files set title = #files.title# where fileId in <iterate property="fileIds" open="(" close=")" conjunction=","> #fileIds[]# </iterate> </update>

注意：如果使用的List只是Map的属性，请用property