All Packages  Class Hierarchy  This Package  Previous  Next  Index

Interface JBMSTours.inserters.Inserters

public interface Inserters
An interface for the various classes that insert data into the database.


Method Index

 o confirmInsert(Connection)
Confirms the insert by doing a System.out of the data.
 o createSQLScript(Connection)
If possible, does a System.out to create a script file that can be run as an SQL script from ij or Cloudview.
 o extractDataForReInsert(Connection)
Extracts current data in the table to generate a file to re-produce what happens in the insert method.
 o insert(Connection)
Should insert the data and return the number of rows inserted.
 o prepareStatements(Connection)
Prepares the statements used in the inserts.

Methods

 o insert
 public abstract boolean insert(Connection conn) throws Exception
Should insert the data and return the number of rows inserted.

Parameters:
conn - Connection to the database.
Returns:
boolean if insert was successful.
Throws: Exception
a error occurred.
 o prepareStatements
 public abstract boolean prepareStatements(Connection conn) throws SQLException
Prepares the statements used in the inserts.

Parameters:
Conn - Connection to the database.
Returns:
boolean if statement preparation was successful.
Throws: SQLException
an error occurred.
 o confirmInsert
 public abstract void confirmInsert(Connection conn) throws SQLException
Confirms the insert by doing a System.out of the data.

Parameters:
conn - Connection to the database.
Throws: SQLException
if an error occurred.
 o extractDataForReInsert
 public abstract void extractDataForReInsert(Connection conn) throws SQLException
Extracts current data in the table to generate a file to re-produce what happens in the insert method.

Parameters:
conn - Connection to the database.
Throws: SQLException
if an error occurred.
 o createSQLScript
 public abstract boolean createSQLScript(Connection conn) throws SQLException
If possible, does a System.out to create a script file that can be run as an SQL script from ij or Cloudview. Returns a false if this isn't possible because of complexity of object.

Parameters:
conn - Connection to the database.
Returns:
boolean if script generation possiblel.
Throws: SQLException
if an SQL error occurred.

All Packages  Class Hierarchy  This Package  Previous  Next  Index