|
Produced by Siminov Software Solution LLP | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface ISelect
Exposes API's to get tuples from table based on information provided.
Field Summary | |
---|---|
static java.lang.String |
INTERFACE_NAME
|
Method Summary | |
---|---|
ISelectClause |
and(java.lang.String column)
Used to specify AND condition between where clause. |
ISelect |
ascendingOrderBy(java.lang.String... columns)
Used to specify ORDER BY ASC keyword to sort the result-set in ascending order. |
ISelect |
columns(java.lang.String... columns)
Used to provide name of columns only for which data will be fetched. |
ISelect |
descendingOrderBy(java.lang.String... columns)
Used to specify ORDER BY DESC keyword to sort the result-set in descending order. |
ISelect |
distinct()
Used to specify DISTINCT condition. |
java.lang.Object[] |
fetch()
Used to get tuples, this method should be called in last to get tuples from table. |
ISelect |
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. |
ISelectClause |
having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions. |
ISelect |
havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's. |
ISelect |
limit(int limit)
Used to specify the range of data need to fetch from table. |
ISelectClause |
or(java.lang.String column)
Used to specify OR condition between where clause. |
ISelect |
orderBy(java.lang.String... columns)
Used to specify ORDER BY keyword to sort the result-set. |
ISelectClause |
where(java.lang.String column)
Column name of which condition will be specified. |
ISelect |
whereClause(java.lang.String whereClause)
Used to provide manually created Where clause, instead of using API's. |
Field Detail |
---|
static final java.lang.String INTERFACE_NAME
Method Detail |
---|
ISelect distinct()
ISelectClause where(java.lang.String column)
column
- Name of column.
ISelect whereClause(java.lang.String whereClause)
whereClause
- Manually created where clause.
ISelectClause and(java.lang.String column)
column
- Name of column on which condition need to be specified.
ISelectClause or(java.lang.String column)
column
- Name of column on which condition need to be specified.
ISelect orderBy(java.lang.String... columns)
columns
- Name of columns which need to be sorted.
ISelect ascendingOrderBy(java.lang.String... columns)
columns
- Name of columns which need to be sorted.
ISelect descendingOrderBy(java.lang.String... columns)
columns
- Name of columns which need to be sorted.
ISelect limit(int limit)
limit
- LIMIT of data.
ISelect groupBy(java.lang.String... columns)
columns
- Name of columns.
ISelectClause having(java.lang.String column)
column
- Name of column on which condition need to be applied.
ISelect havingClause(java.lang.String havingClause)
havingClause
- Where clause.
ISelect columns(java.lang.String... columns)
column
- Name of columns.
java.lang.Object[] fetch() throws DatabaseException
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 |