listing 11-2.java

来自「这是JAVA开发大全的源代码」· Java 代码 · 共 79 行

import java.sql.*;
public class ModelB 
{
  private Connection Database;
  private Statement DataRequest;
  private ResultSet Results;
  public ModelB ()
  {
    String url = "jdbc:odbc:CustomerInformation";
    String userID = "jim";
    String password = "keogh";
    try {
      Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
      Database = DriverManager.getConnection(url,userID,password);
    }
    catch (ClassNotFoundException error) {
      System.err.println("Unable to load the JDBC/ODBC bridge." + error);
      System.exit(1);
    }
    catch (SQLException error) {
      System.err.println("Cannot connect to the database." + error);
      System.exit(2);
    }
    try {
      // Enter example code here
    }
    catch ( SQLException error ){
      System.err.println("SQL error." + error);
      if(Database != null) {
        try {
          Database.close();
        }
        catch(SQLException er){}
        }
      System.exit(3);
    }
    if(Database != null) {
      try {
        Database.close();
      }
      catch(SQLException er){}
      }
    }
    private void DisplayResults (ResultSet DisplayResults) 
                 throws SQLException
    {
      boolean Records = DisplayResults.next();
      if (!Records ) {
        System.out.println( "No data returned");
        return;
      }
      try {
        do {
          DownRow( DisplayResults) ;
        } while ( DisplayResults.next() );
      }
      catch (SQLException error ) {
        System.err.println("Data display error." + error);
        if(Database != null) {
          try {
            Database.close();
          }
          catch(SQLException er){}
          }
        System.exit(4);
      }
    }
    private  void DownRow ( ResultSet DisplayResults ) 
                  throws SQLException
    {
      //Enter new DownRow() code here
    }
    public static void main ( String args [] )
    {
      final ModelB sql1 = new ModelB ();
      System.exit ( 0 ) ;
    }
}