Mybatis 动态SQL批量插入（有则更新无则插入）

（1）接口Dao层方法

package com.ict.dao;import com.ict.model.Config_Fusion;import org.apache.ibatis.annotations.Param;import org.springframework.stereotype.Repository;import java.util.List;/** * Created by chenlong on 2016/6/21. */@Repositorypublic interface IArtificialDao {    void setBatchEliminationList(@Param("list") List<Config_Fusion> cfList);}

（2）Mapper层映射方法

<insert id="setBatchEliminationList" parameterType="com.ict.model.Config_Fusion" >        replace into Config_Fusion(configSequenceNum,Orig_Info_Type,secondsBeforeDeleteTarget,udt_By,udt_Time_UTC)        VALUES        <foreach collection="list" item="list" separator=",">            (0,#{list.orig_Info_Type},#{list.secondsBeforeDeleteTarget},#{list.udt_By},unix_timestamp(now()))        </foreach></insert>

（3）com.ict.model包里的Config_Fusion对象

package com.ict.model;/** * Created by chenlong on 2016/12/28. */public class Config_Fusion {    public int secondsBeforeDeleteTarget;    public int orig_Info_Type;    public String udt_By;    public long udt_Time_UTC;    public Config_Fusion() {    }    public Config_Fusion(int secondsBeforeDeleteTarget, String udt_By) {        this.secondsBeforeDeleteTarget = secondsBeforeDeleteTarget;        this.udt_By = udt_By;    }    public Config_Fusion(int secondsBeforeDeleteTarget, int orig_Info_Type, String udt_By) {        this.secondsBeforeDeleteTarget = secondsBeforeDeleteTarget;        this.orig_Info_Type = orig_Info_Type;        this.udt_By = udt_By;    }    public int getSecondsBeforeDeleteTarget() {        return secondsBeforeDeleteTarget;    }    public void setSecondsBeforeDeleteTarget(int secondsBeforeDeleteTarget) {        this.secondsBeforeDeleteTarget = secondsBeforeDeleteTarget;    }    public long getUdt_Time_UTC() {        return udt_Time_UTC;    }    public void setUdt_Time_UTC(long udt_Time_UTC) {        this.udt_Time_UTC = udt_Time_UTC;    }    public String getUdt_By() {        return udt_By;    }    public void setUdt_By(String udt_By) {        this.udt_By = udt_By;    }    public int getOrig_Info_Type() {        return orig_Info_Type;    }    public void setOrig_Info_Type(int orig_Info_Type) {        this.orig_Info_Type = orig_Info_Type;    }}