org.tinygroup.tinysqldsl.extend

Class MysqlComplexSelect

java.lang.Object

org.tinygroup.tinysqldsl.base.StatementSqlBuilder

org.tinygroup.tinysqldsl.ComplexSelect<MysqlComplexSelect>

org.tinygroup.tinysqldsl.extend.MysqlComplexSelect

All Implemented Interfaces:

Statement

public class MysqlComplexSelect
extends ComplexSelect<MysqlComplexSelect>

mysql复杂查询操作对象

Author:

renhui

Field Summary

Fields inherited from class org.tinygroup.tinysqldsl.ComplexSelect

operationList

Fields inherited from class org.tinygroup.tinysqldsl.base.StatementSqlBuilder

stringBuilder

Constructor Summary

Constructors

Constructor and Description
MysqlComplexSelect()

Method Summary

Modifier and Type	Method and Description
MysqlComplexSelect	limit(int start, int limit)
MysqlComplexSelect	limit(Limit limit) 生成的sql语句 start和limit用？代替
protected ComplexSelect	newSelect()
static MysqlComplexSelect	setOperation(SetOperationInstanceCallBack instance, Select... selects)
static MysqlComplexSelect	union(Select... selects)
static MysqlComplexSelect	unionAll(Select... selects)

Methods inherited from class org.tinygroup.tinysqldsl.ComplexSelect

copy, getId, getOperationList, id, orderBy, parserStatementBody, setOperationList, toString

Methods inherited from class org.tinygroup.tinysqldsl.base.StatementSqlBuilder

addParamName, addParamValue, and, appendSql, build, deparseFetch, deparseJoin, deparseLimit, deparseOffset, deparseOrderBy, deparseOrderBy, getLimitString, getNamedList, getStringBuilder, getValues, isNamedSql, isUseBracketsInExprList, mapValue, newSql, or, parsedSql, reset, setUseBracketsInExprList, sql, visitBinaryExpression, visitOldOracleJoinBinaryExpression

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.tinygroup.tinysqldsl.Statement

getValues, sql

Constructor Detail

MysqlComplexSelect

public MysqlComplexSelect()

Method Detail

union

public static MysqlComplexSelect union(Select... selects)

unionAll

public static MysqlComplexSelect unionAll(Select... selects)

setOperation

public static MysqlComplexSelect setOperation(SetOperationInstanceCallBack instance,
                                              Select... selects)

limit

public MysqlComplexSelect limit(int start,
                                int limit)

limit

public MysqlComplexSelect limit(Limit limit)

生成的sql语句 start和limit用？代替

Parameters:

limit -

Returns:

newSelect

protected ComplexSelect newSelect()

Overrides:

newSelect in class ComplexSelect<MysqlComplexSelect>