Oracle 和 mysql 数据库的批量อัปเดต在 mybatis 中配置不太一样：
Oracle 数据库：
<code style = ""> << span style = ""> อัปเดต </span> id = <span style = ""> "batchupdate" </span> parameterType = <span style = ""> "java.util.list" </span >> index = <span style = ""> "index" </span> <span style = ""> เปิด </span> = <span style = ""> "เริ่มต้น" </span> <span style = "" ปิด </span> = <span style = ""> "end; test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span >> โดยที่ id = $ {item.id} </<span style = ""> foreach </span >> </<span style = "mysql 数据库：
mysql 数据库采用一下写法即可执行， 但是数据库连接必须配置： & lewlowmultiqueries = true
例如： JDBC: mysql: //192.168.1.236: 3306/ทดสอบ? useunicode = true & characterencoding = utf-8 & levermultiqueries = true
<code style = ""> << span style = ""> อัปเดต </span> id = <span style = ""> "batchupdate" </span> parameterType = <span style = ""> "java.util.list" </span >> index = <span style = ""> "index" </span> <span style = ""> เปิด </span> = <span style = ""> "" </span> <span style = "" ปิด </span> = <span style = ""> "</span> sparator = <span style =" ";" </span> test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span >> โดยที่ id = $ {item.id} </<span style = ""> foreach </span >> </<span style = "以上所述是小编给大家介绍的 mybatis 执行批量更新การอัปเดตแบทช์ 的方法（ oracle, mysql 两种）， 希望对大家有所帮助，， 如果大家有任何疑问请给我留言， 小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！