import java.io.*;
import java.sql.*;

public class Hotel {
  public static void main(String[] args) {
    try {
      Connection con=null;
      Class.forName("oracle.jdbc.driver.OracleDriver");
      con=DriverManager.getConnection(
        "jdbc:oracle:thin:@xisbobcat.stfx.ca:1521:CSCI275",  // connection
        "username",                                          // username
        "password");                                         // password
      Statement s=con.createStatement();
      
      // INSERT data
      
      s.execute("INSERT INTO Guest VALUES (30303, 'Billy Shakespeare', 'Stratford on Avon')");

      // SELECT & display data

      System.out.println("Guests:\n");
      
      ResultSet rows=s.executeQuery("SELECT * FROM Guest");
      try {
        while (rows.next()) {
          System.out.println(rows.getString(1)+" "+rows.getString(2)+" "+rows.getString(3));
        }
      } catch (SQLException sqle) {
        System.err.println("Exception occurred while processing Guest ResultSet."); 
      }

      // UPDATE data
      
      s.executeUpdate("UPDATE Guest SET Name='William Shakespeare' WHERE GID = 30303");

      // SELECT & display data

      System.out.println("\n\nGuest 30303 after update:\n");

      rows=s.executeQuery("SELECT * FROM Guest WHERE GID = 30303");
      try {
        while (rows.next()) {
          System.out.println(rows.getString(1)+" "+rows.getString(2)+" "+rows.getString(3));
        }
      } catch (SQLException sqle) {
        System.err.println("Exception occurred while processing Building ResultSet."); 
      }

      // DELETE data
      
      s.execute("DELETE FROM Guest WHERE GID = 30303");
      
      // Now for the hotels

      System.out.println("\n\nHotels in the system:\n");

      rows=s.executeQuery("SELECT * FROM Hotel");
      try {
        while (rows.next()) {
          System.out.println(rows.getInt(1)+" "+
                             rows.getString(2)+" "+
                             rows.getString(3)+" "+
                             rows.getString(4)+" "+
                             rows.getLong(5) );
        }
      } catch (SQLException sqle) {
        System.err.println("Exception occurred while processing Hotel ResultSet."); 
      }

      s.close();
      con.close();
   } catch(Exception e){e.printStackTrace();}
   
   System.out.println("\nThat's all folks!");
 }
}