MySQL 主键冲突异常如何全部捕获?

很多时候只要觉得捕获 DuplicateKeyException 就行，其实这样还不够，底层还会抛出其他异常类型，完整的捕获如下：

import org.springframework.dao.DuplicateKeyException;

public void method() {
    try {
            
        result = dao.insert(shopkeeperIndexDO);
    }
    catch (DuplicateKeyException e) {
        
        // do something

    }
    catch (Exception e) {
        String errorCode = getErrorCode(e);

        // 这也是主键冲突异常
        if (errorCode.indexOf("Duplicate entry") >= 0) {

            // do something

        }
        
        // do something
    }

}

private String getErrorCode(Exception e) {
    String errorCode = "";
    if (e.getCause() != null && e.getCause().getMessage() != null) {
        errorCode = e.getCause().getMessage();
    }
    if (Strings.isNullOrEmpty(errorCode) && e.getMessage() != null) {
        errorCode = e.getMessage();
    }

    return errorCode;
}

使用的mybatis框架。自测过程中 catch (Exception e) 始终没有出现。不知道是否真的像原博主那样会出现此异常。

 

转载：https://blog.csdn.net/yangyangrenren/article/details/118074041

 

 

 

 

 

TRANSLATE with x

English

Arabic	Hebrew	Polish
Bulgarian	Hindi	Portuguese
Catalan	Hmong Daw	Romanian
Chinese Simplified	Hungarian	Russian
Chinese Traditional	Indonesian	Slovak
Czech	Italian	Slovenian
Danish	Japanese	Spanish
Dutch	Klingon	Swedish
English	Korean	Thai
Estonian	Latvian	Turkish
Finnish	Lithuanian	Ukrainian
French	Malay	Urdu
German	Maltese	Vietnamese
Greek	Norwegian	Welsh
Haitian Creole	Persian

 

TRANSLATE with

COPY THE URL BELOW

Back

EMBED THE SNIPPET BELOW IN YOUR SITE

Enable collaborative features and customize widget: Bing Webmaster Portal

Back