com.hfg.sql

Class SQLQuery

java.lang.Object

com.hfg.sql.SQLCmd

com.hfg.sql.SQLQuery

public class SQLQuery
extends SQLCmd

Container for building a SQL query.

Constructor Summary

Constructors

Constructor and Description
SQLQuery()

Method Summary

Modifier and Type	Method and Description
SQLQuery	addClause(SQLClause inValue)
SQLQuery	addClauses(java.util.Collection<SQLClause> inClauses)
SQLQuery	addFrom(DatabaseTable inValue)
SQLQuery	addFrom(DatabaseTable inValue, java.lang.String inAlias)
SQLQuery	addFrom(java.lang.String inValue)
SQLQuery	addFrom(java.lang.String inValue, java.lang.String inAlias)
SQLQuery	addGroupBy(DatabaseCol inValue)
SQLQuery	addGroupBy(java.lang.String inValue)
SQLQuery	addJoin(JoinClause inValue)
SQLQuery	addJoin(java.lang.String inValue)
SQLQuery	addOrderBy(java.lang.String inValue)
SQLQuery	addSelect(DatabaseCol inColumn)
SQLQuery	addSelect(java.lang.String inValue)
SQLQuery	addWhereClause(DatabaseField inValue)
SQLQuery	addWhereClause(java.lang.String inValue)
SQLQuery	addWhereClauseGroup(WhereClauseGroup inValue)
java.sql.ResultSet	execute(java.sql.Connection inConn)
java.sql.ResultSet	execute(java.sql.Connection inConn, SQLStatementOptions inOptions)
SQLQuery	setLimit(int inValue)
java.lang.String	toSQL()
java.lang.String	toString()

Methods inherited from class com.hfg.sql.SQLCmd

generateOrderByClause, generateWhereClause

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLQuery

public SQLQuery()

Method Detail

execute

public java.sql.ResultSet execute(java.sql.Connection inConn)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

public java.sql.ResultSet execute(java.sql.Connection inConn,
                                  SQLStatementOptions inOptions)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

toSQL

public java.lang.String toSQL()

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

addClauses

public SQLQuery addClauses(java.util.Collection<SQLClause> inClauses)

Overrides:

addClauses in class SQLCmd

addClause

public SQLQuery addClause(SQLClause inValue)
                   throws JDBCException

Overrides:

addClause in class SQLCmd

Throws:

JDBCException

addSelect

public SQLQuery addSelect(DatabaseCol inColumn)

addSelect

public SQLQuery addSelect(java.lang.String inValue)

addFrom

public SQLQuery addFrom(DatabaseTable inValue)

addFrom

public SQLQuery addFrom(DatabaseTable inValue,
                        java.lang.String inAlias)

addFrom

public SQLQuery addFrom(java.lang.String inValue,
                        java.lang.String inAlias)

addFrom

public SQLQuery addFrom(java.lang.String inValue)

addJoin

public SQLQuery addJoin(JoinClause inValue)

addJoin

public SQLQuery addJoin(java.lang.String inValue)

addWhereClause

public SQLQuery addWhereClause(java.lang.String inValue)

addWhereClause

public SQLQuery addWhereClause(DatabaseField inValue)

addWhereClauseGroup

public SQLQuery addWhereClauseGroup(WhereClauseGroup inValue)

Overrides:

addWhereClauseGroup in class SQLCmd

addGroupBy

public SQLQuery addGroupBy(DatabaseCol inValue)

addGroupBy

public SQLQuery addGroupBy(java.lang.String inValue)

addOrderBy

public SQLQuery addOrderBy(java.lang.String inValue)

setLimit

public SQLQuery setLimit(int inValue)