数据库中建立了约束:CREATE
TABLE TP_SUBSIDY_REG
(
TP_SUBSIDY_REG_ID CHAR(32) NOT NULL,
LEAF_REFUSE_REG_NO VARCHAR2(32),
INVOICE_NO VARCHAR2(32),
ORG_CD VARCHAR2(32),
BUSINESS_YEAR CHAR(4),
SEND_STATE CHAR(1),
MODIFY_TIME TIMESTAMP(6),
SEND_TIME TIMESTAMP(6),
PACKAGE_TIME TIMESTAMP(6),
DATA_STATE CHAR(1),
LAST_TIME TIMESTAMP(6),
CONSTRAINT PK_TP_SUBSIDY_REG PRIMARY KEY (TP_SUBSIDY_REG_ID),
CONSTRAINT TP_SUBSIDY_REG_UN UNIQUE (LEAF_REFUSE_REG_NO, INVOICE_NO)
)
后台保存时如果已经重复数据(LEAF_REFUSE_REG_NO, INVOICE_NO)再做保存,会抛出异常,怎么忽略这个异常
try{
tpSubsidyRegDao.saveTpSubsidyRegAll(subsidyRegList);
} catch(Exception e) {
e.printStackTrace();
} finally {
}
TABLE TP_SUBSIDY_REG
(
TP_SUBSIDY_REG_ID CHAR(32) NOT NULL,
LEAF_REFUSE_REG_NO VARCHAR2(32),
INVOICE_NO VARCHAR2(32),
ORG_CD VARCHAR2(32),
BUSINESS_YEAR CHAR(4),
SEND_STATE CHAR(1),
MODIFY_TIME TIMESTAMP(6),
SEND_TIME TIMESTAMP(6),
PACKAGE_TIME TIMESTAMP(6),
DATA_STATE CHAR(1),
LAST_TIME TIMESTAMP(6),
CONSTRAINT PK_TP_SUBSIDY_REG PRIMARY KEY (TP_SUBSIDY_REG_ID),
CONSTRAINT TP_SUBSIDY_REG_UN UNIQUE (LEAF_REFUSE_REG_NO, INVOICE_NO)
)
后台保存时如果已经重复数据(LEAF_REFUSE_REG_NO, INVOICE_NO)再做保存,会抛出异常,怎么忽略这个异常
try{
tpSubsidyRegDao.saveTpSubsidyRegAll(subsidyRegList);
} catch(Exception e) {
e.printStackTrace();
} finally {
}
tpSubsidyRegDao.saveTpSubsidyRegAll(subsidyRegList);
} catch(Exception e) {
//忽略
} finally { }