Mybatis 批量插入

mapper接口

int addBatchFarmDevice(@Param("devices") List<FarmDevice> devices);

注意：@Param(“devices”)注解不能省

mapper.xml

 <insert id="addBatchFarmDevice" >
        insert into farm_device
        (
        id,farm_id,install_time,device_no
        ) VALUES
        <foreach collection="devices" item="item" index="index" separator=",">
            (
            #{item.id}, #{item.farmId}, #{item.installTime}, #{item.deviceNo}
            )
        </foreach>

    </insert>