Package cc.carm.lib.easysql.api.builder

Interface TableQueryBuilder

All Superinterfaces:

ConditionalBuilder<TableQueryBuilder,PreparedQueryAction>, SQLBuilder

public interface TableQueryBuilder
extends ConditionalBuilder<TableQueryBuilder,PreparedQueryAction>

Method Summary

Modifier and Type	Method	Description
@NotNull java.lang.String	getTableName()
TableQueryBuilder	orderBy(@NotNull java.lang.String columnName, boolean asc)	对结果进行排序
TableQueryBuilder	selectColumns(@NotNull java.lang.String... columnNames)	选定用于查询的列名
TableQueryBuilder	setPageLimit(int start, int end)	限制查询条数，用于分页查询。

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

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

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

getManager

Method Detail

getTableName

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

selectColumns

TableQueryBuilder selectColumns(@NotNull
                                @NotNull java.lang.String... columnNames)

选定用于查询的列名

Parameters:

columnNames - 列名

Returns:

TableQueryBuilder

orderBy

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

对结果进行排序

Parameters:

columnName - 排序使用的列名

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

Returns:

TableQueryBuilder

setPageLimit

TableQueryBuilder setPageLimit(int start,
                               int end)

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

Parameters:

start - 开始数

end - 结束条数

Returns:

TableQueryBuilder

Since:

0.2.6