sqlstatesqlexceptiontranslate.java~40~

一个完整的门户网站,基于JSP环境下开发的,使用SQL数据库.

package com.bwm.stateclass;

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

/**
 * <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 InalidDataAccessResourceUsageException("["+task+"]: SQL error ["+sql+"]",sqlex);
            }
        }
        return  new UncategorizedDataAccessException("["+task+"]: SQL error ["+sql+"]",sqlex);
    }

    public SQLStateSQLExceptionTranslate(String string, String string1,
                                         SQLException sqlex) {
                                             this.translate(string,sql,sqlex)
    }
}