个人技术分享

  在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_r
    	
VALUES
    	
<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