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>
直接编写即可,但是要注意每一句要加上分号