Australian PC Authority 1999 May/may1999.iso/May/JBUILDER/JSAMPLES.Z/InsertCoffees.class

Java Class File | 1998-04-30 | 2.4 KB | 43 lines

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class InsertCoffees {
   public static void main(String[] var0) {
      String var1 = "jdbc:odbc:CoffeePot";
      String var4 = "select COF_NAME, PRICE from COFFEES";

      try {
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      } catch (ClassNotFoundException var8) {
         System.err.print("ClassNotFoundException: ");
         System.err.println(((Throwable)var8).getMessage());
      }

      try {
         Connection var2 = DriverManager.getConnection(var1, "sa", "");
         Statement var3 = var2.createStatement();
         var3.executeUpdate("insert into COFFEES values('Colombian', 00101, 7.99, 0, 0)");
         var3.executeUpdate("insert into COFFEES values('French_Roast', 00049, 8.99, 0, 0)");
         var3.executeUpdate("insert into COFFEES values('Espresso', 00150, 9.99, 0, 0)");
         var3.executeUpdate("insert into COFFEES values('Colombian_Decaf', 00101, 8.99, 0, 0)");
         var3.executeUpdate("insert into COFFEES values('French_Roast_Decaf', 00049, 9.99, 0, 0)");
         ResultSet var5 = var3.executeQuery(var4);
         System.out.println("Coffee Break Coffees and Prices:");

         while(var5.next()) {
            String var6 = var5.getString("COF_NAME");
            float var7 = var5.getFloat("PRICE");
            System.out.println(var6 + "   " + var7);
         }

         var3.close();
         var2.close();
      } catch (SQLException var9) {
         System.err.println("SQLException: " + ((Throwable)var9).getMessage());
      }
   }
}