1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
| <script>INSERT INTO ar_bank_info
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test = 'policyNo != null'>policy_no, </if>
<if test = 'orderNo != null'>order_no, </if>
<if test = 'bankCode != null'>bank_code, </if>
<if test = 'bankName != null'>bank_name, </if>
<if test = 'bankIdNo != null'>bank_id_no, </if>
<if test = 'bankAccountName != null'>bank_account_name, </if>
<if test = 'bankProvince != null'>bank_province, </if>
<if test = 'bankCity != null'>bank_city, </if>
<if test = 'paymentForm != null'>payment_form, </if>
<if test = 'createTime != null'>create_time, </if>
<if test = 'backAmount != null'>back_amount, </if>
<if test = 'soStatus != null'>so_status, </if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test = 'policyNo != null'>#{policyNo}, </if>
<if test = 'orderNo != null'>#{orderNo}, </if>
<if test = 'bankCode != null'>#{bankCode}, </if>
<if test = 'bankName != null'>#{bankName}, </if>
<if test = 'bankIdNo != null'>#{bankIdNo}, </if>
<if test = 'bankAccountName != null'>#{bankAccountName}, </if>
<if test = 'bankProvince != null'>#{bankProvince}, </if>
<if test = 'bankCity != null'>#{bankCity}, </if>
<if test = 'paymentForm != null'>#{paymentForm}, </if>
<if test = 'createTime != null'>#{createTime}, </if>
<if test = 'backAmount != null'>#{backAmount}, </if>
<if test = 'soStatus != null'>#{soStatus}, </if>
</trim>
ON DUPLICATE KEY UPDATE
policy_no = VALUES(policy_no),
bank_name = VALUES(bank_name),
bank_id_no = VALUES(bank_id_no),
bank_code = VALUES(bank_code),
bank_account_name = VALUES(bank_account_name),
payment_form = VALUES(payment_form),
modify_time = VALUES(modify_time),
back_amount = VALUES(back_amount),
so_status = VALUES(so_status)
</script>
|