Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.cementj.database
Class SQLAssistant

java.lang.Object
  extended by org.cementj.database.SQLAssistant

public class SQLAssistant
extends java.lang.Object

Class providing SQL statement execution assistance. This is a JDBC code reduction technique.

SQLAssistant can greatly reduce the amount of JDBC-related code you write and maintain. Examples of how to instantiate and use a SQLAssistant follow.

Example instantiation of a SQLAssistant 

       SQLAssistant sql = new SQLAssistant(_dbConnection);

Example of a simple select: 

                Object[][] results = null;
                results = sql.executeQuery("select * from purchase_order");

Example of a select with host variables: 

                Object[][] results = null;
                results = sql.executeQuery(
          "select * from purchase_order where DATE_CREATED < ?", 
          new java.util.Date());

Example of an update with host variables: 

       int nbrRowsAffected = sql.executeUpdate( 
             "update purchase_order set date_shipped = ? where order_nbr = ?",
             new java.util.Date(), new Integer(809));

Copyright: Delta Vortex Technologies, 2003.

Field Summary
static org.cementj.database.SQLAssistant.NullValue NULL
           
 
Constructor Summary
SQLAssistant(java.sql.Connection conn)
           
 
Method Summary
 java.lang.Object[][] executeQuery(java.lang.String sqlText)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.util.List hostVariableList)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7, java.lang.Object hostVar8)
          Executes a query and returns results.
 java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7, java.lang.Object hostVar8, java.lang.Object hostVar9)
          Executes a query and returns results.
 int executeUpdate(java.lang.String sqlText)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.util.List hostVariableList)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7, java.lang.Object hostVar8)
          Executes a SQL statement making host variable substitutions where appropriate.
 int executeUpdate(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7, java.lang.Object hostVar8, java.lang.Object hostVar9)
          Executes a SQL statement making host variable substitutions where appropriate.
 java.sql.Connection getConnection()
           
 java.text.SimpleDateFormat getDefaultDateFormat()
           
 java.text.DecimalFormat getDefaultDecimalFormat()
           
 java.lang.Object[] getNextRow(java.sql.ResultSet results)
          Gets a row from a ResultSet as an array of Java objects.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.util.List hostVariableList)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7, java.lang.Object hostVar8)
          Establishes and returns a ResultSet given a query and host variables.
 java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText, java.lang.Object hostVar1, java.lang.Object hostVar2, java.lang.Object hostVar3, java.lang.Object hostVar4, java.lang.Object hostVar5, java.lang.Object hostVar6, java.lang.Object hostVar7, java.lang.Object hostVar8, java.lang.Object hostVar9)
          Establishes and returns a ResultSet given a query and host variables.
 boolean isConvertStringOn()
           
 boolean isSpaceTrimOn()
           
 void setConnection(java.sql.Connection conn)
           
 void setConvertStringOn(boolean b)
           
 void setDefaultDateFormat(java.text.SimpleDateFormat format)
           
 void setDefaultDecimalFormat(java.text.DecimalFormat format)
           
 void setSpaceTrimOn(boolean b)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

NULL

public static final org.cementj.database.SQLAssistant.NullValue NULL
Constructor Detail

SQLAssistant

public SQLAssistant(java.sql.Connection conn)
Method Detail

executeUpdate

public int executeUpdate(java.lang.String sqlText)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2,
                         java.lang.Object hostVar3)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2,
                         java.lang.Object hostVar3,
                         java.lang.Object hostVar4)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2,
                         java.lang.Object hostVar3,
                         java.lang.Object hostVar4,
                         java.lang.Object hostVar5)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2,
                         java.lang.Object hostVar3,
                         java.lang.Object hostVar4,
                         java.lang.Object hostVar5,
                         java.lang.Object hostVar6)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2,
                         java.lang.Object hostVar3,
                         java.lang.Object hostVar4,
                         java.lang.Object hostVar5,
                         java.lang.Object hostVar6,
                         java.lang.Object hostVar7)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2,
                         java.lang.Object hostVar3,
                         java.lang.Object hostVar4,
                         java.lang.Object hostVar5,
                         java.lang.Object hostVar6,
                         java.lang.Object hostVar7,
                         java.lang.Object hostVar8)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
hostVar8 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVar1,
                         java.lang.Object hostVar2,
                         java.lang.Object hostVar3,
                         java.lang.Object hostVar4,
                         java.lang.Object hostVar5,
                         java.lang.Object hostVar6,
                         java.lang.Object hostVar7,
                         java.lang.Object hostVar8,
                         java.lang.Object hostVar9)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
hostVar8 -
hostVar9 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.util.List hostVariableList)
                  throws java.sql.SQLException
