在JDBC 增加参数allowMultiQueries
jdbc:mysql://localhost:3306/abc?++++++++++++++&allowMultiQueries=true
<insert id="addRi" parameterType="java.util.List">DELETE FROM sys_ri WHERE sr_id = #{roId} AND sr_fion_id = #{fod};INSERT into sys_rVALUES<foreach collection ="rlisssst" item="item" index="index" separator=",">(#{item.id},#{item.rd})
</foreach>
</insert>
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT into sys_ri VALUES (0,17,11, 'In' at line 4