Oracle 和 mysql 数据库的批量 업데이트 在 mybatis 中配置不太一样 :
오라클 : :
<code style = ""> << span style = ""> update </span </span </span </span </span </span </span </span </span </span </span> parameterType = <span style = "" ""> "java.util.list"</span >> << span spant = "> foreach </span> <span style =" ">"</span> "span> span> span span span span span span Style =" "" index = <span style = ""> "index"</span "</span> <span style =" "> Open </span> = <span style =" ">"시작 "</span> <span style =" "> close </span> = <span style =" ">"end; "</span> span style ="< ""> span test </span test </span test </span test </span test </span test </span </span </span </span </span </span span span span style = ". test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span >> 여기서 id = $ {item.id} </<span style = ""> foreach >> </<span style = ""> update </span >> </code>mysql 数据库 :
mysql 数据库采用一下写法即可执行 数据库采用一下写法即可执行, 但是数据库连接必须配置 : & alluctiqueries = true
: JDBC : mysql : //192.168.1.236 : 3306/test? useUnicode = true & charac
<code style = ""> << span style = ""> update </span </span </span </span </span </span </span </span </span </span </span> parameterType = <span style = "" ""> "java.util.list"</span >> << span spant = "> foreach </span> <span style =" ">"</span> "span> span> span span span span span span Style =" "" index = <span style = ""> "index"</span "</span> <span style =" "> Open </span> = <span style =" "" "" ""</span> <span style = ""> close </span> = <span style = "" "" "</span> 분리기 = <span style =" "</span >> <span style =" "> span span style ="> span style = "" "" "> span span span span span < test = $ {item.test}+<span style = ""> 1 </span> </<span style = ""> set </span >> 여기서 id = $ {item.id} </<span style = ""> foreach >> </<span style = ""> update </span >> </code>以上所述是小编给大家介绍的 MyBatis b 배치 업데이트 的方法 (Oracle)