Package | Description |
---|---|
com.streamscape.sdo.sql | |
com.streamscape.sdo.sql.dialect | |
com.streamscape.sdo.sql.syntax | |
com.streamscape.sdo.sql.validation |
Modifier and Type | Method and Description |
---|---|
static SQLQueryBatch |
SQLQueryFactory.createBatch(java.lang.String sqlScript)
Constructs SQL query batch object by parsing a given script which holds a set of
parameterized SQL queries as a batch.
|
static CallableStatement |
SQLQueryFactory.createCallableStatement(Connection connection,
SQLQuery object)
Creates callable statement based on given connection and sql query object.
|
static SQLColumnSet |
SQLQueryFactory.createColumnSet(ResultSet resultSet)
Creates
SQLColumnSet from provided ResultSet . |
static SQLColumnSet |
SQLQueryFactory.createColumnSet(RowSet rowSet)
Creates
SQLColumnSet from provided RowSet . |
static SQLQuery |
SQLQueryFactory.createForCall(Connection connection,
java.lang.String procedure)
Generates SQL script with parameters which then can be used to create query object and
call given stored procedure.
|
static SQLQuery |
SQLQueryFactory.createForDelete(Connection connection,
java.lang.String table)
Generates an SQLQuery DELETE script for specified
table table. |
static SQLQuery |
SQLQueryFactory.createForDelete(Connection connection,
java.lang.String table,
java.lang.String[] whereColumns)
Generates an SQLQuery DELETE script for specified
table table. |
static SQLQuery |
SQLQueryFactory.createForDynamicSQL(Connection connection,
java.lang.String query)
Returns SQLQuery object based on provided
query SQL prepared query. |
static SQLQuery |
SQLDynamicQueryParser.createForDynamicSQL(Connection connection,
java.lang.String query) |
static SQLQuery |
SQLQueryFactory.createForInsert(Connection connection,
java.lang.String table)
Generates SQL script with parameters which then can be used to create an SQL query object and
perform inserts into a given table.
|
static SQLQuery |
SQLQueryFactory.createForSelect(Connection connection,
java.lang.String table)
Generates an SQLQuery SELECT script that selects all columns from given table.
|
static SQLQuery |
SQLQueryFactory.createForSelect(Connection connection,
java.lang.String table,
java.lang.String[] selectColumns)
Generates an SQLQuery SELECT script that selects
selectColumns columns from given table. |
static SQLQuery |
SQLQueryFactory.createForSelect(Connection connection,
java.lang.String table,
java.lang.String[] selectColumns,
java.lang.String[] whereColumns)
Generates an SQLQuery SELECT script that selects
selectColumns columns from given table. |
static SQLQuery |
SQLQueryFactory.createForUpdate(Connection connection,
java.lang.String table)
Generates an SQLQuery UPDTAE script with parameters which then can be used to create an SQL query object and
perform an update on given table.
|
static SQLQuery |
SQLQueryFactory.createForUpdate(Connection connection,
java.lang.String table,
java.lang.String[] updateColumns)
Generates an SQLQuery UPDTAE script for specified
updateColumns columns. |
static SQLQuery |
SQLQueryFactory.createForUpdate(Connection connection,
java.lang.String table,
java.lang.String[] updateColumns,
java.lang.String[] whereColumns)
Generates an SQLQuery UPDATE script for specified
updateColumns columns. |
static SQLQuery |
SQLQueryFactory.createForUpdate(java.lang.String table,
SQLColumnSet columnSet)
Generates an SQLQuery UPDTAE script for specified
columnSet columns. |
static PreparedStatement |
SQLQueryFactory.createPreparedStatement(Connection connection,
SQLQuery object)
Creates prepared statement based on given connection and sql query object.
|
static SQLQuery |
SQLQueryFactory.createQuery(java.lang.String sqlScript)
Constructs SQL query object by parsing given script which holds a parameterized SQL query
|
static int |
SQLQueryFactory.execute(SQLQueryBatch batch,
int queryTimeout,
Connection connection)
Execute the batch query contained in the SQL script object.
|
static java.util.List |
SQLQueryFactory.execute(SQLQuery query,
int queryTimeout,
Connection connection)
Execute the query contained in the SQL script object.
|
SQLQueryParameter |
SQLQueryParameterList.get(int ordinal) |
SQLQueryParameter |
SQLQueryParameterList.get(java.lang.String name) |
SQLQueryParameter |
SQLQuery.getParameter(int ordinal)
Return a parameter by it's ordinal value.
|
SQLQueryParameter |
SQLQuery.getParameter(java.lang.String name)
Return parameter by name.
|
static java.util.List |
DatabaseDescriptor.getQueryColumns(java.lang.String query,
Connection connection,
java.util.List params) |
static java.util.List |
DatabaseDescriptor.getTableColumns(SQLTableName tableName,
Connection connection,
java.lang.String[] columnNames,
int ordinal) |
SQLQuery |
SQLQueryMapper.map(QueryParameterMappingTable table) |
SQLQuery |
SQLQueryMapper.map(QueryParameterMappingTable table,
DataEvent event) |
java.util.List |
SQLQueryMapper.map(RowSet set)
Maps given row set to a list of query objects in accordance with query object.
|
static java.lang.String |
SQLQueryFactory.renderBatch(SQLQueryBatch batch)
Renders the SQL Batch object as a dynamic SQL script (text).
|
static java.lang.String |
SQLQueryFactory.renderQuery(SQLQuery object)
Generates SQL query string with resolved parameters that is ready to be executed.
|
void |
SQLQueryParameterList.set(int ordinal,
java.lang.Object value)
Sets value to the parameter by its ordinal
|
void |
SQLQueryParameterList.set(int ordinal,
java.lang.String value)
Sets value to the parameter by its ordinal
|
void |
SQLQueryParameterList.set(java.lang.String name,
java.lang.Object value)
Sets value to the parameter by its name
|
void |
SQLQueryParameterList.set(java.lang.String name,
java.lang.String value) |
void |
SQLQueryParameter.setDefaultValue(java.lang.String defaultValue) |
void |
SQLQuery.setParameter(int ordinal,
java.lang.String value)
Sets value to the parameter by its ordinal and accepts a string.
|
void |
SQLQuery.setParameter(java.lang.String name,
java.lang.Object value)
Sets value to the parameter by its name and accepts an object.
|
void |
SQLQuery.setParameter(java.lang.String name,
java.lang.String value)
Sets the value of a parameter by it's name passing in a string.
|
static java.lang.String |
SQLQueryFactory.toSQL(SQLQuery object)
Generates SQL query statement used by Prepared or Callable statements where all parameters
are substituted by place-holders >.
|
Constructor and Description |
---|
SQLQueryParameter(java.lang.String name,
int type,
java.lang.String typeName,
boolean nullable,
java.lang.String defaultValue,
java.lang.String value,
int length,
int precision,
int scale,
boolean searchable,
boolean returnCode,
int ordinal,
int mode)
Construts sql query parameter by passing all necessary information
|
Modifier and Type | Method and Description |
---|---|
java.util.List |
OracleDatabaseDialect.onParameterMetaData(ParameterMetaData meta) |
java.util.List |
IDatabaseDialect.onParameterMetaData(ParameterMetaData meta)
An implementation should analyze given parameter meta data in subject
of in, out and inout parameters passed to statements or stored procedures.
|
java.util.List |
DefaultDatabaseDialect.onParameterMetaData(ParameterMetaData meta) |
void |
OracleDatabaseDialect.setArrayParameter(SQLQueryParameter parameter,
java.lang.Object value,
PreparedStatement statement) |
void |
IDatabaseDialect.setArrayParameter(SQLQueryParameter parameter,
java.lang.Object value,
PreparedStatement statement)
An implementation should set array parameter
parameter to preared statement statement . |
void |
DefaultDatabaseDialect.setArrayParameter(SQLQueryParameter parameter,
java.lang.Object value,
PreparedStatement statement) |
Modifier and Type | Method and Description |
---|---|
SQLQuery |
ISQLQuerySyntax.parse(java.util.List sqlBricks,
java.lang.Object inObject)
An implementation should parse sql script which is given by
inObject parameter either as string or as sql query object
and, if sql script is given as string, create new sql query object. |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
IParameterValidator.convertValue(SQLQueryParameter parameter,
java.lang.Object value)
Converts given as object value to string which will be compatible to be a value for
given parameter
|
java.lang.String |
ArrayValidator.convertValue(SQLQueryParameter parameter,
java.lang.Object value) |
java.lang.String |
ABinaryValidator.convertValue(SQLQueryParameter parameter,
java.lang.Object value)
Converts given as object value to string which will be compatible to be a value for
given parameter
|
void |
IParameterValidator.prepareValue(SQLQueryParameter parameter,
PreparedStatement statement)
Fills up the given prepared statement with parameter
value based on parameter type and ordinal
|
void |
ArrayValidator.prepareValue(SQLQueryParameter parameter,
PreparedStatement statement) |
java.lang.String |
IParameterValidator.renderValue(SQLQueryParameter parameter)
Renders parameter value
|
void |
IParameterValidator.validateDefaultValue(SQLQueryParameter parameter,
java.lang.String defValue)
Validates given value as parameter default value which should conform to parameter type.
|
void |
ArrayValidator.validateDefaultValue(SQLQueryParameter parameter,
java.lang.String defValue) |
void |
ABinaryValidator.validateDefaultValue(SQLQueryParameter parameter,
java.lang.String defValue)
Validates given value as parameter default value which should conform to parameter type.
|
int[] |
IParameterValidator.validateTypeSettings(java.lang.String parameterName,
java.util.List settings)
Validates parameter's type extensions (generally length, precision and scale).
|
void |
IParameterValidator.validateValue(SQLQueryParameter parameter,
java.lang.String value)
Validates given value as parameter value which should conform to parameter type.
|
void |
ArrayValidator.validateValue(SQLQueryParameter parameter,
java.lang.String value) |
void |
ABinaryValidator.validateValue(SQLQueryParameter parameter,
java.lang.String value)
Validates given value as parameter value which should conform to parameter type.
|
Copyright © 2015-2024 StreamScape Technologies. All rights reserved.