com.yishuifengxiao.common.jdbc.sql.impl

Class SimpleQueryBuilder

java.lang.Object

com.yishuifengxiao.common.jdbc.sql.impl.SimpleQueryBuilder

All Implemented Interfaces:

QueryBuilder

public class SimpleQueryBuilder
extends Object
implements QueryBuilder

系统查询条件生成器

Since:

1.0.0

Version:

1.0.0

Author:

yishui

Constructor Summary

Constructors

Constructor and Description
SimpleQueryBuilder()

Method Summary

Modifier and Type	Method and Description
<T> SqlData	countAll(FieldExtractor fieldExtractor, Class<T> clazz, List<Condition> conditions) 生成一个根据条件查询记录数量的SQL执行对象
<T> SqlData	countAll(FieldExtractor fieldExtractor, T t) 生成一个根据条件查询记录数量的SQL执行对象
<T> SqlData	findAll(FieldExtractor fieldExtractor, Class<T> clazz, Order order, List<Condition> conditions) 生成一个根据条件查询全部数据的SQL执行对象
<T> SqlData	findAll(FieldExtractor fieldExtractor, T t, Order order) 生成一个根据条件查询全部数据的SQL执行对象
<T> SqlData	findByPrimaryKey(FieldExtractor fieldExtractor, Class<T> clazz, Object primaryKey) 生成一个根据主键查询的SQL执行对象
<T> SqlData	findPage(FieldExtractor fieldExtractor, Class<T> clazz, Order order, List<Condition> conditions, int pageSize, int pageNum) 生成一个根据条件分页查询数据的SQL执行对象
<T> SqlData	findPage(FieldExtractor fieldExtractor, T t, Order order, int pageSize, int pageNum) 生成一个根据条件分页查询数据的SQL执行对象

Methods inherited from class java.lang.Object

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

Constructor Detail

SimpleQueryBuilder

public SimpleQueryBuilder()

Method Detail

findByPrimaryKey

public <T> SqlData findByPrimaryKey(FieldExtractor fieldExtractor,
                                    Class<T> clazz,
                                    Object primaryKey)

生成一个根据主键查询的SQL执行对象

Specified by:

findByPrimaryKey in interface QueryBuilder

Type Parameters:

T - 操作对象的类型

Parameters:

fieldExtractor - 属性提取器

clazz - 操作对象

primaryKey - 主键值

Returns:

SQL执行对象

findAll

public <T> SqlData findAll(FieldExtractor fieldExtractor,
                           T t,
                           Order order)

生成一个根据条件查询全部数据的SQL执行对象

Specified by:

findAll in interface QueryBuilder

Type Parameters:

T - 操作对象的类型

Parameters:

fieldExtractor - 属性提取器

t - 查询条件

order - 排序属性

Returns:

SQL执行对象

findAll

public <T> SqlData findAll(FieldExtractor fieldExtractor,
                           Class<T> clazz,
                           Order order,
                           List<Condition> conditions)

生成一个根据条件查询全部数据的SQL执行对象

Specified by:

findAll in interface QueryBuilder

Type Parameters:

T - 操作对象的类型

Parameters:

fieldExtractor - 属性提取器

clazz - 操作对象

order - 排序属性

conditions - 筛选条件

Returns:

SQL执行对象

findPage

public <T> SqlData findPage(FieldExtractor fieldExtractor,
                            T t,
                            Order order,
                            int pageSize,
                            int pageNum)

生成一个根据条件分页查询数据的SQL执行对象

Specified by:

findPage in interface QueryBuilder

Type Parameters:

T - 操作对象的类型

Parameters:

fieldExtractor - 属性提取器

t - 查询条件

order - 排序属性

pageSize - 分页大小

pageNum - 当前页页码

Returns:

SQL执行对象

findPage

public <T> SqlData findPage(FieldExtractor fieldExtractor,
                            Class<T> clazz,
                            Order order,
                            List<Condition> conditions,
                            int pageSize,
                            int pageNum)

生成一个根据条件分页查询数据的SQL执行对象

Specified by:

findPage in interface QueryBuilder

Type Parameters:

T - 操作对象的类型

Parameters:

fieldExtractor - 属性提取器

clazz - 操作对象

order - 排序属性

conditions - 筛选条件

pageSize - 分页大小

pageNum - 当前页页码

Returns:

SQL执行对象

countAll

public <T> SqlData countAll(FieldExtractor fieldExtractor,
                            T t)

生成一个根据条件查询记录数量的SQL执行对象

Specified by:

countAll in interface QueryBuilder

Type Parameters:

T - 操作对象的类型

Parameters:

fieldExtractor - 属性提取器

t - 查询条件

Returns:

SQL执行对象

countAll

public <T> SqlData countAll(FieldExtractor fieldExtractor,
                            Class<T> clazz,
                            List<Condition> conditions)

生成一个根据条件查询记录数量的SQL执行对象

Specified by:

countAll in interface QueryBuilder

Type Parameters:

T - 操作对象的类型

Parameters:

fieldExtractor - 属性提取器

clazz - 操作对象

conditions - 筛选条件

Returns:

SQL执行对象