设置允许mybatis一次执行多条sql

jdbc连接增加allowMultiQueries=true即可

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

sql之间使用;分隔

demo

<update id="down">
    UPDATE table SET 
        order_num = order_num - 1
    WHERE order_num = #{orderNum} + 1;
    UPDATE table SET 
        order_num = order_num + 1
    WHERE id = #{id};
</update>