<!-- 新增或更新 -->
<insert id="saveMessage" parameterType="com.guagua.admin.model.EventMessageCache" >
IF EXISTS (SELECT 1
FROM t_event_message_cache
WHERE msg_key = #{msgKey})
BEGIN
UPDATE t_event_message_cache
SET msg_value = #{msgValue}
WHERE msg_key = #{msgKey}
END
ELSE
BEGIN
insert into t_event_message_cache
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="msgKey != null" >
msg_key,
</if>
<if test="msgValue != null" >
msg_value,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="msgKey != null" >
#{msgKey,jdbcType=VARCHAR},
</if>
<if test="msgValue != null" >
#{msgValue,jdbcType=VARCHAR},
</if>
</trim>
END
</insert>
<insert id="saveMessage" parameterType="com.guagua.admin.model.EventMessageCache" >
IF EXISTS (SELECT 1
FROM t_event_message_cache
WHERE msg_key = #{msgKey})
BEGIN
UPDATE t_event_message_cache
SET msg_value = #{msgValue}
WHERE msg_key = #{msgKey}
END
ELSE
BEGIN
insert into t_event_message_cache
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="msgKey != null" >
msg_key,
</if>
<if test="msgValue != null" >
msg_value,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="msgKey != null" >
#{msgKey,jdbcType=VARCHAR},
</if>
<if test="msgValue != null" >
#{msgValue,jdbcType=VARCHAR},
</if>
</trim>
END
</insert>