Uses of Class
org.tinygroup.tinysqldsl.ComplexSelect

Packages that use ComplexSelect

Package	Description
org.tinygroup.jdbctemplatedslsession
org.tinygroup.jdbctemplatedslsession.pageprocess
org.tinygroup.tinysqldsl
org.tinygroup.tinysqldsl.extend

Uses of ComplexSelect in org.tinygroup.jdbctemplatedslsession

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

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

Uses of ComplexSelect in org.tinygroup.jdbctemplatedslsession.pageprocess

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

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

Uses of ComplexSelect in org.tinygroup.tinysqldsl

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

Modifier and Type	Class and Description
class	ComplexSelect<T extends ComplexSelect<T>> 复杂查询

Methods in org.tinygroup.tinysqldsl that return ComplexSelect

Modifier and Type	Method and Description
ComplexSelect	ComplexSelect.copy()
protected ComplexSelect	ComplexSelect.newSelect()
static ComplexSelect	ComplexSelect.setOperation(SetOperationInstanceCallBack instance, Select... selects)
static ComplexSelect	ComplexSelect.union(Select... selects)
static ComplexSelect	ComplexSelect.unionAll(Select... selects)

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

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

Uses of ComplexSelect in org.tinygroup.tinysqldsl.extend

Subclasses of ComplexSelect in org.tinygroup.tinysqldsl.extend

Modifier and Type	Class and Description
class	DB2ComplexSelect db2复杂查询操作对象
class	DerbyComplexSelect sqlserver复杂查询操作对象
class	H2ComplexSelect mysql复杂查询操作对象
class	InformixComplexSelect Informix复杂查询操作对象
class	MysqlComplexSelect mysql复杂查询操作对象
class	OracleComplexSelect oracle复杂查询操作对象
class	SqlServerComplexSelect sqlserver复杂查询操作对象

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

Modifier and Type	Method and Description
protected ComplexSelect	MysqlComplexSelect.newSelect()
protected ComplexSelect	DerbyComplexSelect.newSelect()
protected ComplexSelect	InformixComplexSelect.newSelect()
protected ComplexSelect	OracleComplexSelect.newSelect()
protected ComplexSelect	H2ComplexSelect.newSelect()
protected ComplexSelect	SqlServerComplexSelect.newSelect()