/* Richard A. DeVenezia
 * SUGI 29 - "Greetings from the Edge"
 * www.devenezia.com/papers
 */

public interface GatewayInterface
{
  // returned handle must be used to access all functions

  public int getConnectionHandle (String driverClass, String databaseURL, String username, String password) throws Exception;
  public int getStatementHandle (int cHandle, boolean updatable) throws Exception;

  public void closeConnectionHandle (int handle) throws Exception;
  public void closeStatementHandle (int handle) throws Exception;
  public void closeResultSetHandle (int handle) throws Exception;

  public void executeUpdate (int handle, String sql) throws Exception;
  public int executeQuery (int handle, String sql) throws Exception;
  public boolean nextRow (int handle) throws Exception;
  public double getValue (int handle, int colNum) throws Exception;
  public String getText (int handle, int colNum) throws Exception;
  public void setValue (int handle, int colNum, double value) throws Exception;
  public void setText (int handle, int colNum, String text) throws Exception;
  public void insertRow (int handle) throws Exception;
  public void moveToInsertRow (int handle) throws Exception;
  public String getColumnName (int handle, int colNum) throws Exception;
  public int getColumnType (int handle, int colNum) throws Exception;
  public int getColumnCount (int handle) throws Exception;
  public int getColumnDisplaySize (int handle, int colNum) throws Exception;
}