All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class JBMSTours.inserters.InsertHotels

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

public class InsertHotels
extends Object
implements Inserters
Look at the Source.

This class inserts the hotels (the Hotels table).


Constructor Index

 o InsertHotels()

Method Index

 o confirmInsert(Connection)
 o createSQLScript(Connection)
 o extractDataForReInsert(Connection)
A home-made method for exporting data.
 o fullHotelEntry(int, String, int, int, String, String, int)
 o fullHotelEntry(int, String, int, int, String, String, int, int, int)
Enters a single hotel into the database.
 o insert(Connection)
Inserts a large amount of flight data.
 o prepareStatements(Connection)

Constructors

 o InsertHotels
 public InsertHotels()

Methods

 o insert
 public boolean insert(Connection conn) throws SQLException
Inserts a large amount of flight data.

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 fullHotelEntry
 protected int fullHotelEntry(int id,
                              String name,
                              int cid,
                              int level,
                              String normalrate,
                              String highseasonrate,
                              int rooms,
                              int highseasonbegin,
                              int highseasonend) throws SQLException
Enters a single hotel into the database.

Throws: SQLException
Thrown if there is a SQL error.
 o fullHotelEntry
 protected int fullHotelEntry(int id,
                              String name,
                              int cid,
                              int level,
                              String normalrate,
                              String highseasonrate,
                              int rooms) throws SQLException
 o confirmInsert
 public void confirmInsert(Connection conn) throws SQLException
 o extractDataForReInsert
 public void extractDataForReInsert(Connection conn) throws SQLException
A home-made method for exporting data.

Parameters:
conn - the connection to the database
Throws: SQLException
Thrown if there is a SQL error.
 o createSQLScript
 public boolean createSQLScript(Connection conn) throws SQLException

All Packages  Class Hierarchy  This Package  Previous  Next  Index