Oracle 和 MySQL 数据库的批量 Mise à jour 在 Mybatis 中配置不太一样 ：
Oracle 数据库 ：
<code style = ""> << span style = ""> Update </span> id = <span style = ""> "Batchupdate" </span> ParameterType = <span style = ""> "java.util.list" </span> << Span style = ""> foreach </span> collection = <span style = ""> "list" </span> item = item = <pany style = "" Item "</ index = </panne> item = élément = <pany style =" " style = ""> "index" </span> <span style = ""> ouvrir </span> = <span style = ""> "begin" </span> <span style = ""> close </span> = <span style = ""> "end;" </span> séparateur = <span style = ""> ";" </pan >> <spany = ""> Update </pan> Test << Span style = "" set </ span> "> update </pan> test <<" Span style = "Set <Set <Set <" test = $ {item.test} + <span style = ""> 1 </span> </ <span style = ""> set </span>> où id = $ {item.id} </ <span style = ""> foreach </span> </ <span style = ""> update </span> </code>mysql 数据库 ：
mysql 数据库采用一下写法即可执行 ， 但是数据库连接必须配置 ： & allowMultiqueries = true
例如 ： jdbc: mysql: //192.168.1.236: 3306 / test? Useunicode = true & caractory
<code style = ""> << span style = ""> Update </span> id = <span style = ""> "Batchupdate" </span> ParameterType = <span style = ""> "java.util.list" </span> << Span style = ""> foreach </span> collection = <span style = ""> "list" </span> item = item = <pany style = "" Item "</ index = </panne> item = élément = <pany style =" " style = ""> "index" </span> <span style = ""> ouvrir </span> = <span style = ""> "" "</span> <span style =" "> close </span> = <span style =" ">" "</span> séparator = <span style =" ">"; "" </span >> <span style = ""> Update </pan> test << span style = ""> set </ span >> test = $ {item.test} + <span style = ""> 1 </span> </ <span style = ""> set </span>> où id = $ {item.id} </ <span style = ""> foreach </span> </ <span style = ""> update </span> </code>以上所述是小编给大家介绍的 MyBatis 执行批量更新 Mise à jour par lots 的方法 （Oracle, mysql 两种） ， 希望对大家有所帮助 ， 如果大家有任何疑问请给我留言 ， 小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！