com.pmease.quickbuild.plugin.report.engine.datastore
Class SqlBuilder
java.lang.Object
com.pmease.quickbuild.plugin.report.engine.datastore.SqlBuilder
public class SqlBuilder
- extends java.lang.Object
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
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.