orace数据库,多线程,表中新建了唯一约束(多个字段),插入操作时报唯一约束错误,问题处理方法
程序员文章站
2022-03-26 21:37:30
...
表: create table SDS_CONFIRM_FOOTBALL_RESULT ( ID NUMBER not null, MID NUMBER not null, LID NUMBER not null, LEGNAME VARCHAR2(200) not null, MATCHNAME VARCHAR2(100) not null ); alter table SDS_CONFIRM_FOOTBALL_RESULT add constraint UQ_ID unique (MID, LID);
java代码xml中插入语句处理 insert into SDS_CONFIRM_FOOTBALL_RESULT (ID, MID, LID, LEGNAME, MATCHNAME) select 111112, 33, 44, '呵呵', 'aa VS bb' from dual where not exists (select 1 from SDS_CONFIRM_FOOTBALL_RESULT where MID = 33 and LID = 44 ) 意思是,如果表中不存在MID = 33 并且 LID = 44的记录,就插入一条 ID = 111112, MID=33, LID=44, LEGNAME= '呵呵', MATCHNAME='aa VS bb' 这样的记录,如果存在就不插入