<insert id="insertBatch" parameterType="java.util.List"> insert into tbl_order_drivers_relation (order_code, driver_id, status, delivery_time, finish_time) values <foreach collection="list" item="it" separator=","> <trim prefix="(" suffix=")" suffixOverrides=","> #{it.orderCode,jdbcType=VARCHAR}, #{it.driverId,jdbcType=VARCHAR}, #{it.status,jdbcType=VARCHAR}, #{it.deliveryTime,jdbcType=TIMESTAMP}, #{it.finishTime,jdbcType=TIMESTAMP}, </trim> </foreach> </insert>