MyBatis批量增加

Dao层代码：

@Override
public int multiInsert(List<TSwitch> list) {
    int i=tSwitchDao.multiInsert(list);
    return i;
}

配置文件代码：

<insert id="multiInsert" parameterType="java.util.List"  >
    insert into t_switch (allocateDetailId, allocateid, time,
    pname, ponunite, categoryname,
    categorycode, allocateCount, inreponame,
    inrepocde, outreponame, outrepocode,
    firststate, secondstate, firstcheck,
    secondcheck, firsttime, secondtime,
    proid, prostandard)
    values
    <foreach collection="list" item="record" index="index" separator=",">
        (#{record.allocatedetailid,jdbcType=VARCHAR}, #{record.allocateid,jdbcType=VARCHAR}, #{record.time,jdbcType=TIMESTAMP},
        #{record.pname,jdbcType=VARCHAR}, #{record.ponunite,jdbcType=VARCHAR}, #{record.categoryname,jdbcType=VARCHAR},
        #{record.categorycode,jdbcType=VARCHAR}, #{record.allocatecount,jdbcType=DOUBLE}, #{record.inreponame,jdbcType=VARCHAR},
        #{record.inrepocde,jdbcType=VARCHAR}, #{record.outreponame,jdbcType=VARCHAR}, #{record.outrepocode,jdbcType=VARCHAR},
        #{record.firststate,jdbcType=TINYINT}, #{record.secondstate,jdbcType=TINYINT}, #{record.firstcheck,jdbcType=VARCHAR},
        #{record.secondcheck,jdbcType=VARCHAR}, #{record.firsttime,jdbcType=TIMESTAMP}, #{record.secondtime,jdbcType=TIMESTAMP},
        #{record.proid,jdbcType=VARCHAR}, #{record.prostandard,jdbcType=VARCHAR})
    </foreach>
</insert>

 

注意：foreach中的字段要写成record.字段名称（item="record"，record的来源）