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());
		}
	}

}