Package | Description |
---|---|
org.josef.jdbc |
jdbc related classes.
|
Modifier and Type | Class and Description |
---|---|
class |
CodeDescriptionCallBack
Call back class for (@link CodeDescription} objects.
|
Modifier and Type | Method and Description |
---|---|
static <T> List<T> |
Database.executeQuery(Connection connection,
Integer maximumNumberOfRows,
ResultSetRowCallBackInterface<T> resultSetRowCallBack,
String sqlStatement,
Object... parameters)
Executes a SELECT statement.
|
static <T> List<T> |
Database.executeQuery(DataSource dataSource,
Integer maximumNumberOfRows,
ResultSetRowCallBackInterface<T> resultSetRowCallBack,
String sqlStatement,
Object... parameters)
Executes a SELECT statement.
|
static <T> long |
Database.executeQueryWithLargeResultSet(Connection connection,
ResultSetRowCallBackInterface<T> resultSetRowCallBack,
String sqlStatement,
Object... parameters)
Executes a SELECT statement that could possible result in a large result set.
|
static <T> long |
Database.executeQueryWithLargeResultSet(DataSource dataSource,
ResultSetRowCallBackInterface<T> resultSetRowCallBack,
String sqlStatement,
Object... parameters)
Executes a SELECT statement that could possible result in a large result set.
|
static <T> T |
Database.executeSingleRowResultQuery(Connection connection,
ResultSetRowCallBackInterface<T> resultSetRowCallBack,
String sqlStatement,
Object... parameters)
Executes a SELECT statement that returns a single row.
|
static <T> T |
Database.executeSingleRowResultQuery(DataSource dataSource,
ResultSetRowCallBackInterface<T> resultSetRowCallBack,
String sqlStatement,
Object... parameters)
Executes a SELECT statement that returns a single row.
|
static <T> List<T> |
JdbcUtil.getEntitiesByColumnCriteria(DataSource dataSource,
String tableNames,
String matchingColumnName,
String columnNames,
String orderByColumnNames,
Boolean descending,
ResultSetRowCallBackInterface<T> callBackInterface,
Integer maxEntities,
List<?> criteria)
Retrieves entities from a database table with the supplied name, based on a supplied collection of criteria that are to
match a supplied column of the table using an SQL in clause.
In short this method allows you to execute statements like: SELECT COL1,COL2,COL3 FROM TABLE1,TABLE2 WHERE COL4 IN (1,2,3); Normally you only want to use this method when the number of criteria (the 1,2,3 in the example above) is very large and can't be selected with an IN (SELECT ...). |
Copyright © 2008–2018. All rights reserved.