mybatis xml

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 --->修改的记录个数