【无标题】 ゝ一纸荒年。 2023-10-14 21:36 1阅读 0赞 mybatis执行批量更新batch update 的方法 Oracle /Mysql 一、mybatis执行批量更新batch update 的方法（mysql数据库） 1、数据库连接必须配置：&allowMultiQueries=true（切记一定要加上这个属性，否则会有问题！） jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true 2、批量修改并加判断条件 update HSP\_DOCADVICE\_INF VST\_CAD = \#\{hspDocadviceInf.vstCad,jdbcType=VARCHAR\}, DOCADVICE\_ISDAT = \#\{hspDocadviceInf.docadviceIsdat,jdbcType=TIMESTAMP\}, DOCADVICE\_BEDAT = \#\{hspDocadviceInf.docadviceBedat,jdbcType=TIMESTAMP\}, DOCADVICE\_NAM = \#\{hspDocadviceInf.docadviceNam,jdbcType=VARCHAR\}, DOCADVICE\_NUIMDAT = \#\{hspDocadviceInf.docadviceNuimdat,jdbcType=TIMESTAMP\}, DOCADVICE\_NUIMNAM = \#\{hspDocadviceInf.docadviceNuimnam,jdbcType=VARCHAR\}, DOCADVICE\_DOCSTDAT = \#\{hspDocadviceInf.docadviceDocstdat,jdbcType=TIMESTAMP\}, DOCADVICE\_DOCSTNAM = \#\{hspDocadviceInf.docadviceDocstnam,jdbcType=VARCHAR\}, DOCADVICE\_NUSTDAT = \#\{hspDocadviceInf.docadviceNustdat,jdbcType=TIMESTAMP\}, DOCADVICE\_NUSTNAM = \#\{hspDocadviceInf.docadviceNustnam,jdbcType=VARCHAR\}, CREATE\_DAT = \#\{hspDocadviceInf.createDat,jdbcType=TIMESTAMP\}, CREATE\_NUM = \#\{hspDocadviceInf.createNum,jdbcType=VARCHAR\}, CREATE\_NAM = \#\{hspDocadviceInf.createNam,jdbcType=VARCHAR\}, UPDATE\_DAT = \#\{hspDocadviceInf.updateDat,jdbcType=TIMESTAMP\}, UPDATE\_NUM = \#\{hspDocadviceInf.updateNum,jdbcType=VARCHAR\}, UPDATE\_NAM = \#\{hspDocadviceInf.updateNam,jdbcType=VARCHAR\}, DOCADVICE\_WAY = \#\{hspDocadviceInf.docadviceWay,jdbcType=VARCHAR\}, DOCADVICE\_TYPE = \#\{hspDocadviceInf.docadviceType,jdbcType=VARCHAR\}, DOCADVICE\_FLAG = \#\{hspDocadviceInf.docadviceFlag,jdbcType=CHAR\}, DOCADVICE\_YYJL = \#\{hspDocadviceInf.docadviceYyjl,jdbcType=VARCHAR\}, DOCADVICE\_BZ = \#\{hspDocadviceInf.docadviceBz,jdbcType=VARCHAR\}, DOCADVICE\_MAINFLG = \#\{hspDocadviceInf.docadviceMainflg,jdbcType=VARCHAR\}, PX = \#\{hspDocadviceInf.px,jdbcType=VARCHAR\}, GYFSMC = \#\{hspDocadviceInf.gyfsmc,jdbcType=VARCHAR\}, SL = \#\{hspDocadviceInf.sl,jdbcType=VARCHAR\}, DOCADVICE\_STATUS = \#\{hspDocadviceInf.docadviceStatus,jdbcType=VARCHAR\}, DOCADVICE\_CHECKNAM = \#\{hspDocadviceInf.docadviceChecknam,jdbcType=VARCHAR\}, DOCADVICE\_NUIMNAM2 = \#\{hspDocadviceInf.docadviceNuimnam2,jdbcType=VARCHAR\}, DOCADVICE\_CONTENT = \#\{hspDocadviceInf.docadviceContent,jdbcType=CLOB\}, DOCADVICE\_SEQ = \#\{hspDocadviceInf.docadviceSeq,jdbcType=VARCHAR\} 3、java 接口 public int updateNewYzxx(@Param(value = “list”) List list); 二、mybatis执行批量更新batch update 的方法（oracle数据库） update HSP\_DOCADVICE\_INF VST\_CAD = \#\{hspDocadviceInf.vstCad,jdbcType=VARCHAR\}, DOCADVICE\_ISDAT = \#\{hspDocadviceInf.docadviceIsdat,jdbcType=TIMESTAMP\}, DOCADVICE\_BEDAT = \#\{hspDocadviceInf.docadviceBedat,jdbcType=TIMESTAMP\}, DOCADVICE\_NAM = \#\{hspDocadviceInf.docadviceNam,jdbcType=VARCHAR\}, DOCADVICE\_NUIMDAT = \#\{hspDocadviceInf.docadviceNuimdat,jdbcType=TIMESTAMP\}, DOCADVICE\_NUIMNAM = \#\{hspDocadviceInf.docadviceNuimnam,jdbcType=VARCHAR\}, DOCADVICE\_DOCSTDAT = \#\{hspDocadviceInf.docadviceDocstdat,jdbcType=TIMESTAMP\}, DOCADVICE\_DOCSTNAM = \#\{hspDocadviceInf.docadviceDocstnam,jdbcType=VARCHAR\}, DOCADVICE\_NUSTDAT = \#\{hspDocadviceInf.docadviceNustdat,jdbcType=TIMESTAMP\}, DOCADVICE\_NUSTNAM = \#\{hspDocadviceInf.docadviceNustnam,jdbcType=VARCHAR\}, CREATE\_DAT = \#\{hspDocadviceInf.createDat,jdbcType=TIMESTAMP\}, CREATE\_NUM = \#\{hspDocadviceInf.createNum,jdbcType=VARCHAR\}, CREATE\_NAM = \#\{hspDocadviceInf.createNam,jdbcType=VARCHAR\}, UPDATE\_DAT = \#\{hspDocadviceInf.updateDat,jdbcType=TIMESTAMP\}, UPDATE\_NUM = \#\{hspDocadviceInf.updateNum,jdbcType=VARCHAR\}, UPDATE\_NAM = \#\{hspDocadviceInf.updateNam,jdbcType=VARCHAR\}, DOCADVICE\_WAY = \#\{hspDocadviceInf.docadviceWay,jdbcType=VARCHAR\}, DOCADVICE\_TYPE = \#\{hspDocadviceInf.docadviceType,jdbcType=VARCHAR\}, DOCADVICE\_FLAG = \#\{hspDocadviceInf.docadviceFlag,jdbcType=CHAR\}, DOCADVICE\_YYJL = \#\{hspDocadviceInf.docadviceYyjl,jdbcType=VARCHAR\}, DOCADVICE\_BZ = \#\{hspDocadviceInf.docadviceBz,jdbcType=VARCHAR\}, DOCADVICE\_MAINFLG = \#\{hspDocadviceInf.docadviceMainflg,jdbcType=VARCHAR\}, PX = \#\{hspDocadviceInf.px,jdbcType=VARCHAR\}, GYFSMC = \#\{hspDocadviceInf.gyfsmc,jdbcType=VARCHAR\}, SL = \#\{hspDocadviceInf.sl,jdbcType=VARCHAR\}, DOCADVICE\_STATUS = \#\{hspDocadviceInf.docadviceStatus,jdbcType=VARCHAR\}, DOCADVICE\_CHECKNAM = \#\{hspDocadviceInf.docadviceChecknam,jdbcType=VARCHAR\}, DOCADVICE\_NUIMNAM2 = \#\{hspDocadviceInf.docadviceNuimnam2,jdbcType=VARCHAR\}, DOCADVICE\_CONTENT = \#\{hspDocadviceInf.docadviceContent,jdbcType=CLOB\}, DOCADVICE\_SEQ = \#\{hspDocadviceInf.docadviceSeq,jdbcType=VARCHAR\} 2、java接口 public int updateNewYzxx(@Param(value = “list”) List list); 总结：mysql批量更改数据源配置文件中必须配置：&allowMultiQueries=true Oracle批量修改数据时foreach中要配置 open=“begin” close=“;end;” separator=“;”
相关 【无标题】 C 语言接口如何定义和继承？ 在 C 语言中，接口通常通过定义结构体来实现，结构体中包含一些函数指针，这些函数指针定义了接口所需的所有函数。 下面是一个示例代码： 谁践踏了优雅/ 2024年03月26日 11:40/ 0 赞/ 106 阅读
相关 【无标题】 -------------------- springboot web项目框架结构 -------------------- SpringBoot 是一个基于 Spr 女爷i/ 2024年03月25日 20:00/ 0 赞/ 67 阅读
相关 【无标题】 大家可以回想一下，当初我们最开始学习Java的时候，搭建一个Web所需要的步骤。。。 1、配置web.xml，加载spring和spring mvc 2、配置数据库连接、配 深藏阁楼爱情的钟/ 2024年03月23日 18:43/ 0 赞/ 58 阅读
相关 【无标题】 铜三铁四已经结束了，但还是有很多Java程序员没有找到工作或者成功跳槽，跳槽成功的也只是从一个坑中，跳入另一个坑中…… 
谁践踏了优雅
深藏阁楼爱情的钟
还没有评论，来说两句吧...