mybitis 动态插入

<insert id="insertShelf" parameterType="com.aspire.aplus.entity.model.welfareManage.Shelf">
INSERT INTO t_shelf 
<trim prefix="(" suffix=")"  suffixOverrides="," >
<if test="settleDays != null and settleDays !=''" >
       settle_days,
    </if>
<if test="settleRatio != null and settleRatio !=''" >
       settle_ratio,
    </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
     <if test="settleDays != null and settleDays !=''" >
       #{settleDays},
     </if>
     <if test="settleRatio != null and settleRatio !=''" >
       #{settleRatio},
     </if>
    </trim>

</insert> 

如果你是湖南的 欢迎加入 湖南人在深圳-Java群：557651502