<!-- 插入集合 -->
<insert id="insertListSelective" parameterType="java.util.List">
INSERT INTO art_customer_leads_pool
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
<if test="activityId != null">activity_id,</if>
<if test="activityName != null">activity_name,</if>
<if test="comCode != null">com_code,</if>
<if test="comName != null">com_name,</if>
<if test="customerName != null">customer_name,</if>
<if test="licenseNo != null">license_no,</if>
<if test="expiryMonth != null">expiry_month,</if>
<if test="mobile != null">mobile,</if>
<if test="referrerStaffNo != null">referrer_staff_no,</if>
<if test="referrerType != null">referrer_type,</if>
<if test="status != null">status,</if>
<if test="source != null">source,</if>
<if test="leadInboundTime != null">lead_inbound_time,</if>
<if test="createTime != null">create_time,</if>
<if test="updateTime != null">update_time,</if>
</trim>
VALUES
<foreach collection="item" index="index" item="item" separator=",">
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="item.id != null">#{item.id, jdbcType=BIGINT},</if>
<if test="item.activityId != null">#{item.activityId, jdbcType=VARCHAR},</if>
<if test="item.activityName != null">#{item.activityName, jdbcType=VARCHAR},</if>
<if test="item.comCode != null">#{item.comCode, jdbcType=VARCHAR},</if>
<if test="item.comName != null">#{item.comName, jdbcType=VARCHAR},</if>
<if test="item.customerName != null">#{item.customerName, jdbcType=VARCHAR},</if>
<if test="item.licenseNo != null">#{item.licenseNo, jdbcType=VARCHAR},</if>
<if test="item.expiryMonth != null">#{item.expiryMonth, jdbcType=DATE},</if>
<if test="item.mobile != null">#{item.mobile, jdbcType=VARCHAR},</if>
<if test="item.referrerStaffNo != null">#{item.referrerStaffNo, jdbcType=VARCHAR},</if>
<if test="item.referrerType != null">#{item.referrerType, jdbcType=VARCHAR},</if>
<if test="item.status != null">#{item.status, jdbcType=SMALLINT},</if>
<if test="item.source != null">#{item.source, jdbcType=VARCHAR},</if>
<if test="item.leadInboundTime != null">#{item.leadInboundTime, jdbcType=DATE},</if>
<if test="item.createTime != null">#{item.createTime, jdbcType=DATE},</if>
<if test="item.updateTime != null">#{item.updateTime, jdbcType=DATE},</if>
</trim>
</foreach>
</insert>
public interface ArtCustomerLeadsPoolExtMapper {
int insertListSelective(@Param("item") List<ArtCustomerLeadsPool> record);
}我这个那里写错了
最新发布