org.cementj.base
Class SQLStatementExecutor

java.lang.Object
  org.cementj.base.DbDataAccessObject
      org.cementj.base.SQLStatementExecutor

public class SQLStatementExecutor
extends DbDataAccessObject

Class providing support for simple SQL statement executions.

Copyright: Delta Vortex Technologies, 2003.

Field Summary

Fields inherited from class org.cementj.base.DbDataAccessObject

_dbConnection, _sqlAssistant

Constructor Summary

protected	SQLStatementExecutor()
	SQLStatementExecutor(java.sql.Connection conn)

Method Summary

java.lang.Object[][]	executeQuery(java.lang.String sqlText) Executes a query and returns the results as an object array.
java.lang.Object[][]	executeQuery(java.lang.String sqlText, java.lang.Object hostVariableValue1) Executes a query and returns the results as an object array.
java.lang.Object[][]	executeQuery(java.lang.String sqlText, java.lang.Object[] hostVars) Executes a query and returns the results as an object array.
java.lang.Object[][]	executeQuery(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2) Executes a query and returns the results as an object array.
java.lang.Object[][]	executeQuery(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2, java.lang.Object hostVariableValue3) Executes a query and returns the results as an object array.
java.lang.Object[][]	executeQuery(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2, java.lang.Object hostVariableValue3, java.lang.Object hostVariableValue4) Executes a query and returns the results as an object array.
java.lang.Object[][]	executeQuery(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2, java.lang.Object hostVariableValue3, java.lang.Object hostVariableValue4, java.lang.Object hostVariableValue5) Executes a query and returns the results as an object array.
java.lang.String[][]	executeQueryReturningStrings(java.lang.String sqlText, java.lang.Object[] hostVars)
int	executeUpdate(java.lang.String sqlText) Executes a SQL statement returning the number of rows affected.
int	executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1) Executes a SQL statement returning the number of rows affected.
int	executeUpdate(java.lang.String sqlText, java.lang.Object[] parms) Executes a SQL statement returning the number of rows affected.
int	executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2) Executes a SQL statement returning the number of rows affected.
int	executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2, java.lang.Object hostVariableValue3) Executes a SQL statement returning the number of rows affected.
int	executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2, java.lang.Object hostVariableValue3, java.lang.Object hostVariableValue4) Executes a SQL statement returning the number of rows affected.
int	executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2, java.lang.Object hostVariableValue3, java.lang.Object hostVariableValue4, java.lang.Object hostVariableValue5) Executes a SQL statement returning the number of rows affected.

Methods inherited from class org.cementj.base.DbDataAccessObject

getDbConnection, setDbConnection

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLStatementExecutor

protected SQLStatementExecutor()

SQLStatementExecutor

public SQLStatementExecutor(java.sql.Connection conn)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

executeUpdate

public int executeUpdate(java.lang.String sqlText)
                  throws java.sql.SQLException

Executes a SQL statement returning the number of rows affected.

Parameters:

sqlText -

Returns:

NbrRowsAffected

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVariableValue1)
                  throws java.sql.SQLException

Executes a SQL statement returning the number of rows affected.

Parameters:

sqlText -

hostVariableValue1 -

Returns:

NbrRowsAffected

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVariableValue1,
                         java.lang.Object hostVariableValue2)
                  throws java.sql.SQLException

Executes a SQL statement returning the number of rows affected.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

Returns:

NbrRowsAffected

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVariableValue1,
                         java.lang.Object hostVariableValue2,
                         java.lang.Object hostVariableValue3)
                  throws java.sql.SQLException

Executes a SQL statement returning the number of rows affected.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

hostVariableValue3 -

Returns:

NbrRowsAffected

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVariableValue1,
                         java.lang.Object hostVariableValue2,
                         java.lang.Object hostVariableValue3,
                         java.lang.Object hostVariableValue4)
                  throws java.sql.SQLException

Executes a SQL statement returning the number of rows affected.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

hostVariableValue3 -

hostVariableValue4 -

Returns:

NbrRowsAffected

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object hostVariableValue1,
                         java.lang.Object hostVariableValue2,
                         java.lang.Object hostVariableValue3,
                         java.lang.Object hostVariableValue4,
                         java.lang.Object hostVariableValue5)
                  throws java.sql.SQLException

Executes a SQL statement returning the number of rows affected.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

hostVariableValue3 -

hostVariableValue4 -

hostVariableValue5 -

Returns:

NbrRowsAffected

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sqlText,
                         java.lang.Object[] parms)
                  throws java.sql.SQLException

Executes a SQL statement returning the number of rows affected.

The parameter array is taken as host variable values. For each occurance on the array, a host variable value will be set. Data types will be treated as follows:

Strings -- will use PreparedStatement.setString()

Integer -- will use PreparedStatement.setInt()

Long -- will use PreparedStatement.setLong()

Double -- will use PreparedStatement.setDouble()

Float -- will use PreparedStatement.setFloat()

Short -- will use PreparedStatement.setShort()

java.sql.Date -- will use PreparedStatement.setDate()

java.util.Date -- will use PreparedStatement.setTimestamp()

Timestamp -- will use PreparedStatement.setTimestamp()

Others -- will use PreparedStatement.setObject()

Parameters:

sqlText -

parms -

Returns:

NbrRowsAffected

Throws:

java.sql.SQLException

executeQueryReturningStrings

public java.lang.String[][] executeQueryReturningStrings(java.lang.String sqlText,
                                                         java.lang.Object[] hostVars)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText)
                                  throws java.sql.SQLException

Executes a query and returns the results as an object array.

Parameters:

sqlText -

Returns:

results

Throws:

java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVariableValue1)
                                  throws java.sql.SQLException

Executes a query and returns the results as an object array.

Parameters:

sqlText -

hostVariableValue1 -

Returns:

results

Throws:

java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVariableValue1,
                                         java.lang.Object hostVariableValue2)
                                  throws java.sql.SQLException

Executes a query and returns the results as an object array.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

Returns:

results

Throws:

java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVariableValue1,
                                         java.lang.Object hostVariableValue2,
                                         java.lang.Object hostVariableValue3)
                                  throws java.sql.SQLException

Executes a query and returns the results as an object array.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

hostVariableValue3 -

Returns:

results

Throws:

java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVariableValue1,
                                         java.lang.Object hostVariableValue2,
                                         java.lang.Object hostVariableValue3,
                                         java.lang.Object hostVariableValue4)
                                  throws java.sql.SQLException

Executes a query and returns the results as an object array.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

hostVariableValue3 -

hostVariableValue4 -

Returns:

results

Throws:

java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object hostVariableValue1,
                                         java.lang.Object hostVariableValue2,
                                         java.lang.Object hostVariableValue3,
                                         java.lang.Object hostVariableValue4,
                                         java.lang.Object hostVariableValue5)
                                  throws java.sql.SQLException

Executes a query and returns the results as an object array.

Parameters:

sqlText -

hostVariableValue1 -

hostVariableValue2 -

hostVariableValue3 -

hostVariableValue4 -

hostVariableValue5 -

Returns:

results

Throws:

java.sql.SQLException

executeQuery

public java.lang.Object[][] executeQuery(java.lang.String sqlText,
                                         java.lang.Object[] hostVars)
                                  throws java.sql.SQLException

Executes a query and returns the results as an object array.

Parameters:

sqlText -

hostVars -

Returns:

results

Throws:

java.sql.SQLException