鍦∕yBatis涓壒閲忔彃鍏ュ鏉℃暟鎹彲浠ヤ娇鐢?code><foreach>鏍囩鏉ュ疄鐜般€備笅闈㈡槸浣跨敤<foreach>鏍囩鎵归噺鎻掑叆澶氭潯鏁版嵁鐨勭ず渚嬶細

<insert id="batchInsert" parameterType="java.util.List">
    INSERT INTO table_name (column1, column2, column3)
    VALUES
    <foreach collection="list" item="item" separator="," >
        (#{item.column1}, #{item.column2}, #{item.column3})
    </foreach>
</insert>

鍦ㄤ笂闈㈢殑绀轰緥涓紝<insert>鏍囩涓畾涔変簡涓€涓壒閲忔彃鍏ョ殑SQL璇彞锛屽叾涓娇鐢ㄤ簡<foreach>鏍囩鏉ュ惊鐜亶鍘嗕紶鍏ョ殑List鍙傛暟锛屽苟灏嗘瘡涓厓绱犳彃鍏ュ埌鏁版嵁搴撲腑銆?/p>

浣跨敤鏃跺彲浠ュ湪Mapper鎺ュ彛涓畾涔夊搴旂殑鏂规硶锛屽苟浼犲叆涓€涓寘鍚鏉℃暟鎹殑List瀵硅薄浣滀负鍙傛暟锛屽涓嬫墍绀猴細

public interface MyMapper {
    void batchInsert(List<MyEntity> list);
}

鐒跺悗鍦ㄨ皟鐢ㄨ鏂规硶鏃朵紶鍏ュ鏉℃暟鎹殑List瀵硅薄鍗冲彲瀹炵幇鎵归噺鎻掑叆澶氭潯鏁版嵁锛?/p>

List<MyEntity> list = new ArrayList<>();
list.add(new MyEntity("value1", "value2", "value3"));
list.add(new MyEntity("value4", "value5", "value6"));

myMapper.batchInsert(list);

杩欐牱灏卞彲浠ュ疄鐜板湪MyBatis涓壒閲忔彃鍏ュ鏉℃暟鎹€?/p>