1.新增多行数据
@Insert({"<script>insert all " +
"<foreach collection=\"list\" index=\"index\" item=\"item\" open=\"\" separator=\"\" close=\"\">" +
" into s_user (user,username) values " +
"(#{item.user},#{item.username}) " +
"</foreach>" +
" select 1 from dual " +
"</script>"})
2.执行多条SQL语句
特别注意：open属性设置为begin，close设置为;end;
@Update({"<script>" +
"<foreach collection=\"list\" separator=\";\" item=\"item\" open=\"begin\" close=\";end;\">" +
"update s_user set user=#{item.user},username=#{item.username} where id=#{item.id}" +
"</foreach>" +
"</script>"})
ORACLE中通过begin...end；来执行多行sql语句，各条sql之间用;分割
补充知识：使用mybatis注解批量插入Oracle数据库与批量插入MySQL数据库区别
批量插入MySQL语法
insert into table_name values (column01, column02, ...)， (value01, value02, ...),
(value01, value02, ...);
例子：
@Select({"<script>" ,
"insert into t_sales_target (area_id, area_name, shop_id, shop_name, year) values " ,
" <foreach collection='saleTargetList' item='item' index='index' separator=','>",
" (",
" #{item.areaId},",
" #{item.areaName},",
" #{item.shopId},",
" #{item.shopName},",
" #{item.year},"
" )",
" </foreach>",
"</script>"
} )
批量插入Oracle语法
insert into table_name (column01, column02, ...) select * from ( select value01, value02, ... from dual union select value01, value02, ... from dual union select value01, value02, ... from dual )
例子：
@Insert({"<script>",
"insert into t_sales_date_amount (amount, sale_date, shop_id, area_id) select A.* from (",
" <foreach collection='salesDateAmountList' item='item' index='index' separator='UNION ALL'>",
" SELECT",
" #{item.salesAmount},",
" #{item.salesDateTime},",
" #{item.shopId},",
" #{item.areaId}",
" from dual",
" </foreach>",
" )A",
"</script>"
})
以上这篇Mybatis注解方式操作Oracle数据库详解就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持。
