ch.specchio.queries

Class Query

java.lang.Object

ch.specchio.queries.Query

public class Query
extends java.lang.Object

This class represents a query to the database.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COUNT_QUERY
static java.lang.String	SELECT_QUERY

Constructor Summary

Constructors

Constructor and Description
Query()
Query(java.lang.String tablename)
Query(java.lang.String tablename, java.lang.String tablename_alias)

Method Summary

Modifier and Type	Method and Description
void	add_condition(QueryCondition cond)
void	add_join(java.lang.String tablename, QueryCondition cond)
void	addColumn(java.lang.String column)
java.lang.String	getColumn(int i)
java.util.ArrayList<java.lang.String>	getColumns()
java.util.ArrayList<QueryCondition>	getConditionFields()
java.util.ArrayList<QueryCondition>	getEAVConditionFields()
java.lang.String	getOrderBy()
java.lang.String	getQueryType()
java.util.ArrayList<QueryCondition>	getStandardConditionFields()
java.lang.String	getTableAlias()
java.lang.String	getTableName()
void	remove_all_conditions()
void	setColumns(java.util.ArrayList<java.lang.String> columns)
void	setConditionFields(java.util.ArrayList<QueryCondition> cond_fields)
void	setEAVConditionFields(java.util.ArrayList<QueryCondition> cond_fields)
void	setOrderBy(java.lang.String order_by)
void	setQueryType(java.lang.String query_type)
void	setStandardConditionFields(java.util.ArrayList<QueryCondition> cond_fields)
void	setTableAlias(java.lang.String tablename_alias)
void	setTableName(java.lang.String tablename)

Methods inherited from class java.lang.Object

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

Field Detail

COUNT_QUERY

public static final java.lang.String COUNT_QUERY

See Also:

Constant Field Values

SELECT_QUERY

public static final java.lang.String SELECT_QUERY

See Also:

Constant Field Values

Constructor Detail

Query

public Query()

Query

public Query(java.lang.String tablename)

Query

public Query(java.lang.String tablename,
             java.lang.String tablename_alias)

Method Detail

getColumns

public java.util.ArrayList<java.lang.String> getColumns()

setColumns

public void setColumns(java.util.ArrayList<java.lang.String> columns)

getColumn

public java.lang.String getColumn(int i)

addColumn

public void addColumn(java.lang.String column)

getStandardConditionFields

public java.util.ArrayList<QueryCondition> getStandardConditionFields()

setStandardConditionFields

public void setStandardConditionFields(java.util.ArrayList<QueryCondition> cond_fields)

getEAVConditionFields

public java.util.ArrayList<QueryCondition> getEAVConditionFields()

setEAVConditionFields

public void setEAVConditionFields(java.util.ArrayList<QueryCondition> cond_fields)

getConditionFields

public java.util.ArrayList<QueryCondition> getConditionFields()

setConditionFields

public void setConditionFields(java.util.ArrayList<QueryCondition> cond_fields)

getQueryType

public java.lang.String getQueryType()

setQueryType

public void setQueryType(java.lang.String query_type)

getOrderBy

public java.lang.String getOrderBy()

setOrderBy

public void setOrderBy(java.lang.String order_by)

getTableAlias

public java.lang.String getTableAlias()

setTableAlias

public void setTableAlias(java.lang.String tablename_alias)

getTableName

public java.lang.String getTableName()

setTableName

public void setTableName(java.lang.String tablename)

add_condition

public void add_condition(QueryCondition cond)

add_join

public void add_join(java.lang.String tablename,
                     QueryCondition cond)

remove_all_conditions

public void remove_all_conditions()