批量更新 multi-statement not allow

MyBatis批量更新时所需配置。

第一步：JDBC (allowMultiQueries=true)

url: jdbc:mysql://localhost:3306/test?...&allowMultiQueries=true

第二步：DuridConfig

@Configuration
@ConfigurationProperties(prefix = "spring.datasource")
public class DruidConfig {
    @Bean
    public WallFilter wallFilter() {
        WallFilter wallFilter = new WallFilter();
        wallFilter.setConfig(wallConfig());
        return wallFilter;
    }

    @Bean
    public WallConfig wallConfig() {
        WallConfig config = new WallConfig();
        //允许一次执行多条语句
        config.setMultiStatementAllow(true);
        //允许非基本语句的其他语句
        config.setNoneBaseStatementAllow(true);
        return config;
    }
}

测试：

<update id="batchUpdateStudents" parameterType="java.util.List">
	<foreach collection="list" index="index" item="item" separator=";">
		update cell set
		<if test="item.sdudentId != null">`sdudent_id` = #{item.sdudentId},</if>
		<if test="item.sdudentName != null">`sdudent_name` = #{item.sdudentName},</if>
			...
		<if test="item.updatedBy != null">`updated_by` = #{item.updatedBy},</if>
		<if test="item.updatedDate != null">`updated_date` = #{item.updatedDate}</if>
		where id = #{item.id, jdbcType=INTEGER}
	</foreach>
</update>