mybatis xml

最新推荐文章于 2024-11-12 21:14:07 发布

weixin_34270865

最新推荐文章于 2024-11-12 21:14:07 发布

阅读量93

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/wuyuwuyueping/p/9494170.html

版权

mybatis xml

DAO

int deUndwrtList(@Param("certiNos")List<String> certiNos);

<update id="deUndwrtList" parameterType="java.util.List">
Update PrpTmain main Set main.UnderWriteFlag = '0' Where not exists (select certino from prpcardsub where certino=main.proposalNo)
and not exists (select certino from PrpJPayInfo where certino=main.proposalNo)
and not exists (select certino from PrpJFeeTransfers where certino=main.proposalNo)
and main.proposalNo in
<foreach item="certiNo" collection="certiNos" open="(" separator="," close=")">
#{certiNo}
</foreach>
</update>

--增删改返回值 int --->修改的记录个数

转载于:https://www.cnblogs.com/wuyuwuyueping/p/9494170.html