public class XMLtoSQLProcessor.SelectBuilder
extends java.lang.Object
| Modifier and Type | Class and Description |
|---|---|
class |
XMLtoSQLProcessor.SelectBuilder.OrderByCol |
| Constructor and Description |
|---|
SelectBuilder() |
| 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) |
public void addFromItem(java.lang.String dbObject,
java.lang.String alias)
public void addGroupBy(java.lang.String column)
public void addJoin(java.lang.String table,
java.lang.String alias,
java.lang.String joinType,
java.lang.String joinOn)
public void addOrderBy(java.lang.String col,
java.lang.String orderType,
int order)
public void addSelectItem(java.lang.String expression,
java.lang.String aggregate,
java.lang.String alias)
public java.lang.String buildSQL()
public void setHaving(java.lang.String having)
public void setWhere(java.lang.String where)