<insert id="XXX" parameterType="XXX对应的实体类" >
insert into TEST
//插入的参数列表
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="id != null" >
ID,
</if>
<if test="pr1 != null" >
PR1,
</if>
<if test="pr2 != null" >
PR2,
</if>
</trim>
//参数列表对应的值 ,以及值的类型
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="id != null" >
#{id,jdbcType=VARCHAR},
</if>
<if test="pr1 != null" >
#{pr1,jdbcType=VARCHAR},
</if>
<if test="pr2 != null" >
#{pr2,jdbcType=VARCHAR},
</if>
</trim>
</insert>