JAVA中捕获SQL中存储过程的异常信息

JAVA中捕获SQL中存储过程的异常信息(2007-05-19 20:41:46)转载▼ 分类： Java编程 
//在java中捕获sql存储过程中的异常
//java代码：

package sqlexceptiontest;
import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerException;
public class SqlException{
        Connection conn  = null;
        Statement  stmt  = null; //执行SQL语句的对象
        ResultSet  rs    = null;
        public SqlException() {
                String     jdbcDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
                String     jdbcUrl    = "jdbc:sqlserver://localhost:1433;database=zhang";
                String     jdbcUser   = "sa";
                String     jdbcPwd    = "123";
                try {

                        Class.forName(jdbcDriver);
                        conn=DriverManager.getConnection(jdbcUrl,jdbcUser,jdbcPwd);
                        java.sql.CallableStatement call=conn.prepareCall("{call excep(?,?,?)}");
                        call.setInt(1,1);
                        call.setInt(2,0);
                        call.registerOutParameter(3,java.sql.Types.VARCHAR);
                        call.execute();
                        System.out.println(call.getString(3));
                }
                catch(SQLServerException e) {
                        e.printStackTrace();
                }
    catch (ClassNotFoundException ex)
    {
    
    }
    catch (SQLException ex)
    {
    
    }

  }
        public static void main(String[] args)
        {
          SqlException db=new SqlException();

        }
}


=====================
SQL代码

create database zhang
go
use zhang
go

create proc excep
@beichushu int,
@chushu int,
@error varchar(max) output
as
begin try
declare @shang int
set @shang=@beichushu/@chushu
print @shang
end try
begin catch
set @error='错误信息'+ERROR_MESSAGE()
end catch
drop proc excep
declare @error varchar(max)
exec excep 5,0,@error output
print @error
分享： 分享到新浪Qing