com.pmease.quickbuild.plugin.report.engine.datastore
Class SqlBuilder

java.lang.Object
  extended by com.pmease.quickbuild.plugin.report.engine.datastore.SqlBuilder

public class SqlBuilder
extends java.lang.Object


Method Summary
 SqlBuilder clearFilters()
           
 SqlBuilder clearGroupBy()
           
 SqlBuilder clearOrderBy()
           
static SqlBuilder deleteFrom(java.lang.String table)
           
 SqlBuilder distinct(boolean b)
           
 SqlBuilder from(java.lang.String... tableNames)
           
 com.pmease.quickbuild.plugin.report.engine.datastore.SqlBuilder.SqlCommand getCommand()
           
 java.util.List<Filter> getFilters()
           
 java.util.List<java.lang.String> getGroupByColumns()
           
 int getLimit()
           
 int getOffset()
           
 java.util.List<Order> getOrders()
           
 java.lang.Object[] getParams()
           
 java.util.List<java.lang.String> getSelectColumns()
           
 java.util.List<java.lang.String> getTables()
           
 int getTop()
           
 java.util.Map<java.lang.String,java.lang.Object> getValues()
           
 SqlBuilder groupby(java.lang.String... columnNames)
           
static SqlBuilder insert(java.lang.String table)
           
 boolean isDistinct()
           
 SqlBuilder limit(int limits)
           
static SqlBuilder merge(java.lang.String table)
           
 SqlBuilder offset(int offsets)
           
 SqlBuilder orderby(java.util.List<Order> orders)
           
 SqlBuilder orderby(Order... orders)
           
static SqlBuilder query()
           
 SqlBuilder select(java.lang.String... columnNames)
           
 void setCommand(com.pmease.quickbuild.plugin.report.engine.datastore.SqlBuilder.SqlCommand command)
           
 void setDistinct(boolean distinct)
           
 void setFilters(java.util.List<Filter> filters)
           
 void setGroupByColumns(java.util.List<java.lang.String> groupByColumns)
           
 void setLimit(int limit)
           
 void setOffset(int offset)
           
 void setOrders(java.util.List<Order> orders)
           
 void setSelectColumns(java.util.List<java.lang.String> selectColumns)
           
 void setTables(java.util.List<java.lang.String> tables)
           
 void setTop(int top)
           
 void setValues(java.util.Map<java.lang.String,java.lang.Object> values)
           
 SqlBuilder top(int n)
           
 java.lang.String toSqlString()
           
static SqlBuilder update(java.lang.String table)
           
 SqlBuilder values(java.lang.String[] columns, java.lang.Object[] values)
           
 SqlBuilder where(Filter... array)
           
 SqlBuilder where(java.util.List<? extends Filter> list)
           
 SqlBuilder where(java.lang.String str)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

query

public static SqlBuilder query()

insert

public static SqlBuilder insert(java.lang.String table)

merge

public static SqlBuilder merge(java.lang.String table)

update

public static SqlBuilder update(java.lang.String table)

deleteFrom

public static SqlBuilder deleteFrom(java.lang.String table)

select

public SqlBuilder select(java.lang.String... columnNames)

top

public SqlBuilder top(int n)

distinct

public SqlBuilder distinct(boolean b)

from

public SqlBuilder from(java.lang.String... tableNames)

where

public SqlBuilder where(java.lang.String str)

where

public SqlBuilder where(java.util.List<? extends Filter> list)

where

public SqlBuilder where(Filter... array)

groupby

public SqlBuilder groupby(java.lang.String... columnNames)

orderby

public SqlBuilder orderby(Order... orders)

orderby

public SqlBuilder orderby(java.util.List<Order> orders)

limit

public SqlBuilder limit(int limits)

offset

public SqlBuilder offset(int offsets)

values

public SqlBuilder values(java.lang.String[] columns,
                         java.lang.Object[] values)

clearOrderBy

public SqlBuilder clearOrderBy()

clearGroupBy

public SqlBuilder clearGroupBy()

clearFilters

public SqlBuilder clearFilters()

getParams

public java.lang.Object[] getParams()

toSqlString

public java.lang.String toSqlString()

getCommand

public com.pmease.quickbuild.plugin.report.engine.datastore.SqlBuilder.SqlCommand getCommand()

setCommand

public void setCommand(com.pmease.quickbuild.plugin.report.engine.datastore.SqlBuilder.SqlCommand command)

getSelectColumns

public java.util.List<java.lang.String> getSelectColumns()

setSelectColumns

public void setSelectColumns(java.util.List<java.lang.String> selectColumns)

getTables

public java.util.List<java.lang.String> getTables()

setTables

public void setTables(java.util.List<java.lang.String> tables)

getGroupByColumns

public java.util.List<java.lang.String> getGroupByColumns()

setGroupByColumns

public void setGroupByColumns(java.util.List<java.lang.String> groupByColumns)

getOrders

public java.util.List<Order> getOrders()

setOrders

public void setOrders(java.util.List<Order> orders)

getTop

public int getTop()

setTop

public void setTop(int top)

isDistinct

public boolean isDistinct()

setDistinct

public void setDistinct(boolean distinct)

getLimit

public int getLimit()

setLimit

public void setLimit(int limit)

getOffset

public int getOffset()

setOffset

public void setOffset(int offset)

getFilters

public java.util.List<Filter> getFilters()

setFilters

public void setFilters(java.util.List<Filter> filters)

getValues

public java.util.Map<java.lang.String,java.lang.Object> getValues()

setValues

public void setValues(java.util.Map<java.lang.String,java.lang.Object> values)


Copyright © 2005-2010 PMEase Inc. All Rights Reserved.