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

18.2 Basic JDBC Example

471

Listing 18.4  DriverUtilities.java (continued)

  /** Build a URL in the format needed by the

   *  Oracle and Sybase drivers I am using.

   */

  public static String makeURL(String host, String dbName,

                               int vendor) {

    if (vendor == ORACLE) {

      return("jdbc:oracle:thin:@" + host + ":1521:" + dbName);

    } else if (vendor == SYBASE) {

      return("jdbc:sybase:Tds:" + host  + ":1521" +

             "?SERVICENAME=" + dbName);

    } else {

      return(null);

    }

  }

  /** Get the fully qualified name of a driver. */

  public static String getDriver(int vendor) {

    if (vendor == ORACLE) {

      return("oracle.jdbc.driver.OracleDriver");

    } else if (vendor == SYBASE) {

      return("com.sybase.jdbc.SybDriver");

    } else {

      return(null);

    }

  }

  /** Map name to int value. */

  public static int getVendor(String vendorName) {

    if (vendorName.equalsIgnoreCase("oracle")) {

      return(ORACLE);

    } else if (vendorName.equalsIgnoreCase("sybase")) {

      return(SYBASE);

    } else {

      return(UNKNOWN);

    }

  }

}

Second edition of this book: www.coreservlets.com; Sequel: www.moreservlets.com.

Servlet and JSP training courses by book's author: courses.coreservlets.com.