/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package feedingzoo;

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

/**
 *
 * @author Amrit
 */
public class Database1 {
    public static void dbConnection() throws ClassNotFoundException, SQLException {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        System.out.println("Successful!");

        Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "system", "elephant");
        System.out.println("2....connection established");

        Statement stmt = conn.createStatement();

        String createTableSQLs = "Drop table FeedingData";
        stmt.executeUpdate(createTableSQLs);

        String createTableSQL = "CREATE TABLE FeedingData(animalName VARCHAR2(30), amountFed number)";
        stmt.executeUpdate(createTableSQL);

        PreparedStatement preparedUpdateStmt = conn.prepareStatement("INSERT INTO FeedingData(animalName, amountFed) VALUES (?, ?)");

        preparedUpdateStmt.setString(1, "Rhino");
        preparedUpdateStmt.setInt(2, 2);
        preparedUpdateStmt.executeUpdate();

        preparedUpdateStmt.setString(1, "Cow");
        preparedUpdateStmt.setInt(2, 2);
        preparedUpdateStmt.executeUpdate();

        preparedUpdateStmt.setString(1, "Horse");
        preparedUpdateStmt.setInt(2, 2);
        preparedUpdateStmt.executeUpdate();

        preparedUpdateStmt.setString(1, "Zebra");
        preparedUpdateStmt.setInt(2, 2);
        preparedUpdateStmt.executeUpdate();

        preparedUpdateStmt.setString(1, "Deer");
        preparedUpdateStmt.setInt(2, 2);
        preparedUpdateStmt.executeUpdate();




        System.out.println("AnimalName    AmountFed");
        ResultSet rs = stmt.executeQuery("SELECT * FROM FeedingData");
        while (rs.next()) {
            String animalName = rs.getString("animalName");
            int amountFed = rs.getInt("amountFed");
            System.out.println(animalName + "   " + amountFed);
        }
    // TODO code application logic here
    }
}