//使用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 >= #updatetimeStart#
</isNotNull>
<isNotNull property="updatetimeEnd">
AND UPDATETIME < #updatetimeEnd#
</isNotNull>
)
</isEqual>
</insert>