MyBaties 批量插入数据异常说明

参考网址

separator直接敲一个回车符号

<insert id="insertStationParams" parameterType="java.util.List">
    <foreach collection="list" index="index" item="item" separator="
    ">
        INSERT INTO ac_station_param (station_id, param_key, param_name, param_value, param_content) VALUES 
        (        #{item.station_id},#{item.param_key},#{item.param_name},#{item.param_value},#{item.param_content}
        )
    </foreach>
</insert>

插入数据

insert into user (name, age, sex) values("张三"，"20","女")

insert into user (name, age, sex) values("李四"，"20","女")

语句之间必须有有换行符，才能执行成功，separator直接敲一个回车符号，用于换行，mapper.xml配置如下：

<insert id="insert" parameterType="java.util.ArrayList">

       <foreach collection="list" item="user" index="index" separator="

">
        insert into user(name, age, sex) values (#{user.name},#{user.age}, #{user.sex}  )

    </foreach>

</insert>