Prentice Hall and Sun Microsystems. Personal use only; do not redistribute.

18.3 Some JDBC Utilities

475

Listing 18.6  DatabaseUtilities.java (continued)

    try {

      Class.forName(driver);

      Connection connection =

        DriverManager.getConnection(url, username, password);

      return(getQueryResults(connection, query, close));

    } catch(ClassNotFoundException cnfe) {

      System.err.println("Error loading driver: " + cnfe);

      return(null);

    } catch(SQLException sqle) {

      System.err.println("Error connecting: " + sqle);

      return(null);

    }

  }

  /** Retrieves results as in previous method but uses

   *  an existing connection instead of opening a new one.

   */

  public static DBResults getQueryResults(Connection connection,

                                          String query,

                                          boolean close) {

    try {

      DatabaseMetaData dbMetaData = connection.getMetaData();

      String productName =

        dbMetaData.getDatabaseProductName();

      String productVersion =

        dbMetaData.getDatabaseProductVersion();

      Statement statement = connection.createStatement();

      ResultSet resultSet = statement.executeQuery(query);

      ResultSetMetaData resultsMetaData =

        resultSet.getMetaData();

      int columnCount = resultsMetaData.getColumnCount();

      String[] columnNames = new String[columnCount];

      // Column index starts at 1 (a la SQL) not 0 (a la Java).

      for(int i=1; i