文章描述了在Java中使用数据库操作方法，通过`delTask`和`delTaskEncoder`函数，执行对`t_cess_oasis_upgrade_task_manager`和`t_cess_oasis_upgrade_task_encoder`表中任务ID的批量删除操作，使用了foreach循环和动态SQL构建删除条件。
String a = "1170370258303238150";
String b = "117037028932410539";
delTaskIdList.add(a);
delTaskIdList.add(b);
patrolTaskDao.delTask(delTaskIdList);
patrolTaskDao.delTaskEncoder(delTaskIdList);
数据库代码：
void delTask(List<String> upGradeTaskId);
void delTaskEncoder(List<String> upGradeTaskId);
实现：
<delete id="delTask" parameterType="java.util.List">
DELETE FROM t_cess_oasis_upgrade_task_manager
WHERE task_id in
<foreach collection="list" item="item" separator="," open="(" close=")">
#{item}
</foreach>
</delete><delete id="delTaskEncoder" parameterType="java.util.Map">
DELETE FROM t_cess_oasis_upgrade_task_encoder
WHERE task_id in
<foreach collection="list" item="item" separator="," open="(" close=")">
#{item}
</foreach>
</delete>
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
