Oracle 和 MySQL 数据库的批量 Actualización 在 MyBatis.
Oracle ： ：
<código style = ""> << span style = "" update </span> id = <span style = ""> "batchupdate" </span> parametertype = <span span style = ">" java.util.list "</span>> << span style =" "> foreach <///span> collection = <" span span span '</span span style = " estilo = ""> "índice" </span> <span style = ""> open </span> = <span style = ""> "begin" </span> <span span style = "> cerrar </span> = <span spy style ="> "end;" </span> separator = <span span style = ">"; "<///<pan span span style =" uply </ap span </span span style = " test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span>> donde id = $ {item.id} </<span style = ""> foreach </span> </<span style = ""> update </span>> </code> </code> </code>mysql ： ：
mysql 数据库采用一下写法即可执行 ， 但是数据库连接必须配置 ： & tetermultiqueries = true
例如 ： JDBC: mysql: //192.168.1.236: 3306/test? UseUnicode = true & caracterSencoding = UTF-8 & tet.
<código style = ""> << span style = "" update </span> id = <span style = ""> "batchupdate" </span> parametertype = <span span style = ">" java.util.list "</span>> << span style =" "> foreach <///span> collection = <" span span span '</span span style = " style = ""> "index" </span> <span style = ""> open </span> = <span style = ""> "" </span> <span style = "> cerrar </span> = <span style ="> "" "</span> separator = <span style ="> ";" </span >> <style = "" update </pan> test << span style = "> set </span </span test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span>> donde id = $ {item.id} </<span style = ""> foreach </span> </<span style = ""> update </span>> </code> </code> </code>以上所述是小编给大家介绍的 MyBatis 执行批量更新 Actualización de lotes 的方法（ Oracle, MySQL 两种） ， 希望对大家有所帮助 ， 如果大家有任何疑问请给我留言 小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！ 小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！