[简单]mybatis insert语句添加动态字段

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
41
42
43
44
<insert id="saveTestTb" useGeneratedKeys="true" keyProperty="id"
parameterType="TestTb">
insert into
db_ap_fgm_TestTb(id,traffic_type
<include refid="getTestTbField" />
)
values(#{id},#{trafficType}
<include refid="getTestTbValue" />
)
</insert>
<sql id="getTestTbField">
<trim prefix="," suffixOverrides=",">
<if
test="testA!=null and testA!='null' and testA!=''">
TESTA,
</if>
<if test="level!=null and level!='null' and level!=''">
LEVEL,
</if>
<if test="state!=null and state!='null' and state!=''">
STATE,
</if>
<if test="description!=null and description!='null' and description!=''">
DESCRIPTION
</if>
</trim>
</sql>
<sql id="getTestTbValue">
<trim prefix="," suffixOverrides=",">
<if
test="testA!=null and testA!='null' and testA!=''">
#{testA},
</if>
<if test="level!=null and level!='null' and level!=''">
#{level},
</if>
<if test="state!=null and state!='null' and state!=''">
#{state},
</if>
<if test="description!=null and description!='null' and description!=''">
#{description}
</if>
</trim>
</sql>