package dbconnection;

import java.sql.*;
import oracle.jdbc.driver.*;

public class ConnectionClass {
    {
        try {

            Class.forName("oracle.jdbc.driver.OracleDriver");
            DriverManager.registerDriver(new dbconnection.OracleDriver());

            Connection con = DriverManager.getConnection(
                    "jdbc:oracle:thin:@test.cr1axzdw6xam.us-east-1.rds.amazonaws.com:1521:orcl", "chase", "Offspring1");

            String sql = "SELECT * FROM CATCRAP";
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery(sql);

            // Insert query missing: date
            // String insert = " INSERT INTO CATCRAP(CAT_ID, AGE, WEIGHT, MEAL,
            // POOPS)"
            // +" values(?, ?, ?, ?, ?)";
            // PreparedStatement ps = con.prepareStatement(insert);
            // ps.setInt(1, 3);
            // ps.setInt(2, 2);
            // ps.setDouble(3, 1.5);
            // ps.setString(4, "hotdogs");
            // ps.setInt(5, 90);
            // ps.execute();

            // Update query
            // String update = "UPDATE CATCRAP SET POOPS = ? WHERE AGE = ?";
            // PreparedStatement ps = con.prepareStatement(update);
            // ps.setInt(1,200);
            // ps.setInt(2, 5);
            // ps.executeUpdate();

            // Delete query
            // String delete = "DELETE FROM CATCRAP WHERE CAT_ID = ?";
            // PreparedStatement ps = con.prepareStatement(delete);
            // ps.setInt(1,3);
            // ps.executeQuery();

            // Selecting records
            while (rs.next())
                System.out.println(rs.getInt(1) + " " + rs.getInt(2) + " " + rs.getFloat(3) + " " + rs.getString(4)
                        + " " + rs.getInt(5));
            con.close();
        } catch (SQLException err) {
            System.out.println(err.getMessage());
        }
    }

    public static void insert() {
        String insert = " INSERT INTO CATCRAP(CAT_ID, AGE, WEIGHT, MEAL, POOPS)" + " values(?, ?, ?, ?, ?)";
        PreparedStatement ps = con.prepareStatement(insert);
        ps.setInt(1, 3);
        ps.setInt(2, 2);
        ps.setDouble(3, 1.5);
        ps.setString(4, "hotdogs");
        ps.setInt(5, 90);
        ps.execute();
    }

    public static void main(String[] args) throws ClassNotFoundException {

        try {

            Class.forName("oracle.jdbc.driver.OracleDriver");
            DriverManager.registerDriver(new dbconnection.OracleDriver());

            Connection con = DriverManager.getConnection(
                    "jdbc:oracle:thin:@test.cr1axzdw6xam.us-east-1.rds.amazonaws.com:1521:orcl", "chase", "Offspring1");

            String sql = "SELECT * FROM CATCRAP";
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery(sql);


            // Selecting records
            while (rs.next())
                System.out.println(rs.getInt(1) + " " + rs.getInt(2) + " " + rs.getFloat(3) + " " + rs.getString(4)
                        + " " + rs.getInt(5));
            con.close();

            con.close();
        } catch (SQLException err) {
            System.out.println(err.getMessage());
        }
    }

}