import java.sql.*;
     
public class CreateCoffees {

  public static void main(String args[]) {
      
    String url      = "jdbc:oracle:thin:@bigoh.cis.uab.edu:1521:ORA8INT1";
    String driver   = "oracle.jdbc.driver.OracleDriver";  

    Connection con;
    String createString;
    createString = "create table COFFEES " +
              "(COF_NAME varchar(32), " +
              "SUP_ID int, " +
              "PRICE float, " +
              "SALES int, " +
              "TOTAL int)";
    Statement stmt;
  
    try {
      Class.forName(driver);
    } catch(java.lang.ClassNotFoundException e) {
      System.err.print("ClassNotFoundException: "); 
      System.err.println(e.getMessage());
    }

    try {

      con = DriverManager.getConnection(url, LoginName . login, LoginName . password);
  
      stmt = con.createStatement();              
      stmt.executeUpdate(createString);
  
      stmt.close();
      con.close();
  
    } catch(SQLException ex) {
      System.err.println("SQLException: " + ex.getMessage());
    }
  }
}