|
Produced by Siminov Software Solution LLP | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectsiminov.orm.database.Select
public class Select
Field Summary |
---|
Fields inherited from interface siminov.orm.database.impl.ISelect |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.IDelete |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.ICount |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.ISum |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.ITotal |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.IAverage |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.IMax |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.IMin |
---|
INTERFACE_NAME |
Fields inherited from interface siminov.orm.database.impl.IGroupConcat |
---|
INTERFACE_NAME |
Constructor Summary | |
---|---|
Select()
|
|
Select(DatabaseMappingDescriptor databaseMappingDescriptor,
java.lang.String interfaceName)
|
|
Select(DatabaseMappingDescriptor databaseMappingDescriptor,
java.lang.String interfaceName,
java.lang.Object referObject)
|
Method Summary | |
---|---|
Clause |
and(java.lang.String column)
Used to specify AND condition between where clause. |
Select |
ascendingOrderBy(java.lang.String... columns)
Used to specify ORDER BY ASC keyword to sort the result-set in ascending order. |
Select |
column(java.lang.String column)
Used to provide name of column for which count will be calculated. |
Select |
columns(java.lang.String... columns)
Used to provide name of columns only for which data will be fetched. |
Select |
delimiter(java.lang.String delimiter)
Used to specify separator if Y is omitted. |
Select |
descendingOrderBy(java.lang.String... columns)
Used to specify ORDER BY DESC keyword to sort the result-set in descending order. |
Select |
distinct()
Used to specify DISTINCT condition. |
java.lang.Object |
execute()
Used to delete, this method should be called in last to delete tuples from table. |
java.lang.Object[] |
fetch()
Used to get tuples, this method should be called in last to get tuples from table. |
Select |
groupBy(java.lang.String... columns)
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns. |
Clause |
having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions. |
Select |
havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's. |
Select |
limit(int limit)
Used to specify the range of data need to fetch from table. |
Clause |
or(java.lang.String column)
Used to specify OR condition between where clause. |
Select |
orderBy(java.lang.String... columns)
Used to specify ORDER BY keyword to sort the result-set. |
Clause |
where(java.lang.String column)
Column name of which condition will be specified. |
Select |
whereClause(java.lang.String whereClause)
Used to provide manually created Where clause, instead of using API's. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public Select()
public Select(DatabaseMappingDescriptor databaseMappingDescriptor, java.lang.String interfaceName) throws DatabaseException
DatabaseException
public Select(DatabaseMappingDescriptor databaseMappingDescriptor, java.lang.String interfaceName, java.lang.Object referObject) throws DatabaseException
DatabaseException
Method Detail |
---|
public Select distinct()
ISelect
distinct
in interface ICount
distinct
in interface ISelect
public Clause where(java.lang.String column)
ISelect
where
in interface IAverage
where
in interface ICount
where
in interface IDelete
where
in interface IGroupConcat
where
in interface IMax
where
in interface IMin
where
in interface ISelect
where
in interface ISum
where
in interface ITotal
column
- Name of column.
public Select whereClause(java.lang.String whereClause)
ISelect
whereClause
in interface IAverage
whereClause
in interface ICount
whereClause
in interface IDelete
whereClause
in interface IGroupConcat
whereClause
in interface IMax
whereClause
in interface IMin
whereClause
in interface ISelect
whereClause
in interface ISum
whereClause
in interface ITotal
whereClause
- Manually created where clause.
public Clause and(java.lang.String column)
ISelect
and
in interface IAverage
and
in interface ICount
and
in interface IDelete
and
in interface IGroupConcat
and
in interface IMax
and
in interface IMin
and
in interface ISelect
and
in interface ISum
and
in interface ITotal
column
- Name of column on which condition need to be specified.
public Clause or(java.lang.String column)
ISelect
or
in interface IAverage
or
in interface ICount
or
in interface IDelete
or
in interface IGroupConcat
or
in interface IMax
or
in interface IMin
or
in interface ISelect
or
in interface ISum
or
in interface ITotal
column
- Name of column on which condition need to be specified.
public Select orderBy(java.lang.String... columns)
ISelect
orderBy
in interface ISelect
columns
- Name of columns which need to be sorted.
public Select ascendingOrderBy(java.lang.String... columns)
ISelect
ascendingOrderBy
in interface ISelect
columns
- Name of columns which need to be sorted.
public Select descendingOrderBy(java.lang.String... columns)
ISelect
descendingOrderBy
in interface ISelect
columns
- Name of columns which need to be sorted.
public Select limit(int limit)
ISelect
limit
in interface ISelect
limit
- LIMIT of data.
public Select groupBy(java.lang.String... columns)
ISelect
groupBy
in interface IAverage
groupBy
in interface ICount
groupBy
in interface IGroupConcat
groupBy
in interface IMax
groupBy
in interface IMin
groupBy
in interface ISelect
groupBy
in interface ISum
groupBy
in interface ITotal
columns
- Name of columns.
public Clause having(java.lang.String column)
ISelect
having
in interface IAverage
having
in interface ICount
having
in interface IGroupConcat
having
in interface IMax
having
in interface IMin
having
in interface ISelect
having
in interface ISum
having
in interface ITotal
column
- Name of column on which condition need to be applied.
public Select havingClause(java.lang.String havingClause)
ISelect
havingClause
in interface IAverage
havingClause
in interface ICount
havingClause
in interface IGroupConcat
havingClause
in interface IMax
havingClause
in interface IMin
havingClause
in interface ISelect
havingClause
in interface ISum
havingClause
in interface ITotal
havingClause
- Where clause.
public Select column(java.lang.String column)
ICount
column
in interface IAverage
column
in interface ICount
column
in interface IGroupConcat
column
in interface IMax
column
in interface IMin
column
in interface ISum
column
in interface ITotal
column
- Name of column.
public Select columns(java.lang.String... columns)
ISelect
columns
in interface ISelect
public Select delimiter(java.lang.String delimiter)
IGroupConcat
delimiter
in interface IGroupConcat
delimiter
- Delimiter.
public java.lang.Object execute() throws DatabaseException
IDelete
execute
in interface IAverage
execute
in interface ICount
execute
in interface IDelete
execute
in interface IGroupConcat
execute
in interface IMax
execute
in interface IMin
execute
in interface ISum
execute
in interface ITotal
DatabaseException
- Throws exception if any error occur while deleting tuples from table.public java.lang.Object[] fetch() throws DatabaseException
ISelect
fetch
in interface ISelect
DatabaseException
- Throws exception if any error occur while getting tuples from table.
|
Apache License 2.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |