This project has retired. For details please refer to its Attic page.

org.apache.gora.sql.statement
Class SelectStatement

java.lang.Object
  org.apache.gora.sql.statement.SelectStatement

public class SelectStatement
extends Object

A SQL SELECT statement

Constructor Summary

SelectStatement()

SelectStatement(String from)

SelectStatement(String selectList, String from, String where, String orderBy)

SelectStatement(String selectList, String from, Where where, String groupBy, String having, String orderBy, boolean orderByAsc, int offset, int limit, boolean semicolon)

Method Summary

void	addToSelectList(String selectField)
void	addWhere(String part) Adds a part to the Where clause connected with AND
String	getFrom()
String	getGroupBy()
String	getHaving()
long	getLimit()
long	getOffset()
String	getOrderBy()
ArrayList<String>	getSelectList()
String	getSelectStatement()
Where	getWhere()
boolean	isOrderByAsc()
boolean	isSemicolon()
void	setFrom(String from)
void	setGroupBy(String groupBy)
void	setHaving(String having)
void	setLimit(long limit)
void	setOffset(long offset)
void	setOrderBy(String orderBy)
void	setOrderByAsc(boolean orderByAsc)
void	setSelectList(ArrayList<String> selectList)
void	setSelectStatement(String selectStatement)
void	setSemicolon(boolean semicolon)
void	setWhere(String where)
void	setWhere(Where where)
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

SelectStatement

public SelectStatement()

SelectStatement

public SelectStatement(String from)

SelectStatement

public SelectStatement(String selectList,
                       String from,
                       String where,
                       String orderBy)

SelectStatement

public SelectStatement(String selectList,
                       String from,
                       Where where,
                       String groupBy,
                       String having,
                       String orderBy,
                       boolean orderByAsc,
                       int offset,
                       int limit,
                       boolean semicolon)

Method Detail

toString

public String toString()

Overrides:

toString in class Object

addWhere

public void addWhere(String part)

Adds a part to the Where clause connected with AND

setSelectStatement

public void setSelectStatement(String selectStatement)

getSelectStatement

public String getSelectStatement()

getSelectList

public ArrayList<String> getSelectList()

setSelectList

public void setSelectList(ArrayList<String> selectList)

addToSelectList

public void addToSelectList(String selectField)

getFrom

public String getFrom()

Returns:

the from

setFrom

public void setFrom(String from)

Parameters:

from - the from to set

getWhere

public Where getWhere()

Returns:

the where

setWhere

public void setWhere(Where where)

Parameters:

where - the where to set

setWhere

public void setWhere(String where)

Parameters:

where - the where to set

getGroupBy

public String getGroupBy()

Returns:

the groupBy

setGroupBy

public void setGroupBy(String groupBy)

Parameters:

groupBy - the groupBy to set

getHaving

public String getHaving()

Returns:

the having

setHaving

public void setHaving(String having)

Parameters:

having - the having to set

getOrderBy

public String getOrderBy()

Returns:

the orderBy

setOrderBy

public void setOrderBy(String orderBy)

Parameters:

orderBy - the orderBy to set

isOrderByAsc

public boolean isOrderByAsc()

Returns:

the orderByAsc

setOrderByAsc

public void setOrderByAsc(boolean orderByAsc)

Parameters:

orderByAsc - the orderByAsc to set

getOffset

public long getOffset()

Returns:

the offset

setOffset

public void setOffset(long offset)

Parameters:

offset - the offset to set

getLimit

public long getLimit()

Returns:

the limit

setLimit

public void setLimit(long limit)

Parameters:

limit - the limit to set

isSemicolon

public boolean isSemicolon()

Returns:

the semicolon

setSemicolon

public void setSemicolon(boolean semicolon)

Parameters:

semicolon - the semicolon to set