| java.lang.Object org.ofbiz.entity.jdbc.SQLProcessor
SQLProcessor | public class SQLProcessor (Code) | | SQLProcessor - provides utitlity functions to ease database access
|
Method Summary | |
public void | close() | public void | commit() | public void | execQuery(String sql, ExecQueryCallbackFunctionIF aListener) Execute a query based on the SQL string given. | public ResultSet | executeQuery() | public ResultSet | executeQuery(String sql) | public int | executeUpdate() | public int | executeUpdate(String sql) | protected void | finalize() | public Connection | getConnection() | public PreparedStatement | getPreparedStatement() | public ResultSet | getResultSet() | ResultSetMetaData | getResultSetMetaData() | public boolean | next() | public void | prepareStatement(String sql) Prepare a statement. | public void | prepareStatement(String sql, boolean specifyTypeAndConcur, int resultSetType, int resultSetConcurrency) Prepare a statement. | public void | prepareStatement(String sql, boolean specifyTypeAndConcur, int resultSetType, int resultSetConcurrency, int fetchSize, int maxRows) Prepare a statement. | public void | rollback() | public void | setBinaryStream(Object field) Set the next binding variable of the currently active prepared statement
to write the serialized data of 'field' to a BLOB. | protected void | setFetchSize(Statement stmt, int fetchSize) | public void | setValue(String field) Set the next binding variable of the currently active prepared statement. | public void | setValue(java.sql.Timestamp field) Set the next binding variable of the currently active prepared statement. | public void | setValue(java.sql.Time field) Set the next binding variable of the currently active prepared statement. | public void | setValue(java.sql.Date field) Set the next binding variable of the currently active prepared statement. | public void | setValue(Integer field) Set the next binding variable of the currently active prepared statement. | public void | setValue(Long field) Set the next binding variable of the currently active prepared statement. | public void | setValue(Float field) Set the next binding variable of the currently active prepared statement. | public void | setValue(Double field) Set the next binding variable of the currently active prepared statement. | public void | setValue(BigDecimal field) Set the next binding variable of the currently active prepared statement. | public void | setValue(Boolean field) Set the next binding variable of the currently active prepared statement. | public void | setValue(Object field) Set the next binding variable of the currently active prepared statement. | public void | setValue(Blob field) | public void | setValue(Clob field) | protected void | testConnection(Connection con) |
CONNECTION_TEST_LIST | public static List CONNECTION_TEST_LIST(Code) | | Used for testing connections when test is enabled
|
ENABLE_TEST | public static boolean ENABLE_TEST(Code) | | |
MAX_CONNECTIONS | public static int MAX_CONNECTIONS(Code) | | |
module | final public static String module(Code) | | Module Name Used for debugging
|
SQLProcessor | public SQLProcessor(String helperName)(Code) | | Construct an object based on the helper/datasource
Parameters: helperName - The datasource helper (see entityengine.xml <datasource name="..">) |
SQLProcessor | public SQLProcessor(String helperName, Connection connection)(Code) | | Construct an object with an connection given. The connection will not
be closed by this SQLProcessor, but may be by some other.
Parameters: helperName - The datasource helper (see entityengine.xml <datasource name="..">) Parameters: connection - The connection to be used |
getPreparedStatement | public PreparedStatement getPreparedStatement()(Code) | | Getter: get the prepared statement
PreparedStatement |
getResultSet | public ResultSet getResultSet()(Code) | | Getter: get the currently activ ResultSet
ResultSet |
setBinaryStream | public void setBinaryStream(Object field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement
to write the serialized data of 'field' to a BLOB.
Parameters: field - throws: SQLException - |
setValue | public void setValue(String field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement.
Parameters: field - throws: SQLException - |
setValue | public void setValue(Integer field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement.
Parameters: field - throws: SQLException - |
setValue | public void setValue(Long field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement.
Parameters: field - throws: SQLException - |
setValue | public void setValue(Float field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement.
Parameters: field - throws: SQLException - |
setValue | public void setValue(Double field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement.
Parameters: field - throws: SQLException - |
setValue | public void setValue(Boolean field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement.
Parameters: field - throws: SQLException - |
setValue | public void setValue(Object field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement.
Parameters: field - throws: SQLException - |
setValue | public void setValue(Blob field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement
Parameters: field - throws: SQLException - |
setValue | public void setValue(Clob field) throws SQLException(Code) | | Set the next binding variable of the currently active prepared statement
Parameters: field - throws: SQLException - |
|
|