<insert id="updateCustomerProperty" parameterType="list" statementType="PREPARED">
<foreach collection="primeCustomerInfoParamList" item="primeCustomerInfoParam" index="index" open="" close="" separator=",">
<if test = "primeCustomerInfoParam.startDate != null and primeCustomerInfoParam.startDate != ''">
UPDATE prime_customer
SET
start_date = #{primeCustomerInfoParam.startDateNew},
end_date = #{primeCustomerInfoParam.endDate},
prime_id = #{primeCustomerInfoParam.primeId},
update_user = #{primeCustomerInfoParam.updateUser},
update_date = #{primeCustomerInfoParam.updateDate}
WHERE buten_code = #{primeCustomerInfoParam.butenCode}
AND account_number = #{primeCustomerInfoParam.accountNumber}
AND start_date = #{primeCustomerInfoParam.startDate}
</if>
<if test = "primeCustomerInfoParam.startDate == null or primeCustomerInfoParam.startDate == ''">
INSERT INTO prime_customer
(buten_code,
account_number,
start_date,
mkdb_id,
end_date,
prime_id,
et10_status,
prime_service_status,
create_user,
create_date,
update_user,
update_date)
VALUES(
#{primeCustomerInfoParam.butenCode},
#{primeCustomerInfoParam.accountNumber},
#{primeCustomerInfoParam.startDateNew},
#{primeCustomerInfoParam.mkdbId},
#{primeCustomerInfoParam.endDate},
#{primeCustomerInfoParam.primeId},
'0',
'0',
#{primeCustomerInfoParam.createUser},
#{primeCustomerInfoParam.createDate},
#{primeCustomerInfoParam.updateUser},
#{primeCustomerInfoParam.updateDate}
)
</if>
</foreach>
</insert >
每次生成的SQL文都是insert和update都有。这样写不可以吗？请高人指点一下。
