1.新增多行数据

@Insert({"

"" +

" into s_user (user,username) values " +

"(#{item.user},#{item.username}) " +

"" +

" select 1 from dual " +

""})

2.执行多条SQL语句

特别注意：open属性设置为begin，close设置为;end;

@Update({"

"" +

"update s_user set user=#{item.user},username=#{item.username} where id=#{item.id}" +

"" +

""})

ORACLE中通过begin...end；来执行多行sql语句，各条sql之间用;分割

补充知识：使用mybatis注解批量插入Oracle数据库与批量插入MySQL数据库区别

批量插入MySQL语法

insert into table_name values (column01, column02, ...)， (value01, value02, ...),

(value01, value02, ...);

例子：

@Select({"

"insert into t_sales_target (area_id, area_name, shop_id, shop_name, year) values " ,

" ",

" (",

" #{item.areaId},",

" #{item.areaName},",

" #{item.shopId},",

" #{item.shopName},",

" #{item.year},"

" )",

" ",

""

} )

批量插入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({"

"insert into t_sales_date_amount (amount, sale_date, shop_id, area_id) select A.* from (",

" ",

" SELECT",

" #{item.salesAmount},",

" #{item.salesDateTime},",

" #{item.shopId},",

" #{item.areaId}",

" from dual",

" ",

" )A",

""

})

以上这篇Mybatis注解方式操作Oracle数据库详解就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持。

相关文章