/**
 *  This sample exhibits the insertion, updation, deletion of a row in the
 *  rowset and also displays the call for Synchronizing the database with the
 *  rowset.
 *
 *  Please use jdk1.2 or later version
 *
 *  useage: need to run a script "rowset.sql" to create a
 *          reservation table.
 *
 *  @author Ashok.Shivarudraiah
 */
import java.sql.SQLException;
import java.sql.Date;
import javax.sql.RowSet;
import oracle.jdbc.rowset.OracleCachedRowSet;

public class RowSet02 {
  public static void main (String []args)
  {
    String url = "java:oracle:oci8:@";
    try
    {
      OracleCachedRowSet crowset = new OracleCachedRowSet ();
      try
      {
        String url1 = System.getProperty ("JDBC_URL");
        if (url1 != null)
          url = url1;
      }catch (Exception ea) { }
      crowset.setUrl (url);
      crowset.setUsername ("hr");
      crowset.setPassword ("hr");
      crowset.setCommand ("SELECT seatno, tdate, name, class FROM reservation");
      crowset.execute ();

      System.out.println ("Displaying all the rows before modification");
      System.out.println ("Seat no  Travel Date  Name   Class");
      System.out.println ("-------  ------ ----  ----   -----");
      while (crowset.next ())
      {
        printRow (crowset);
      }// end of while (crowset.next ())

      System.out.println ("Write enabling the rowset");
      crowset.setReadOnly (false);

      System.out.println ("");
      crowset.beforeFirst ();
      {
        System.out.println ("Inserting a new passenger with seat no 107");
        crowset.moveToInsertRow ();
        crowset.updateInt (1, 107);
        crowset.updateDate (2, new Date (975915381774L));
        crowset.updateString (3, "Pluto");
        crowset.updateString (4, "Business");
        crowset.insertRow ();
        System.out.println ("New row inserted");
      }

      System.out.println ("");
      crowset.beforeFirst ();
      if (crowset.absolute (2))
      {
        System.out.println ("Updating passenger's class at 102 from Economy to" 
          +" Business");
        crowset.updateString (4, "Business");
        crowset.updateRow ();
        System.out.println ("Row updated");
      }

      System.out.println ("");
      crowset.beforeFirst ();
      if (crowset.absolute (6))
      {
        System.out.println ("Deleting the passenger's entry at seatno: " 
          +crowset.getInt (1));
        crowset.deleteRow ();
        System.out.println ("Row deleted");
      }

      System.out.println ("");
      System.out.println ("Displaying all the rows after modification");
      System.out.println ("Seat no  Travel Date  Name   Class");
      System.out.println ("-------  ------ ----  ----   -----");
      crowset.beforeFirst ();
      while (crowset.next ())
      {
        printRow (crowset);
      }// end of while (crowset.next ())

      System.out.println ("");
      System.out.println ("Synchronizing the rowset with the database");
      crowset.acceptChanges ();
      crowset.close ();

      System.out.println ("Closing the old rowset and re-creating the rowset");
      crowset = new OracleCachedRowSet ();
      crowset.setUrl ("java:oracle:oci8:@");
      crowset.setUsername ("hr");
      crowset.setPassword ("hr");
      crowset.setCommand ("SELECT seatno, tdate, name, class FROM reservation");
      crowset.execute ();

      System.out.println ("Displaying all the rows from the re-read rowset");
      System.out.println ("Seat no  Travel Date  Name   Class");
      System.out.println ("-------  ------ ----  ----   -----");
      while (crowset.next ())
      {
        printRow (crowset);
      }// end of while (crowset.next ())

      crowset.close ();
    }catch (SQLException ea)
    {
      ea.printStackTrace ();
    }
  }// end of main (String[])

  public static void printRow (RowSet rowset)
    throws SQLException
  {
    System.out.println (rowset.getInt (1) +"      " +rowset.getDate (2)
      +"   " +rowset.getString (3) +"  " +rowset.getString (4));
  }// end of printRow (RowSet)

}// end of class RowSet02