br.com.sankhya.jape.querybuilder

Class XMLtoSQLProcessor.SelectBuilder

java.lang.Object

br.com.sankhya.jape.querybuilder.XMLtoSQLProcessor.SelectBuilder

Enclosing class:

XMLtoSQLProcessor

public class XMLtoSQLProcessor.SelectBuilder
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	XMLtoSQLProcessor.SelectBuilder.OrderByCol

Constructor Summary

Constructors

Constructor and Description
SelectBuilder()

Method Summary

Modifier and Type	Method and Description
void	addFromItem(java.lang.String dbObject, java.lang.String alias)
void	addGroupBy(java.lang.String column)
void	addJoin(java.lang.String table, java.lang.String alias, java.lang.String joinType, java.lang.String joinOn)
void	addOrderBy(java.lang.String col, java.lang.String orderType, int order)
void	addSelectItem(java.lang.String expression, java.lang.String aggregate, java.lang.String alias)
java.lang.String	buildSQL()
void	setHaving(java.lang.String having)
void	setWhere(java.lang.String where)

Methods inherited from class java.lang.Object

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

Constructor Detail

SelectBuilder

public SelectBuilder()

Method Detail

addFromItem

public void addFromItem(java.lang.String dbObject,
                        java.lang.String alias)

addGroupBy

public void addGroupBy(java.lang.String column)

addJoin

public void addJoin(java.lang.String table,
                    java.lang.String alias,
                    java.lang.String joinType,
                    java.lang.String joinOn)

addOrderBy

public void addOrderBy(java.lang.String col,
                       java.lang.String orderType,
                       int order)

addSelectItem

public void addSelectItem(java.lang.String expression,
                          java.lang.String aggregate,
                          java.lang.String alias)

buildSQL

public java.lang.String buildSQL()

setHaving

public void setHaving(java.lang.String having)

setWhere

public void setWhere(java.lang.String where)