oracle 批量更新xml
·
Mapper层 参数改改即可
service和controller 直接传个list 可用,
@Insert({"<script>" ,
"INSERT ALL ",
"<foreach collection='list' item='element' index='index' separator=''>" ,
"INTO T_CW_XSJF_CWZFT(id,projectId,projectName,userId,userName,amount,payAmount,overTime) ",
"VALUES(",
"#{element.id},",
"#{element.projectId},",
"#{element.projectName},",
"#{element.userId},",
"#{element.userName},",
"#{element.amount},",
"#{element.payAmount},",
"#{element.overTime,jdbcType=DATE})",
"</foreach>",
"SELECT * FROM dual",
"</script>"})
boolean saveBatchList(@Param("list") List<DhuYxDataStudentPay> list);
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐


所有评论(0)