<insert id="insertPreference" parameterType="com.svr.bean.line.BxlinePreference" useGeneratedKeys="true" keyProperty="preference.id">
INSERT INTO bx_line_preference
<trim prefix="(" suffix=")" suffixOverrides="," >
line_id,nike_id,departure,destination,
return_place,departure_time,arrval_time,price,
//下面4个字段根据用户输入插入值
<if test='preference.bedSingle != null and preference.bedSingle != ""'>
bed_single,
</if>
<if test='preference.bedDouble != null and preference.bedDouble != ""'>
bed_double,
</if>
<if test='preference.bedBig != null and preference.bedBig != ""'>
bed_big,
</if>
<if test='preference.bedHome != null and preference.bedHome != ""'>
bed_home,
</if>
food_standard,room_standard,ene_within,
scene_without,intercity_traffic,intracity_traffic
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
#{preference.lineId},#{preference.nikeId},#{preference.departure},
#{preference.destination},#{preference.returnPlace},#{preference.departureTime},
#{preference.arrvalTime},#{preference.price},
//根据用户输入插入对应值 无数据 为 null
<if test='preference.bedSingle != null and preference.bedSingle != ""'>
#{preference.bedSingle,jdbcType=NUMERIC},
</if>
<if test='preference.bedDouble != null and preference.bedDouble != ""'>
#{preference.bedDouble,jdbcType=NUMERIC},
</if>
<if test='preference.bedBig != null and preference.bedBig != ""'>
#{preference.bedBig,jdbcType=NUMERIC},
</if>
<if test='preference.bedHome != null and preference.bedHome != ""'>
#{preference.bedHome,jdbcType=NUMERIC},
</if>
#{preference.foodStandard},#{preference.roomStandard},#{preference.eneWithin},
#{preference.sceneWithout},#{preference.intercityTraffic},#{preference.intracityTraffic}
</trim>
</insert>
INSERT INTO bx_line_preference
<trim prefix="(" suffix=")" suffixOverrides="," >
line_id,nike_id,departure,destination,
return_place,departure_time,arrval_time,price,
//下面4个字段根据用户输入插入值
<if test='preference.bedSingle != null and preference.bedSingle != ""'>
bed_single,
</if>
<if test='preference.bedDouble != null and preference.bedDouble != ""'>
bed_double,
</if>
<if test='preference.bedBig != null and preference.bedBig != ""'>
bed_big,
</if>
<if test='preference.bedHome != null and preference.bedHome != ""'>
bed_home,
</if>
food_standard,room_standard,ene_within,
scene_without,intercity_traffic,intracity_traffic
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
#{preference.lineId},#{preference.nikeId},#{preference.departure},
#{preference.destination},#{preference.returnPlace},#{preference.departureTime},
#{preference.arrvalTime},#{preference.price},
//根据用户输入插入对应值 无数据 为 null
<if test='preference.bedSingle != null and preference.bedSingle != ""'>
#{preference.bedSingle,jdbcType=NUMERIC},
</if>
<if test='preference.bedDouble != null and preference.bedDouble != ""'>
#{preference.bedDouble,jdbcType=NUMERIC},
</if>
<if test='preference.bedBig != null and preference.bedBig != ""'>
#{preference.bedBig,jdbcType=NUMERIC},
</if>
<if test='preference.bedHome != null and preference.bedHome != ""'>
#{preference.bedHome,jdbcType=NUMERIC},
</if>
#{preference.foodStandard},#{preference.roomStandard},#{preference.eneWithin},
#{preference.sceneWithout},#{preference.intercityTraffic},#{preference.intracityTraffic}
</trim>
</insert>