import java.sql.*;

public class CoffeeInsert {
  public static void main( String[] args ){
    String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
    Connection con;
    Statement stmt;
    
    try {
      // 1.JDBC 드라이버 로딩
      Class.forName( "oracle.jdbc.driver.OracleDriver" );
    } catch( java.lang.ClassNotFoundException e ) {
      System.err.print( "ClassNotFoundException: " );
      System.err.println( e.getMessage() );
    }
    
    try {	    	
      // 2. Connection 맺기
      con = DriverManager.getConnection( url, "scott", "tiger" );
      stmt = con.createStatement();
      
      // 3. SQL 실행
      stmt.executeUpdate( "INSERT INTO COFFEES " + 
        "VALUES ('Colombian', 101, 7.99, 0, 0) ");

      stmt.executeUpdate( "INSERT INTO COFFEES " + 
        "VALUES ('French_Roast', 49, 8.99, 0, 0) ");
        
      stmt.executeUpdate( "INSERT INTO COFFEES " +
        "VALUES ('Espresso', 150, 9.99, 0, 0) ");
        
      stmt.executeUpdate( "INSERT INTO COFFEES " +
        "VALUES ('Colombian_Decaf', 101, 8.99, 0, 0) ");
        
      stmt.executeUpdate( "INSERT INTO COFFEES " +
        "VALUES ('French_Roast_Decaf', 49, 9.99, 0, 0) ");
      // 5. 자원 반납
      stmt.close();
      con.close();
    } catch ( SQLException ex ) {
      System.out.println( "SQLException : " + ex.getMessage() );
    }   
  } 
}