Package | Description |
---|---|
org.clazzes.util.sql |
Utility package providing a simple framework to create SQL statements for various dialects.
|
org.clazzes.util.sql.criteria | |
org.clazzes.util.sql.dao |
Modifier and Type | Method and Description |
---|---|
String |
SQLStatementGenerator.select(String tableName,
SQLValue[] columnNames,
SQLCondition condition,
SQLOrder[] orders)
Generates a
SELECT statement for the given SQLDialect as follows:
For columnNames == null :SELECT * FROM tableName [WHERE condition] For columnNames ! |
String |
SQLStatementGenerator.selectDistinct(String tableName,
SQLValue[] columnNames,
SQLCondition condition,
SQLOrder[] orders)
Generates a
SELECT DISTINCT statement for the given SQLDialect as follows:
For columnNames == null :SELECT DISTINCT * FROM tableName [WHERE condition] For columnNames ! |
Modifier and Type | Method and Description |
---|---|
static SQLOrder |
SQLOrder.forFragment(SQLFragment fragment,
SQLOrder.OrderDirection order) |
static SQLOrder |
SQLOrder.forTableColumn(String tableName,
String columnName,
SQLOrder.OrderDirection order) |
Modifier and Type | Method and Description |
---|---|
protected List<T> |
AbstrBasicDAO.getSubList(SQLCondition condition,
StatementPreparer preparer,
SQLOrder[] orders,
int rowsToSkip,
int maxRows)
Returns a list of POJOs, matching the given SQLCondition, prepared with the given StatementPreparer.
|
protected int |
AbstrBasicDAO.streamSubList(IEntityConsumer<T> entityConsumer,
SQLCondition condition,
StatementPreparer preparer,
SQLOrder[] orders,
int rowsToSkip,
int maxRows)
Stream a list of POJOs, matching the given SQLCondition, prepared with the given StatementPreparer.
|
Copyright © 2017 Clazzes.org. All rights reserved.