sqlstatesqlexceptiontranslate.java~29~

来自「一个完整的门户网站,基于JSP环境下开发的,使用SQL数据库.」· JAVA~29~ 代码 · 共 29 行

package com.bwm.stateclass;

import com.bwm.coreinterface.SQLExceptionTranslate;
import com.bwm.coreclass.CCException;
import com.bwm.coreclass.InalidDataAccessApiUsageException;
import com.bwm.coreclass.UncategorizedDataAccessException;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: MR</p>
 * @author BWM
 * @version 1.0
 */

public class SQLStateSQLExceptionTranslate implements SQLExceptionTranslate {
    public CCException translate(String task, String sql, SQLException sqlex) {
        if (sqlex.getSQLState() != null) {
            if (sqlex.getSQLState().equals("42000")||sqlex.getSQLState().equals("S1009")) {
                throw new InalidDataAccessApiUsageException("["+task+"]: SQL error ["+sql+"]",sqlex);
            }else if(sqlex.getSQLState().equals("S1002")){
                throw new InalidDataAccessApiUsageException("["+task+"]: SQL error ["+sql+"]",sqlex);
            }
        }
        return  new UncategorizedDataAccessException("["+task+"]: SQL error ["+sql+"]",sqlex);
    }
}