|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use Query | |
|---|---|
| org.ujorm.core | |
| org.ujorm.orm | The ORM support. |
| org.ujorm.orm.dialect | |
| org.ujorm.orm.utility | |
| Uses of Query in org.ujorm.core |
|---|
| Methods in org.ujorm.core with parameters of type Query | ||
|---|---|---|
static
|
UjoIterator.getInstance(Query<T> query)
|
|
| Uses of Query in org.ujorm.orm |
|---|
| Methods in org.ujorm.orm that return Query | ||
|---|---|---|
Query<UJO> |
Query.addColumn(org.ujorm.UjoProperty<UJO,?> column)
Set the one column to reading from database table. |
|
Query<UJO> |
Query.addOrderBy(org.ujorm.UjoProperty<UJO,?> property)
Add an item to the end of order list. |
|
|
Session.createQuery(java.lang.Class<UJO> aClass)
Create query for all rows. |
|
|
Session.createQuery(java.lang.Class<UJO> aClass,
org.ujorm.criterion.Criterion<UJO> criterion)
Create query. |
|
|
Session.createQuery(org.ujorm.criterion.Criterion<UJO> criterion)
The table class is derived from the first criterion column. |
|
Query<UJO> |
Query.orderBy(java.util.Collection<org.ujorm.UjoProperty> orderItems)
Set an order of the rows by a SQL ORDER BY phrase. |
|
Query<UJO> |
Query.orderBy(org.ujorm.UjoProperty<UJO,?> orderItem)
Set an order of the rows by a SQL ORDER BY phrase. |
|
Query<UJO> |
Query.orderBy(org.ujorm.UjoProperty<UJO,?> orderItem1,
org.ujorm.UjoProperty<UJO,?> orderItem2)
Set an order of the rows by a SQL ORDER BY phrase. |
|
Query<UJO> |
Query.orderBy(org.ujorm.UjoProperty<UJO,?> orderItem1,
org.ujorm.UjoProperty<UJO,?> orderItem2,
org.ujorm.UjoProperty<UJO,?> orderItem3)
Set an order of the rows by a SQL ORDER BY phrase. |
|
Query<UJO> |
Query.orderByMany(org.ujorm.UjoProperty... orderItems)
Set an order of the rows by a SQL ORDER BY phrase. |
|
Query<UJO> |
Query.setColumn(org.ujorm.UjoProperty<UJO,?> column)
Set the one column to reading from database table. |
|
Query<UJO> |
Query.setColumns(boolean addPrimaryKey,
org.ujorm.UjoProperty... columns)
Set an list of required columns to reading from database table. |
|
Query<UJO> |
Query.setCriterion(org.ujorm.criterion.Criterion<UJO> criterion)
Set a new Criterion. |
|
Query<UJO> |
Query.setDistinct()
Select DISTINCT for a unique row result |
|
Query<UJO> |
Query.setDistinct(boolean distinct)
Select DISTINCT for a unique row result |
|
Query<UJO> |
Query.setFetchSize(int fetchSize)
Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object. |
|
Query<UJO> |
Query.setLimit(int limit)
The max row count for the resultset. |
|
Query<UJO> |
Query.setLimit(int limit,
int offset)
Set a limit and offset. |
|
Query<UJO> |
Query.setLockRequest()
Set pessimistic lock request. |
|
Query<UJO> |
Query.setLockRequest(boolean lockRequest)
Pessimistic lock request. |
|
Query<UJO> |
Query.setMaxRows(int limit)
Deprecated. |
|
Query<UJO> |
Query.setOffset(int offset)
Get the first row to retrieve (offset). |
|
Query<UJO> |
Query.setOrder(org.ujorm.UjoProperty... order)
Deprecated. Use the orderByMany(org.ujorm.UjoProperty[]) method instead of |
|
Query<UJO> |
Query.setSession(Session session)
An open session must be assigned before executing a database request. |
|
| Methods in org.ujorm.orm with parameters of type Query | ||
|---|---|---|
|
Session.getRowCount(Query<UJO> query)
Returns a count of rows |
|
JdbcStatement |
Session.getStatement(Query query)
Run SQL SELECT by query. |
|
protected java.lang.Appendable |
SqlDialect.printLockForSelect(Query query,
java.lang.Appendable out)
Print a 'lock clausule' to the end of SQL SELECT statement to use a pessimistic lock. |
|
void |
SqlDialect.printOffset(Query query,
java.lang.Appendable out)
Print an OFFSET of the statement SELECT. |
|
java.lang.Appendable |
SqlDialect.printSelect(MetaTable table,
Query query,
boolean count,
java.lang.Appendable out)
Print a SQL SELECT by table model and query |
|
void |
SqlDialect.printSelectOrder(Query query,
java.lang.Appendable out)
Print SQL ORDER BY |
|
protected java.lang.Appendable |
SqlDialect.printSelectTable(Query query,
boolean count,
java.lang.Appendable out)
Print SQL database SELECT |
|
protected void |
SqlDialect.printSelectTableBase(Query query,
boolean count,
java.lang.Appendable out)
Print SQL database SELECT |
|
protected java.lang.Appendable |
SqlDialect.printSelectView(MetaTable table,
Query query,
boolean count,
java.lang.Appendable out)
Print SQL view SELECT |
|
| Uses of Query in org.ujorm.orm.dialect |
|---|
| Methods in org.ujorm.orm.dialect with parameters of type Query | |
|---|---|
protected java.lang.Appendable |
HsqldbDialect.printLockForSelect(Query query,
java.lang.Appendable out)
Including 1.7.2, HSQLDB does not support table locking via SELECT FOR UPDATE. |
protected java.lang.Appendable |
FirebirdDialect.printLockForSelect(Query query,
java.lang.Appendable out)
Print a 'lock clausule' to the end of SQL SELECT statement to use a pessimistic lock. |
void |
PostgreSqlDialect.printOffset(Query query,
java.lang.Appendable out)
Print an OFFSET of the statement SELECT. |
void |
OracleDialect.printOffset(Query query,
java.lang.Appendable out)
|
void |
DerbyDialect.printOffset(Query query,
java.lang.Appendable out)
|
protected java.lang.Appendable |
OracleDialect.printSelectTable(Query query,
boolean count,
java.lang.Appendable out)
Print SQL database SELECT |
| Uses of Query in org.ujorm.orm.utility |
|---|
| Methods in org.ujorm.orm.utility with parameters of type Query | ||
|---|---|---|
static
|
OrmTools.loadLazyValuesAsBatch(Query<UJO> query)
Load lazy value for all items and all relation properties by the rule: a one SQL statement per relation property. |
|
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||