tech.ibit.mybatis.sqlbuilder.sql

Interface QuerySql<T>

All Superinterfaces:

ColumnSupport<QuerySql<T>>, DistinctSupport<QuerySql<T>>, FromSupport<QuerySql<T>>, GroupBySupport<QuerySql<T>>, HavingSupport<QuerySql<T>>, JoinOnSupport<QuerySql<T>>, LimitSupport<QuerySql<T>>, OrderBySupport<QuerySql<T>>, PrepareStatementSupport, WhereSupport<QuerySql<T>>

All Known Implementing Classes:

QuerySqlImpl

public interface QuerySql<T>
extends ColumnSupport<QuerySql<T>>, DistinctSupport<QuerySql<T>>, FromSupport<QuerySql<T>>, GroupBySupport<QuerySql<T>>, HavingSupport<QuerySql<T>>, JoinOnSupport<QuerySql<T>>, LimitSupport<QuerySql<T>>, OrderBySupport<QuerySql<T>>, WhereSupport<QuerySql<T>>, PrepareStatementSupport

定义搜索接口

Version:

2.0

Author:

IBIT程序猿

Method Summary

Modifier and Type	Method and Description
QuerySql<T>	columnDefaultPo() Deprecated.
List<T>	executeQuery() 查询
<P> List<P>	executeQuery(Class<P> clazz) 查询
<V> List<V>	executeQueryDefault() 查询基本类型
<V> Page<V>	executeQueryDefaultPage() 查询基本类型（包含分页信息）
T	executeQueryOne() 查询单个对象
<P> P	executeQueryOne(Class<P> clazz) 查询单个对象
Page<T>	executeQueryPage() 查询（包含分页信息）
<P> Page<P>	executeQueryPage(Class<P> clazz) 查询（包含分页信息）
QuerySql<T>	fromDefault() Deprecated.
CountSql	toCountSql() 转换为 CountSql

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.ColumnSupport

column, column, columnPo

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.DistinctSupport

distinct, distinct

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.FromSupport

from, from

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.GroupBySupport

groupBy, groupBy

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.HavingSupport

andHaving, andHaving, having, having, orHaving, orHaving

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.JoinOnSupport

complexFullJoinOn, complexInnerJoinOn, complexLeftJoinOn, complexRightJoinOn, fullJoinOn, innerJoinOn, joinOn, joinOn, joinOn, leftJoinOn, rightJoinOn

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.LimitSupport

limit, limit

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.OrderBySupport

orderBy, orderBy, orderBy, orderBy

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.WhereSupport

andWhere, andWhere, orWhere, orWhere, where, where

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.PrepareStatementSupport

getPrepareStatement

Method Detail

toCountSql

CountSql toCountSql()

转换为 CountSql

Returns:

CountSql对象

executeQueryPage

Page<T> executeQueryPage()

查询（包含分页信息）

Returns:

查询结果

executeQueryPage

<P> Page<P> executeQueryPage(Class<P> clazz)

查询（包含分页信息）

Type Parameters:

P - 返回类型模板

Parameters:

clazz - 返回类型

Returns:

查询结果

executeQuery

List<T> executeQuery()

查询

Returns:

结果列表

executeQuery

<P> List<P> executeQuery(Class<P> clazz)

查询

Type Parameters:

P - 返回类型模板

Parameters:

clazz - 返回类型

Returns:

结果列表

executeQueryOne

T executeQueryOne()

查询单个对象

Returns:

结果对象

executeQueryOne

<P> P executeQueryOne(Class<P> clazz)

查询单个对象

Type Parameters:

P - 返回类型模板

Parameters:

clazz - 返回类型

Returns:

结果对象

executeQueryDefaultPage

<V> Page<V> executeQueryDefaultPage()

查询基本类型（包含分页信息）

Type Parameters:

V - 基本类型

Returns:

结果列表

executeQueryDefault

<V> List<V> executeQueryDefault()

查询基本类型

Type Parameters:

V - 基本类型

Returns:

结果列表

columnDefaultPo

@Deprecated
QuerySql<T> columnDefaultPo()

Deprecated.

定义搜索列（从mapper getPoClazz中获取）

Returns:

sql对象本身

fromDefault

@Deprecated
QuerySql<T> fromDefault()

Deprecated.

定义搜索定义搜索表（从 mapper getDefaultTable 中获取）

Returns:

sql对象本身