mybatis 允许一次性执行多条sql语句

添加allowMultiQueries=true

jdbcUrl=jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true

多条sql之间用;隔开
例子:

 <delete id="cleanData">
        DELETE FROM `user` WHERE uid=#{uid};
        DELETE FROM user_game_data WHERE uid=#{uid};
        DELETE FROM  user_game_record WHERE uid=#{uid};
    </delete>

版权声明:本文为ysk_xh_521原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。