com.yishuifengxiao.common.jdbc.sql.impl

Class SimpleConditionBuilder

java.lang.Object

com.yishuifengxiao.common.jdbc.sql.impl.SimpleConditionBuilder

All Implemented Interfaces:

ConditionBuilder

public class SimpleConditionBuilder
extends Object
implements ConditionBuilder

系统筛选条件生成器

Since:

1.0.0

Version:

1.0.0

Author:

yishui

Constructor Summary

Constructors

Constructor and Description
SimpleConditionBuilder()

Method Summary

Modifier and Type	Method and Description
<T> SqlData	build(Class<T> clazz, FieldExtractor fieldExtractor, boolean selective, List<Condition> conditions) 根据筛选条件生成SQL执行对象
<T> SqlData	build(FieldExtractor fieldExtractor, T t, boolean selective) 根据数据生成适用于筛选条件部分的SQL执行对象
StringBuilder	createLimit(int pageSize, int pageNum) 根据数据生成一个适用于分页的语句片段
<T> StringBuilder	createOrder(Class<T> clazz, FieldExtractor fieldExtractor, Order order) 生成适用于排序条件部分的SQL语句片段
StringBuilder	creatResult(List<FieldValue> list) 根据条件生成适用于查询结果部分的SQL片段

Methods inherited from class java.lang.Object

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

Constructor Detail

SimpleConditionBuilder

public SimpleConditionBuilder()

Method Detail

build

public <T> SqlData build(Class<T> clazz,
                         FieldExtractor fieldExtractor,
                         boolean selective,
                         List<Condition> conditions)

根据筛选条件生成SQL执行对象

Specified by:

build in interface ConditionBuilder

Type Parameters:

T - 待操作的对象的类型

Parameters:

clazz - 待操作的对象

fieldExtractor - 属性提取器

selective - 是否为可选属性方式

conditions - 筛选条件

Returns:

SQL执行对象

build

public <T> SqlData build(FieldExtractor fieldExtractor,
                         T t,
                         boolean selective)

根据数据生成适用于筛选条件部分的SQL执行对象

Specified by:

build in interface ConditionBuilder

Type Parameters:

T - 数据的类型

Parameters:

fieldExtractor - 属性提取器

t - 数据

selective - 是否为可选属性方式

Returns:

适用于筛选条件部分的SQL执行对象

createLimit

public StringBuilder createLimit(int pageSize,
                                 int pageNum)

根据数据生成一个适用于分页的语句片段

Specified by:

createLimit in interface ConditionBuilder

Parameters:

pageSize - 分页大小

pageNum - 当前页页码

Returns:

适用于分页的语句片段

createOrder

public <T> StringBuilder createOrder(Class<T> clazz,
                                     FieldExtractor fieldExtractor,
                                     Order order)

生成适用于排序条件部分的SQL语句片段

Specified by:

createOrder in interface ConditionBuilder

Type Parameters:

T - 数据的类型

Parameters:

clazz - 操作的对象

fieldExtractor - 属性提取器

order - 排序条件

Returns:

适用于排序条件部分的SQL语句片段

creatResult

public StringBuilder creatResult(List<FieldValue> list)

根据条件生成适用于查询结果部分的SQL片段

Specified by:

creatResult in interface ConditionBuilder

Parameters:

list - POJO对象所有的属性

Returns:

适用于查询结果部分的SQL片段