mybatis

<insert id="addAlarmLinkage" parameterType="alarmLinkage">
<selectKey keyProperty="id" resultType="int" order="BEFORE">
<![CDATA[
select nextval('tbl_alarm_linkage_id_seq')
]]>
</selectKey>
<![CDATA[
insert into TBL_ALARM_LINKAGE(id,alarm_in_code,alarm_type_id,action_type,param)
    values(#{id},#{alarmResCode},#{alarmType},#{actionType},#{param})
    ]]>
    </insert>
   
    <update id="modAlarmLinkage" parameterType="alarmLinkage">
    <![CDATA[
update TBL_ALARM_LINKAGE set param = #{param}
    where alarm_in_code = #{alarmResCode} and alarm_type_id = #{alarmType}
         and action_type = #{actionType}
]]>
    </update>
   
    <delete id="delAlarmLinkage" parameterType="alarmLinkage">
    <![CDATA[
        delete from TBL_ALARM_LINKAGE
            where alarm_in_code = #{alarmResCode} and alarm_type_id = #{alarmType}
         and action_type = #{actionType}
]]>
    </delete>