Oracle 和 mysql 数据库的批量 perbarui 在 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=<span style="">"item"</span> index=<span style="">"index"</span> <span style="">open</span>=<span style="">"begin"</span> <span style="">close</span>=<span style="">"end;"</span> separator=<span style="">";"</span>> <span style="">update</span> test <<span style="">set</span>> test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span>> di mana id = $ {item.id} </<span style = ""> foreach </span> </<span style = ""> update </span> </code> </span>mysql 数据库 :
mysql 数据库采用一下写法即可执行 , 但是数据库连接必须配置 : & allowmultiqueries = true
例如 : JDBC: mysql: //192.168.1.236: 3306/tes? UseUnicode = true & characterencoding = UTF-8 & AllowMultiqueries = true
<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=<span style="">"item"</span> index=<span style = ""> "index" </span> <span style = ""> open </span> = <span style = ""> "" </span> <span style = ""> tutup </span> = <span style = ""> "" </span> separator = <span style = ""; ";" </span >> <span style = "> span </span>" ";"; test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span>> di mana id = $ {item.id} </<span style = ""> foreach </span> </<span style = ""> update </span> </code> </span>以上所述是小编给大家介绍的 mybatis 执行批量更新 pembaruan batch 的方法( oracle, mysql 两种) , 希望对大家有所帮助 , 如果大家有任何疑问请给我留言 , ,