PS:本人是一枚初学小菜鸟,代码如有不对的地方希望各路大神指点
1.批量增加:
<insert id="addSelfTaskList" parameterType="java.util.List">
insert into selftaskpatroluser(taskid,taskassetid)
VALUES
<foreach collection="list" item="item" index="index" separator=",">
(#{item.taskid},#{item.taskassetid})
</foreach>
</insert>
2.批量更新
<update id="updateReviewFinish" parameterType="java.util.List">
<foreach collection="list" item="item" separator=";">
update selftaskasset
<set>
reviewenddate=#{item.reviewenddate},reviewstatus=#{item.reviewstatus}
</set>
where
taskid = #{item.taskid}
and
assetid=#{item.assetid}
</foreach>
</update>
3.批量查找(例如使用一组id 为1,2,4的字符串批量查找数据)
<select id="getCheckListByArray" resultType="com.net.hdinfo.bean.Hiddendangerinformation">
SELECT * FROM hiddendangerinformation WHERE id IN
<foreach collection="array" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</select>
4.批量删除
<delete id="batchdel" parameterType="com.net.review.bean.ReviewRelation" >
DELETE FROM review_relation
WHERE
<foreach collection="list" item="list" index= "index" separator="or">
(groupid = #{list.groupid}
AND
eid=#{list.eid}
)
</foreach>
</delete>