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之间用;分割