|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.cementj.base.DbDataAccessObject org.cementj.base.SQLStatementExecutor
public class SQLStatementExecutor
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 |
---|
protected SQLStatementExecutor()
public SQLStatementExecutor(java.sql.Connection conn) throws java.sql.SQLException
java.sql.SQLException
Method Detail |
---|
public int executeUpdate(java.lang.String sqlText) throws java.sql.SQLException
sqlText
-
java.sql.SQLException
public int executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1) throws java.sql.SQLException
sqlText
- hostVariableValue1
-
java.sql.SQLException
public int executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2) throws java.sql.SQLException
sqlText
- hostVariableValue1
- hostVariableValue2
-
java.sql.SQLException
public int executeUpdate(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2, java.lang.Object hostVariableValue3) throws java.sql.SQLException
sqlText
- hostVariableValue1
- hostVariableValue2
- hostVariableValue3
-
java.sql.SQLException
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
sqlText
- hostVariableValue1
- hostVariableValue2
- hostVariableValue3
- hostVariableValue4
-
java.sql.SQLException
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
sqlText
- hostVariableValue1
- hostVariableValue2
- hostVariableValue3
- hostVariableValue4
- hostVariableValue5
-
java.sql.SQLException
public int executeUpdate(java.lang.String sqlText, java.lang.Object[] parms) throws java.sql.SQLException
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:
sqlText
- parms
-
java.sql.SQLException
public java.lang.String[][] executeQueryReturningStrings(java.lang.String sqlText, java.lang.Object[] hostVars) throws java.sql.SQLException
java.sql.SQLException
public java.lang.Object[][] executeQuery(java.lang.String sqlText) throws java.sql.SQLException
sqlText
-
java.sql.SQLException
public java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVariableValue1) throws java.sql.SQLException
sqlText
- hostVariableValue1
-
java.sql.SQLException
public java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object hostVariableValue1, java.lang.Object hostVariableValue2) throws java.sql.SQLException
sqlText
- hostVariableValue1
- hostVariableValue2
-
java.sql.SQLException
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
sqlText
- hostVariableValue1
- hostVariableValue2
- hostVariableValue3
-
java.sql.SQLException
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
sqlText
- hostVariableValue1
- hostVariableValue2
- hostVariableValue3
- hostVariableValue4
-
java.sql.SQLException
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
sqlText
- hostVariableValue1
- hostVariableValue2
- hostVariableValue3
- hostVariableValue4
- hostVariableValue5
-
java.sql.SQLException
public java.lang.Object[][] executeQuery(java.lang.String sqlText, java.lang.Object[] hostVars) throws java.sql.SQLException
sqlText
- hostVars
-
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |