Uses of Class
org.tinygroup.tinysqldsl.Select

Packages that use Select

Package	Description
org.tinygroup.jdbctemplatedslsession
org.tinygroup.jdbctemplatedslsession.callback
org.tinygroup.jdbctemplatedslsession.pageprocess
org.tinygroup.jdbctemplatedslsession.util
org.tinygroup.tinysqldsl
org.tinygroup.tinysqldsl.extend
org.tinygroup.tinysqldsl.formitem

Uses of Select in org.tinygroup.jdbctemplatedslsession

Methods in org.tinygroup.jdbctemplatedslsession with parameters of type Select

Modifier and Type	Method and Description
int	SimpleDslSession.count(Select select)
void	SimpleDslSession.extractResultSet(Select select, ResultSetCallback callback)
<T> T[]	SimpleDslSession.fetchArray(Select select, Class<T> requiredType)
<T> Pager<T>	SimpleDslSession.fetchCursorPage(Select commonSelect, int start, int limit, Class<T> requiredType)
<T> List<T>	SimpleDslSession.fetchCursorPageList(Select commonSelect, int start, int limit, Class<T> requiredType)
<T> Pager<T>	SimpleDslSession.fetchDialectPage(Select commonSelect, int start, int limit, Class<T> requiredType)
<T> List<T>	SimpleDslSession.fetchDialectPageList(Select commonSelect, int start, int limit, Class<T> requiredType)
<T> List<T>	SimpleDslSession.fetchList(Select select, Class<T> requiredType)
<T> T	SimpleDslSession.fetchOneResult(Select select, Class<T> requiredType)
<T> Pager<T>	SimpleDslSession.fetchPage(Select commonSelect, int start, int limit, boolean isCursor, Class<T> requiredType)
<T> List<T>	SimpleDslSession.fetchPageList(Select commonSelect, int start, int limit, boolean isCursor, Class<T> requiredType)
String	PageSqlMatchProcess.sqlProcess(Select select, int start, int limit) 对查询语句进行分页sql处理，返回具有分页信息的sql语句

Uses of Select in org.tinygroup.jdbctemplatedslsession.callback

Methods in org.tinygroup.jdbctemplatedslsession.callback that return Select

Modifier and Type	Method and Description
Select	SelectGenerateCallback.generate(T t)

Uses of Select in org.tinygroup.jdbctemplatedslsession.pageprocess

Methods in org.tinygroup.jdbctemplatedslsession.pageprocess with parameters of type Select

Modifier and Type	Method and Description
protected abstract String	AbstractPageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	DB2PageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	H2PageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	SybasePageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	SqlServerPageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	MysqlPageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	DerbyPageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	OraclePageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
protected String	InformixPageSqlMatchProcess.internalSqlProcess(Select select, int start, int limit)
String	AbstractPageSqlMatchProcess.sqlProcess(Select select, int start, int limit)

Uses of Select in org.tinygroup.jdbctemplatedslsession.util

Methods in org.tinygroup.jdbctemplatedslsession.util that return Select

Modifier and Type	Method and Description
static Select	TinyDSLUtil.addOrderByElements(Select select, OrderBy... orderByArray) 添加排序字段工具方法

Methods in org.tinygroup.jdbctemplatedslsession.util with parameters of type Select

Modifier and Type	Method and Description
static Select	TinyDSLUtil.addOrderByElements(Select select, OrderBy... orderByArray) 添加排序字段工具方法

Uses of Select in org.tinygroup.tinysqldsl

Classes in org.tinygroup.tinysqldsl with type parameters of type Select

Modifier and Type	Class and Description
class	Select<T extends Select<T>> Created by luoguo on 2015/3/11.

Methods in org.tinygroup.tinysqldsl that return Select

Modifier and Type	Method and Description
Select	Select.copy()
protected Select	Select.newSelect()
static Select	Select.select(SelectItem... selectItems)
static Select	Select.selectFrom(Table... tables)

Methods in org.tinygroup.tinysqldsl with parameters of type Select

Modifier and Type	Method and Description
int	DslSession.count(Select select) 查询总记录数
void	DslSession.extractResultSet(Select select, ResultSetCallback callback) resultset处理
<T> T[]	DslSession.fetchArray(Select select, Class<T> requiredType) 把所有的结果变成一个对象数组返回
<T> Pager<T>	DslSession.fetchCursorPage(Select commonSelect, int start, int limit, Class<T> requiredType) 基于游标的分页方式，select对象生成的sql语句是不包含分页信息的
<T> List<T>	DslSession.fetchCursorPageList(Select commonSelect, int start, int limit, Class<T> requiredType) 基于游标的分页方式，select对象生成的sql语句是不包含分页信息的
<T> Pager<T>	DslSession.fetchDialectPage(Select commonSelect, int start, int limit, Class<T> requiredType) 基于方言的分页方式，select对象生成的sql语句是包含分页信息的
<T> List<T>	DslSession.fetchDialectPageList(Select commonSelect, int start, int limit, Class<T> requiredType) 基于方言的分页方式，select对象生成的sql语句是包含分页信息的
<T> List<T>	DslSession.fetchList(Select select, Class<T> requiredType) 把所有的结果变成一个对象列表返回
<T> T	DslSession.fetchOneResult(Select select, Class<T> requiredType) 返回一个结果，既然是有多个结果也只返回第一个结果
<T> Pager<T>	DslSession.fetchPage(Select commonSelect, int start, int limit, boolean isCursor, Class<T> requiredType) 分页处理
<T> List<T>	DslSession.fetchPageList(Select commonSelect, int start, int limit, boolean isCursor, Class<T> requiredType) 分页处理
Insert	Insert.selectBody(Select select)
static ComplexSelect	ComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static ComplexSelect	ComplexSelect.union(Select... selects)
static ComplexSelect	ComplexSelect.unionAll(Select... selects)

Uses of Select in org.tinygroup.tinysqldsl.extend

Subclasses of Select in org.tinygroup.tinysqldsl.extend

Modifier and Type	Class and Description
class	DB2Select DB2数据库相关的查询
class	DerbySelect 与sqlserver数据库相关的查询语句
class	H2Select mysql数据库相关的查询
class	InformixSelect informix数据库相关的查询
class	MysqlSelect mysql数据库相关的查询
class	OracleSelect oracle数据库相关的查询
class	SqlServerSelect 与sqlserver数据库相关的查询语句

Methods in org.tinygroup.tinysqldsl.extend that return Select

Modifier and Type	Method and Description
protected Select	MysqlSelect.newSelect()
protected Select	InformixSelect.newSelect()
protected Select	DB2Select.newSelect()
protected Select	OracleSelect.newSelect()
protected Select	DerbySelect.newSelect()
protected Select	H2Select.newSelect()
protected Select	SqlServerSelect.newSelect()

Methods in org.tinygroup.tinysqldsl.extend with parameters of type Select

Modifier and Type	Method and Description
static DerbyComplexSelect	DerbyComplexSelect.except(Select... selects)
static SqlServerComplexSelect	SqlServerComplexSelect.except(Select... selects)
static DB2ComplexSelect	DB2ComplexSelect.intersect(Select... selects)
static DerbyComplexSelect	DerbyComplexSelect.intersect(Select... selects)
static InformixComplexSelect	InformixComplexSelect.intersect(Select... selects)
static OracleComplexSelect	OracleComplexSelect.intersect(Select... selects)
static SqlServerComplexSelect	SqlServerComplexSelect.intersect(Select... selects)
static DB2ComplexSelect	DB2ComplexSelect.minus(Select... selects)
static InformixComplexSelect	InformixComplexSelect.minus(Select... selects)
static OracleComplexSelect	OracleComplexSelect.minus(Select... selects)
static DB2ComplexSelect	DB2ComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static MysqlComplexSelect	MysqlComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static DerbyComplexSelect	DerbyComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static InformixComplexSelect	InformixComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static OracleComplexSelect	OracleComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static H2ComplexSelect	H2ComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static SqlServerComplexSelect	SqlServerComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static DB2ComplexSelect	DB2ComplexSelect.union(Select... selects)
static MysqlComplexSelect	MysqlComplexSelect.union(Select... selects)
static DerbyComplexSelect	DerbyComplexSelect.union(Select... selects)
static InformixComplexSelect	InformixComplexSelect.union(Select... selects)
static OracleComplexSelect	OracleComplexSelect.union(Select... selects)
static H2ComplexSelect	H2ComplexSelect.union(Select... selects)
static SqlServerComplexSelect	SqlServerComplexSelect.union(Select... selects)
static DB2ComplexSelect	DB2ComplexSelect.unionAll(Select... selects)
static MysqlComplexSelect	MysqlComplexSelect.unionAll(Select... selects)
static DerbyComplexSelect	DerbyComplexSelect.unionAll(Select... selects)
static InformixComplexSelect	InformixComplexSelect.unionAll(Select... selects)
static OracleComplexSelect	OracleComplexSelect.unionAll(Select... selects)
static H2ComplexSelect	H2ComplexSelect.unionAll(Select... selects)
static SqlServerComplexSelect	SqlServerComplexSelect.unionAll(Select... selects)

Uses of Select in org.tinygroup.tinysqldsl.formitem

Methods in org.tinygroup.tinysqldsl.formitem with parameters of type Select

Modifier and Type	Method and Description
static SubSelect	SubSelect.subSelect(Select select)
static SubSelect	SubSelect.subSelect(Select select, Alias alias, boolean useBrackets)
static SubSelect	SubSelect.subSelect(Select select, String aliasName, boolean useBrackets)