Mybatis注解方式操作Oracle数据库

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.更新多行数据

@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>"})

3.执行多条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>"})