使用Mybatis一次执行多条sql语句

1.修改数据库连接地址

jdbc:mysql://localhost:3306/classroom?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowMultiQueries=true

注意要加上&allowMultiQueries=true

2编写Mapper

<update id="UpdateForAdmin" parameterType="Integer">
    UPDATE menu SET status =1 WHERE id =1;
    UPDATE menu SET status =1 WHERE id =2;
    UPDATE menu SET status =1 WHERE id =3;
    UPDATE menu SET status =0 WHERE id =4;
    UPDATE menu SET status =0 WHERE id =5;
    UPDATE menu SET status =0 WHERE id =6;
    UPDATE menu SET status =0 WHERE id =7;
    UPDATE menu SET status =0 WHERE id =8;
    UPDATE menu SET status =0 WHERE id =9;
    UPDATE menu SET status =0 WHERE id =10;
    UPDATE menu SET status =0 WHERE id =11;
    UPDATE menu SET status =0 WHERE id =12;
    UPDATE menu SET status =0 WHERE id =13;
</update>

直接编写即可，但是要注意每一句要加上分号