home *** CD-ROM | disk | FTP | other *** search
/ Australian PC Authority 1999 May / may1999.iso / May / JBUILDER / JSAMPLES.Z / CreateCoffees.class (.txt) < prev    next >
Encoding:
Java Class File  |  1998-04-30  |  1.5 KB  |  29 lines
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.SQLException;
  4. import java.sql.Statement;
  5.  
  6. public class CreateCoffees {
  7.    public static void main(String[] var0) {
  8.       String var1 = "jdbc:odbc:CafeJava";
  9.       String var3 = "create table COFFEES (COF_NAME varchar(32), SUP_ID int, PRICE float, SALES int, TOTAL int)";
  10.  
  11.       try {
  12.          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  13.       } catch (ClassNotFoundException var7) {
  14.          System.err.print("ClassNotFoundException: ");
  15.          System.err.println(((Throwable)var7).getMessage());
  16.       }
  17.  
  18.       try {
  19.          Connection var2 = DriverManager.getConnection(var1, "Admin", "duke1");
  20.          Statement var4 = var2.createStatement();
  21.          var4.executeUpdate(var3);
  22.          var4.close();
  23.          var2.close();
  24.       } catch (SQLException var6) {
  25.          System.err.println("SQLException: " + ((Throwable)var6).getMessage());
  26.       }
  27.    }
  28. }
  29.