trychainedsqlexceptioninfo.java

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· Java 代码 · 共 41 行

import java.sql.*;

public class TryChainedSQLExceptionInfo
{
  public static void main(String[] args)
  {
     String url = "jdbc:cloudscape:Wrox4370.db";
    String driver = "COM.cloudscape.core.JDBCDriver";

    String username = "guest";
    String password = "guest";

      String theStatement =
           "SELECT recordingid, recordingtitle, coverimagefilespec FROM rekordings";


    try
    {
      Class.forName(driver);
      Connection connection = DriverManager.getConnection(url, username, password);
      Statement queryRecordings = connection.createStatement();
      ResultSet theResults =  queryRecordings.executeQuery(theStatement);
      queryRecordings.close();
    }
    catch (ClassNotFoundException cnfe)
    {
     System.err.println(cnfe);
    }
    catch (SQLException sqle)
    {
      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);
    }
  }
}