/* * @(#)BuildIndy * * Copyright (c) 1998 Karl Moss. All Rights Reserved. * * You may study, use, modify, and distribute this software for any * purpose provided that this copyright notice appears in all copies. * * This software is provided WITHOUT WARRANTY either expressed or * implied. * * @author  Karl Moss * @version 1.0 * @date    11Mar98 * */package javaservlets.db;import java.sql.*;/** * <p>This applications builds the sample Indianapolis 500 winner * database. */public class BuildIndy{  String m_tableName = "IndyWinners";  /**    * <p>Main entry point for the application    *    * The usage for the application is:    *    *   BuildIndy <driver> <URL> [<user>] [<password>]    *    * where    *   driver   = the JDBC driver class name to use (such as    *              sun.jdbc.odbc.JdbcOdbcDriver)    *   URL      = the JDBC connection URL    *   user     = the optional user name    *   password = the optional password    */  public static void main(String args[])    {      String driver = null;      String url = null;      String user = null;      String password = null;      boolean needHelp = false;      // Get the driver name      if (args.length > 0) {        driver = args[0];      }      else {        needHelp = true;      }      // Get the URL      if (args.length > 1) {        url = args[1];      }      else {        needHelp = true;      }      // Get the optional user name      if (args.length > 2) {        user = args[2];      }      // Get the optional password      if (args.length > 3) {        password = args[3];      }      // If the user needs help with the arguments, display it      if (needHelp) {        System.out.println("\nUsage: BuildIndy <driver> " +                           "<URL> [<user>] [<password>]");      }      else {        BuildIndy o = new BuildIndy();        o.build(driver, url, user, password);      }    }  /**    * <p>Build the database table    *    * @param driver JDBC driver class name    * @param url JDBC connection URL    * @param user User name    * @param password User password    */  private void build(String driver, String url,                     String user, String password)    {      java.sql.Connection con = null;      java.sql.PreparedStatement ps = null;      try {        // Attempt to create a new instance of the specified        // JDBC driver. Well behaved drivers will register        // themselves with the JDBC DriverManager when they        // are instantiated        trace("Registering " + driver);        java.sql.Driver d = (java.sql.Driver)          Class.forName(driver).newInstance();        // Create a connection to the given URL        con = java.sql.DriverManager.getConnection(url, user,                                                   password);        // Create a new helper class        SQLHelper helper = new SQLHelper(con);        // Drop the table        trace("Dropping existing " + m_tableName + " table");        helper.drop(m_tableName);        // Setup the columns        ColumnDesc cols[] = new ColumnDesc[3];        cols[0] = new ColumnDesc("Year", Types.INTEGER);        cols[1] = new ColumnDesc("Driver", Types.VARCHAR);        cols[2] = new ColumnDesc("AvgSpeed", Types.DOUBLE);        // Create the table        trace("Creating table " + m_tableName);        helper.create(m_tableName, cols);        // Add data to the table        ps = helper.prepareInsert(m_tableName, cols);        add(ps, 1997,"Arie Luyendyk",145.827);        add(ps, 1996,"Buddy Lazier",147.956);        add(ps, 1995,"Jacques Villenueve",153.616);        add(ps, 1994,"Al Unser Jr.",160.872);        add(ps, 1993,"Emerson Fittipaldi",157.207);        add(ps, 1992,"Al Unser Jr.",134.212);        add(ps, 1991,"Rick Mears",176.460);        add(ps, 1990,"Arie Luyendyk",185.984);        add(ps, 1989,"Emerson Fittipaldi",167.581);        add(ps, 1988,"Rick Mears",144.809);        add(ps, 1987,"Al Unser Sr.",162.175);        add(ps, 1986,"Bobby Rahal",170.722);        add(ps, 1985,"Danny Sullivan",152.982);        add(ps, 1984,"Rick Mears",163.612);        add(ps, 1983,"Tom Sneva",162.117);        add(ps, 1982,"Gordon Johncock",162.029);        add(ps, 1981,"Bobby Unser",139.084);        add(ps, 1980,"Jonny Rutherford",142.862);        add(ps, 1979,"Rick Mears",158.899);        add(ps, 1978,"Al Unser Sr.",161.363);        add(ps, 1977,"A.J. Foyt",161.331);        add(ps, 1976,"Jonny Rutherford",148.725);        add(ps, 1975,"Bobby Unser",149.213);        add(ps, 1974,"Jonny Rutherford",158.589);        add(ps, 1973,"Gordon Johncock",159.036);        add(ps, 1972,"Mark Donohue",162.962);        add(ps, 1971,"Al Unser Sr.",157.735);        add(ps, 1970,"Al Unser Sr.",155.749);        add(ps, 1969,"Mario Andretti",156.867);        add(ps, 1968,"Bobby Unser",152.882);        add(ps, 1967,"A.J. Foyt",151.207);        add(ps, 1966,"Graham Hill",144.317);        add(ps, 1965,"Jimmy Clark",150.686);        add(ps, 1964,"A.J. Foyt",147.350);        add(ps, 1963,"Parnelli Jones",143.187);        add(ps, 1962,"Roger Ward",140.293);        add(ps, 1961,"A.J. Foyt",139.131);        add(ps, 1960,"Jim Rathmann",138.767);        add(ps, 1959,"Roger Ward",135.857);        add(ps, 1958,"Jim Bryan",133.791);        add(ps, 1957,"Sam Hanks",135.601);        add(ps, 1956,"Pat Flaherty",128.490);        add(ps, 1955,"Bob Sweikert",128.209);        add(ps, 1954,"Bill Vukovich",130.840);        add(ps, 1953,"Bill Vukovich",128.740);        add(ps, 1952,"Troy Ruttman",128.922);        add(ps, 1951,"Lee Wallard",126.244);        add(ps, 1950,"Jonnie Parsons",124.002);        add(ps, 1949,"Bill Holland",121.327);        add(ps, 1948,"Mauri Rose",119.814);        add(ps, 1947,"Mauri Rose",116.338);        add(ps, 1946,"George Robson",114.820);        add(ps, 1945,"(no race)",0);        add(ps, 1944,"(no race)",0);        add(ps, 1943,"(no race)",0);        add(ps, 1942,"(no race)",0);        add(ps, 1941,"Floyd Davis/Mauri Rose",115.117);        add(ps, 1940,"Wilbur Shaw",115.030);        add(ps, 1939,"Wilbur Shaw",114.277);        add(ps, 1938,"Floyd Roberts",117.200);        add(ps, 1937,"Wilbur Shaw",113.580);        add(ps, 1936,"Louis Meyer",109.069);        add(ps, 1935,"Kelly Petillo",106.240);        add(ps, 1934,"William Cummings",104.863);        add(ps, 1933,"Louis Meyer",104.162);        add(ps, 1932,"Fred Frame",104.114);        add(ps, 1931,"Louis Schneider",96.629);        add(ps, 1930,"Billy Arnold",100.448);        add(ps, 1929,"Ray Keech",97.585);        add(ps, 1928,"Louis Meyer",99.482);        add(ps, 1927,"George Souders",97.545);        add(ps, 1926,"Frank Lockhart",95.904);        add(ps, 1925,"Peter DePaolo",101.127);        add(ps, 1924,"L.L Corum/Joe Boyer",98.234);        add(ps, 1923,"Tommy Milton",90.954);        add(ps, 1922,"Jimmy Murphy",94.484);        add(ps, 1921,"Tommy Milton",89.621);        add(ps, 1920,"Gaston Chevrolet",88.618);        add(ps, 1919,"Howard Wilcox",88.050);        add(ps, 1918,"(no race)",0);        add(ps, 1917,"(no race)",0);        add(ps, 1916,"Dario Resta",84.001);        add(ps, 1915,"Ralph DePalma",89.040);        add(ps, 1914,"Rene Thomas",82.474);        add(ps, 1913,"Jules Goux",75.933);        add(ps, 1912,"Joe Dawson",78.719);        add(ps, 1911,"Ray Harroun",74.602);      }      catch (Exception ex) {        ex.printStackTrace();      }      finally {        // Make sure we always clean up after ourselves        if (con != null) {          try {            ps.close();            con.close();          }          catch (Exception ex) {          }        }      }    }  /**    * <p>Helper method for adding data to the table    */  private void add(java.sql.PreparedStatement ps,                   int year, String name, double avg)    throws Exception    {      ps.setInt(1, year);      ps.setString(2, name);      ps.setDouble(3, avg);      ps.execute();     }  /**    * <p>Trace the given string    */  private void trace(String s)    {      System.out.println("BuildIndy: " + s);    }}