使用on conflict(id),例如:
INSERT INTO deleted_data (id,dataType,searchKey,objData,createTime) VALUES (#{id},#{dataType,jdbcType=INTEGER},#{searchKey,jdbcType=VARCHAR},#{objData, jdbcType=VARCHAR},(select sysdate from dual))
on conflict(id) do UPDATE set createTime = (select sysdate from dual)
或者什么也不做,on conflict (id) do nothing;