mybatis防重复插入(oracle数据库)

 

 //使用mybatis标签控制是否防重复插入
​<insert id ="insertLog">
 INSERT INTO HMAOP_HEAD_CHECKIN
			(
			ID,
			TELNUM,
			CHANNELID,
			SRVID,
			PARAMS,
			UPDATETIME,
			OPERSTATUS,
			STATUS,
			TOKEN,
			EVENTID,
			UNIQUEID,
			ORDERID,
			PAYDATE
			)
		SELECT
			#id#,
			#telnum#,
			#channelid#,
			#srvid#,
			#params#,
			SYSDATE,
			'0',
			'0',
			#token#,
			#eventid#,
			#uniqueid#,
			#orderid#,
			#paydate#
		FROM DUAL
		<isEqual property="limitForOne" compareValue="true"> 
        WHERE
		NOT EXISTS
			(
				SELECT 1 FROM HMAOP_HEAD_CHECKIN WHERE
				TELNUM = #telnum#
				AND
				SRVID = #srvid#
				AND
				EVENTID = #eventid#
				AND
				UNIQUEID = #uniqueid#
				<isNotNull property="updatetimeStart">
					AND UPDATETIME &gt;= #updatetimeStart#
				</isNotNull>
				<isNotNull property="updatetimeEnd">
					AND UPDATETIME &lt; #updatetimeEnd#
				</isNotNull>
			)
		</isEqual>
	</insert>


​