All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class JBMSTours.inserters.InsertAvailability

java.lang.Object
   |
   +----JBMSTours.inserters.InsertAvailability

public class InsertAvailability
extends Object
implements Inserters
Inserts some random date-specific data into the HotelAvailability and Flight Availability tables. Called by CreateToursDB.


Constructor Index

 o InsertAvailability(int, boolean)

Method Index

 o confirmInsert(Connection)
 o createSQLScript(Connection)
 o extractDataForReInsert(Connection)
 o insert(Connection)
Inserts data into the FlightAvailability and HotelAvailability tables.
 o makeFlightAvailabilityEntry(String, int, Date, int, int, int)
 o makeHotelAvailabilityEntry(int, Date, int)
 o prepareStatements(Connection)

Constructors

 o InsertAvailability
 public InsertAvailability(int rowlimit,
                           boolean nonreplication)

Methods

 o insert
 public boolean insert(Connection conn) throws SQLException
Inserts data into the FlightAvailability and HotelAvailability tables.

Parameters:
conn - the name of the connection
Throws: SQLException
Thrown if there is a SQL error.
 o prepareStatements
 public boolean prepareStatements(Connection conn) throws SQLException
 o makeFlightAvailabilityEntry
 public int makeFlightAvailabilityEntry(String a,
                                        int b,
                                        Date c,
                                        int d,
                                        int e,
                                        int f) throws SQLException
 o makeHotelAvailabilityEntry
 public int makeHotelAvailabilityEntry(int a,
                                       Date b,
                                       int c) throws SQLException
 o confirmInsert
 public void confirmInsert(Connection conn) throws SQLException
 o extractDataForReInsert
 public void extractDataForReInsert(Connection conn) throws SQLException
 o createSQLScript
 public boolean createSQLScript(Connection conn) throws SQLException

All Packages  Class Hierarchy  This Package  Previous  Next  Index