chainsqlexceptions.java

非常好的java事例以及带源码事例的java2教程

import java.sql.*;

public class ChainSQLExceptions
{
  public static void main(String[] args)
  {
    ChainSQLExceptions theApp = new ChainSQLExceptions();
    try
    {
      theApp.doQuery();               // Call the method that deals with the DB
    }
    catch(SQLException sqle)          // Catch the exception thrown by the method
    {
      do                              // loop through each exception
      {
        // do something with each exception
        System.err.println("Exception occurred:\nMessage: " + sqle.getMessage());
        System.err.println("SQL state: " + sqle.getSQLState());
        System.err.println("Vendor code: " + sqle.getErrorCode() +
                           "\n----------------");
      }while((sqle = sqle.getNextException()) != null);
    }
  }

  // Method to add an exception to a chain of SQLExceptions
  public void doQuery() throws SQLException
  {
    String url = "jdbc:odbc:technical_library";
    String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    String user = "guest";
    String password = "guest";
    String theStatement = "SELECT lastname, firstname FROM autors";

    try
    {
      Class.forName(driver);
      Connection connection = DriverManager.getConnection(url, user, password);
      Statement queryAuthors = connection.createStatement();
      ResultSet theResults = queryAuthors.executeQuery(theStatement);

      queryAuthors.close();
    }
    catch(ClassNotFoundException cnfe)
    {
      System.out.println(cnfe);
    }
    catch(SQLException sqle)
    {
      SQLException generatedException = new SQLException(        // New exception
                                      "SQL operation cancelled", // Message
                                      "S1008",                   // SQL state
                                      0);                        // Vendor code
      generatedException.setNextException(sqle);        // Append the old exception
      throw generatedException;    }                    // and throw the chain
  }
}