package hfstk28;

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

public class InsertKoffie {
	private String driver = "oracle.jdbc.driver.OracleDriver";
	private String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	private String login = "student";
	private String passwd = "xios";
	private Statement stmt;
	private Connection conn = null;
	private String[] sql = new String[5];

	public InsertKoffie() {
		sql[0] = "INSERT INTO COFFEE VALUES('Colombian',101,7.99,0,0)";
		sql[1] = "INSERT INTO COFFEE VALUES('French_Roast', 49, 8.99, 0, 0)";
		sql[2] = "INSERT INTO COFFEE VALUES('Espresso',150, 9.99, 0, 0)";
		sql[3] = "INSERT INTO COFFEE VALUES('Colombian_Decaf', 101, 8.99, 0, 0)";
		sql[4] = "INSERT INTO COFFEE VALUES('French_Roast_Decaf', 49, 9.99, 0, 0)";

		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, login, passwd);
			stmt = conn.createStatement();
			for (String element:sql) {
				stmt.executeUpdate(element);
			}
			System.out.println("tabel Coffee is gevuld");

		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			try {
				if (conn !=null) conn.close();
			} catch (SQLException sqle) {
				sqle.printStackTrace();
			}
		}
	}

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		new InsertKoffie();
	}

}