<!-- 保存或更新 -->
<insert id="saveOrUpdate" parameterType="shopnav">
<selectKey keyProperty="count" resultType="int" order="BEFORE">
select count(*) as count from shop_nav where shop_nav_id =
#{shopNavId} and shop_id = #{shopId}
</selectKey>
<!-- 如果大于0则更新 -->
<if test="count>0">
update shop_nav set
shop_id=#{shopId,jdbcType=INTEGER},
nav_name=#{navName,jdbcType=VARCHAR},
nav_code=#{navCode,jdbcType=VARCHAR},
shop_url=#{shopUrl,jdbcType=VARCHAR},
is_delete=#{isDelete,jdbcType=VARCHAR},
sort_num=#{sortNum,jdbcType=INTEGER}
WHERE shop_nav_id = #{shopNavId} and shop_id = #{shopId}
</if>
<!-- 如果等于0则保存 -->
<if test="count==0">
insert into shop_nav(
shop_id,
nav_name,
nav_code,
shop_url,
is_delete,
sort_num,
add_date
) VALUES (
#{shopId,jdbcType=INTEGER},
#{navName,jdbcType=VARCHAR},
#{navCode,jdbcType=VARCHAR},
#{shopUrl,jdbcType=VARCHAR},
#{isDelete,jdbcType=VARCHAR},
#{sortNum,jdbcType=INTEGER},
#{addDate,jdbcType=DATE}
)
</if>
</insert>