Executes a SQL statement making host variable substitutions where appropriate.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
hostVar8 -
hostVar9 -
Returns:
NbrRows affected by SQL Statement
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2,
                                         java.lang.Object hostVar3)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2,
                                         java.lang.Object hostVar3,
                                         java.lang.Object hostVar4)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2,
                                         java.lang.Object hostVar3,
                                         java.lang.Object hostVar4,
                                         java.lang.Object hostVar5)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2,
                                         java.lang.Object hostVar3,
                                         java.lang.Object hostVar4,
                                         java.lang.Object hostVar5,
                                         java.lang.Object hostVar6)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2,
                                         java.lang.Object hostVar3,
                                         java.lang.Object hostVar4,
                                         java.lang.Object hostVar5,
                                         java.lang.Object hostVar6,
                                         java.lang.Object hostVar7)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2,
                                         java.lang.Object hostVar3,
                                         java.lang.Object hostVar4,
                                         java.lang.Object hostVar5,
                                         java.lang.Object hostVar6,
                                         java.lang.Object hostVar7,
                                         java.lang.Object hostVar8)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
hostVar8 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVar1,
                                         java.lang.Object hostVar2,
                                         java.lang.Object hostVar3,
                                         java.lang.Object hostVar4,
                                         java.lang.Object hostVar5,
                                         java.lang.Object hostVar6,
                                         java.lang.Object hostVar7,
                                         java.lang.Object hostVar8,
                                         java.lang.Object hostVar9)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
hostVar8 -
hostVar9 -
Returns:
QueryResults
Throws:
java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.util.List hostVariableList)
                                  throws java.sql.SQLException
Executes a query and returns results.

Object Types used are determined by the underlying JDBC driver.

Parameters:
sqlText -
hostVariableList -
Returns:
QueryResults
Throws:
java.sql.SQLException

getNextRow

public java.lang.Object[] getNextRow(java.sql.ResultSet results)
                              throws java.sql.SQLException
Gets a row from a ResultSet as an array of Java objects.

Parameters:
results -
Returns:
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2,
                                                       java.lang.Object hostVar3,
                                                       java.lang.Object hostVar4,
                                                       java.lang.Object hostVar5,
                                                       java.lang.Object hostVar6,
                                                       java.lang.Object hostVar7,
                                                       java.lang.Object hostVar8)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
hostVar8 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2,
                                                       java.lang.Object hostVar3,
                                                       java.lang.Object hostVar4,
                                                       java.lang.Object hostVar5,
                                                       java.lang.Object hostVar6,
                                                       java.lang.Object hostVar7)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2,
                                                       java.lang.Object hostVar3,
                                                       java.lang.Object hostVar4,
                                                       java.lang.Object hostVar5,
                                                       java.lang.Object hostVar6)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2,
                                                       java.lang.Object hostVar3,
                                                       java.lang.Object hostVar4,
                                                       java.lang.Object hostVar5)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2,
                                                       java.lang.Object hostVar3,
                                                       java.lang.Object hostVar4)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2,
                                                       java.lang.Object hostVar3)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.lang.Object hostVar1,
                                                       java.lang.Object hostVar2,
                                                       java.lang.Object hostVar3,
                                                       java.lang.Object hostVar4,
                                                       java.lang.Object hostVar5,
                                                       java.lang.Object hostVar6,
                                                       java.lang.Object hostVar7,
                                                       java.lang.Object hostVar8,
                                                       java.lang.Object hostVar9)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVar1 -
hostVar2 -
hostVar3 -
hostVar4 -
hostVar5 -
hostVar6 -
hostVar7 -
hostVar8 -
hostVar9 -
Returns:
ResultSet
Throws:
java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlText,
                                                       java.util.List hostVariableList)
                                                throws java.sql.SQLException
Establishes and returns a ResultSet given a query and host variables.

Parameters:
sqlText -
hostVariableList -
Returns:
PreparedStatement
Throws:
java.sql.SQLException

setConnection

public void setConnection(java.sql.Connection conn)

getConnection

public java.sql.Connection getConnection()

getDefaultDateFormat

public java.text.SimpleDateFormat getDefaultDateFormat()
Returns:

getDefaultDecimalFormat

public java.text.DecimalFormat getDefaultDecimalFormat()
Returns:

setDefaultDateFormat

public void setDefaultDateFormat(java.text.SimpleDateFormat format)
Parameters:
format -

setDefaultDecimalFormat

public void setDefaultDecimalFormat(java.text.DecimalFormat format)
Parameters:
format -

isSpaceTrimOn

public boolean isSpaceTrimOn()
Returns:

setSpaceTrimOn

public void setSpaceTrimOn(boolean b)
Parameters:
b -

isConvertStringOn

public boolean isConvertStringOn()
Returns:

setConvertStringOn

public void setConvertStringOn(boolean b)
Parameters:
b -
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright © 2003 Delta Vortex Technologies, Inc. All Rights Reserved.