Produced by Siminov Software Solution LLP

siminov.orm.database.impl
Interface ISelect

All Known Implementing Classes:
Select

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

INTERFACE_NAME

static final java.lang.String INTERFACE_NAME
Method Detail

distinct

ISelect distinct()
Used to specify DISTINCT condition.

Returns:
ICount Interface.

where

ISelectClause where(java.lang.String column)
Column name of which condition will be specified.

Parameters:
column - Name of column.
Returns:
ISelectClause Interface.

whereClause

ISelect whereClause(java.lang.String whereClause)
Used to provide manually created Where clause, instead of using API's.

Parameters:
whereClause - Manually created where clause.
Returns:
ISelect Interface.

and

ISelectClause and(java.lang.String column)
Used to specify AND condition between where clause.

Parameters:
column - Name of column on which condition need to be specified.
Returns:
ISelectClause Interface.

or

ISelectClause or(java.lang.String column)
Used to specify OR condition between where clause.

Parameters:
column - Name of column on which condition need to be specified.
Returns:
ISelectClause Interface.

orderBy

ISelect orderBy(java.lang.String... columns)
Used to specify ORDER BY keyword to sort the result-set.

Parameters:
columns - Name of columns which need to be sorted.
Returns:
ISelect Interface.

ascendingOrderBy

ISelect ascendingOrderBy(java.lang.String... columns)
Used to specify ORDER BY ASC keyword to sort the result-set in ascending order.

Parameters:
columns - Name of columns which need to be sorted.
Returns:
ISelect Interface.

descendingOrderBy

ISelect descendingOrderBy(java.lang.String... columns)
Used to specify ORDER BY DESC keyword to sort the result-set in descending order.

Parameters:
columns - Name of columns which need to be sorted.
Returns:
ISelect Interface.

limit

ISelect limit(int limit)
Used to specify the range of data need to fetch from table.

Parameters:
limit - LIMIT of data.
Returns:
ISelect Interface.

groupBy

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.

Parameters:
columns - Name of columns.
Returns:
ISelect Interface.

having

ISelectClause having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.

Parameters:
column - Name of column on which condition need to be applied.
Returns:
ISelectClause Interface.

havingClause

ISelect havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's.

Parameters:
havingClause - Where clause.
Returns:
ISelect Interface.

columns

ISelect columns(java.lang.String... columns)
Used to provide name of columns only for which data will be fetched.

Parameters:
column - Name of columns.
Returns:
ISelect Interface.

fetch

java.lang.Object[] fetch()
                         throws DatabaseException
Used to get tuples, this method should be called in last to get tuples from table.

Returns:
Return array of model objects.
Throws:
DatabaseException - Throws exception if any error occur while getting tuples from table.

Apache License 2.0

Copyright 2013