Package cc.carm.lib.easysql.builder.impl

Class TableQueryBuilderImpl

java.lang.Object

cc.carm.lib.easysql.builder.AbstractSQLBuilder

cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder<TableQueryBuilder,PreparedQueryAction>

cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl

All Implemented Interfaces:

ConditionalBuilder<TableQueryBuilder,PreparedQueryAction>, TableQueryBuilder, SQLBuilder

public class TableQueryBuilderImpl
extends AbstractConditionalBuilder<TableQueryBuilder,PreparedQueryAction>
implements TableQueryBuilder

Constructor Summary

Constructors

Constructor	Description
TableQueryBuilderImpl(@NotNull SQLManagerImpl manager, @NotNull java.lang.String tableName)

Method Summary

Modifier and Type	Method	Description
PreparedQueryActionImpl	build()	将现有条件构建完整的SQL语句用于执行。
@NotNull java.lang.String	getTableName()
protected TableQueryBuilderImpl	getThis()
TableQueryBuilder	orderBy(@NotNull java.lang.String columnName, boolean asc)	对结果进行排序
TableQueryBuilderImpl	selectColumns(@NotNull java.lang.String... columnNames)	选定用于查询的列名
TableQueryBuilder	setPageLimit(int start, int end)	限制查询条数，用于分页查询。

Methods inherited from class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder

addCondition, addCondition, addCondition, addNotNullCondition, addTimeCondition, buildConditionSQL, buildLimitSQL, getConditionParams, hasConditionParams, hasConditions, setConditions, setConditions, setLimit

Methods inherited from class cc.carm.lib.easysql.builder.AbstractSQLBuilder

getManager

Methods inherited from class java.lang.Object

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

Methods inherited from interface cc.carm.lib.easysql.api.builder.ConditionalBuilder

addCondition, addCondition, addCondition, addCondition, addNotNullCondition, addTimeCondition, addTimeCondition, setConditions, setConditions, setLimit

Methods inherited from interface cc.carm.lib.easysql.api.SQLBuilder

getManager

Constructor Detail

TableQueryBuilderImpl

public TableQueryBuilderImpl(@NotNull
                             @NotNull SQLManagerImpl manager,
                             @NotNull
                             @NotNull java.lang.String tableName)

Method Detail

build

public PreparedQueryActionImpl build()

Description copied from interface: ConditionalBuilder

将现有条件构建完整的SQL语句用于执行。

Specified by:

build in interface ConditionalBuilder<TableQueryBuilder,PreparedQueryAction>

Returns:

SQLAction

getTableName

@NotNull
public @NotNull java.lang.String getTableName()

Specified by:

getTableName in interface TableQueryBuilder

selectColumns

public TableQueryBuilderImpl selectColumns(@NotNull
                                           @NotNull java.lang.String... columnNames)

Description copied from interface: TableQueryBuilder

选定用于查询的列名

Specified by:

selectColumns in interface TableQueryBuilder

Parameters:

columnNames - 列名

Returns:

TableQueryBuilder

orderBy

public TableQueryBuilder orderBy(@NotNull
                                 @NotNull java.lang.String columnName,
                                 boolean asc)

Description copied from interface: TableQueryBuilder

对结果进行排序

Specified by:

orderBy in interface TableQueryBuilder

Parameters:

columnName - 排序使用的列名

asc - 是否为正序排序 (为false则倒序排序)

Returns:

TableQueryBuilder

setPageLimit

public TableQueryBuilder setPageLimit(int start,
                                      int end)

Description copied from interface: TableQueryBuilder

限制查询条数，用于分页查询。

Specified by:

setPageLimit in interface TableQueryBuilder

Parameters:

start - 开始数

end - 结束条数

Returns:

TableQueryBuilder

getThis

protected TableQueryBuilderImpl getThis()

Specified by:

getThis in class AbstractConditionalBuilder<TableQueryBuilder,PreparedQueryAction>