程序包 com.sh.wf.module.helper

类 SqlSelectBuilder

java.lang.Object

com.sh.wf.module.helper.SqlSelectBuilder

public class SqlSelectBuilder
extends Object

Description: SELECT语句生成类 SqlSelectBuilder ssb = new SqlSelectBuilder(dc) ; ssb.select("*").select("id") .from("lms_library_info a") .innerJoin("sys_dept b on a.dept_id=b.dept_id") .where("id=?","1") .whereLikeLeft("name like ?","abc") .groupby("state") .having("id=1") .orderby("id desc") ;

Title:首亨软件 - 聚天平台

字段概要

字段

修饰符和类型	字段	说明
protected static org.apache.logging.log4j.Logger	_log4j
protected DataCenter	dc

构造器概要

构造器

构造器	说明
SqlSelectBuilder()
SqlSelectBuilder(DataCenter dc)

方法概要

修饰符和类型	方法	说明
SqlSelectBuilder	and()
SqlSelectBuilder	appendSql(String exp)
SqlSelectBuilder	appendSql(String exp, Object value)
SqlSelectBuilder	from(String tableName)	查询表
DataPages	getDataPages()	生成分页对象
List<Object>	getObjList()
String	getSql()
SqlSelectBuilder	groupby(String exp)
SqlSelectBuilder	groupby(String exp, Object value)
SqlSelectBuilder	having(String exp)
SqlSelectBuilder	having(String exp, Object value)
SqlSelectBuilder	innerJoin(String exp)	INNER JOIN（内连接）
SqlSelectBuilder	leftJoin(String exp)	LEFT JOIN（左连接）
SqlSelectBuilder	limit(int rowCount)
SqlSelectBuilder	limit(int rowCount, int offset)	分页
SqlSelectBuilder	or()
SqlSelectBuilder	orderby(String exp)
SqlSelectBuilder	orderby(String exp, Object value)
SqlSelectBuilder	outerJoin(String exp)	OUTER JOIN（外连接）
SqlSelectBuilder	printLog(boolean logEnable)
SqlSelectBuilder	printLog(org.apache.logging.log4j.Logger log4j, boolean logEnable)
SqlSelectBuilder	reset()	重置
Datastore	retrieve()
Datastore	retrieve(boolean isCache)	查询数据集
SqlSelectBuilder	rightJoin(String exp)	RIGHT JOIN（右连接）
SqlSelectBuilder	select(String col)
SqlSelectBuilder	select(String col, Object value)
SqlSelectBuilder	where(String condition)
SqlSelectBuilder	where(String condition, Object value)	条件
SqlSelectBuilder	whereLike(String condition, String value)	生成Like条件
SqlSelectBuilder	whereLikeLeft(String condition, String value)	生成Like条件
SqlSelectBuilder	whereLikeRight(String condition, String value)	生成Like条件

从类继承的方法 java.lang.Object

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

字段详细资料

_log4j

protected static org.apache.logging.log4j.Logger _log4j

dc

protected DataCenter dc

构造器详细资料

SqlSelectBuilder

public SqlSelectBuilder()

SqlSelectBuilder

public SqlSelectBuilder(DataCenter dc)

方法详细资料

reset

public SqlSelectBuilder reset()

重置

返回:

select

public SqlSelectBuilder select(String col)

select

public SqlSelectBuilder select(String col,
 Object value)

appendSql

public SqlSelectBuilder appendSql(String exp)

appendSql

public SqlSelectBuilder appendSql(String exp,
 Object value)

from

public SqlSelectBuilder from(String tableName)

查询表

参数:

tableName - sys_info_user a

返回:

innerJoin

public SqlSelectBuilder innerJoin(String exp)

INNER JOIN（内连接）

参数:

exp - sys_info_dept b on a.dept_id=b.dept_id

返回:

leftJoin

public SqlSelectBuilder leftJoin(String exp)

LEFT JOIN（左连接）

参数:

exp - sys_info_dept b on a.dept_id=b.dept_id

返回:

rightJoin

public SqlSelectBuilder rightJoin(String exp)

RIGHT JOIN（右连接）

参数:

exp - sys_info_dept b on a.dept_id=b.dept_id

返回:

outerJoin

public SqlSelectBuilder outerJoin(String exp)

OUTER JOIN（外连接）

参数:

exp - sys_info_dept b on a.dept_id=b.dept_id

返回:

where

public SqlSelectBuilder where(String condition,
 Object value)

条件

参数:

condition -

value -

返回:

where

public SqlSelectBuilder where(String condition)

whereLike

public SqlSelectBuilder whereLike(String condition,
 String value)

生成Like条件

参数:

condition -

value - 值将转化为：%value%

返回:

whereLikeLeft

public SqlSelectBuilder whereLikeLeft(String condition,
 String value)

生成Like条件

参数:

condition -

value - 值将转化为：%value

返回:

whereLikeRight

public SqlSelectBuilder whereLikeRight(String condition,
 String value)

生成Like条件

参数:

condition -

value - 值将转化为：value%

返回:

or

public SqlSelectBuilder or()

and

public SqlSelectBuilder and()

groupby

public SqlSelectBuilder groupby(String exp)

groupby

public SqlSelectBuilder groupby(String exp,
 Object value)

having

public SqlSelectBuilder having(String exp)

having

public SqlSelectBuilder having(String exp,
 Object value)

orderby

public SqlSelectBuilder orderby(String exp)

orderby

public SqlSelectBuilder orderby(String exp,
 Object value)

limit

public SqlSelectBuilder limit(int rowCount)

limit

public SqlSelectBuilder limit(int rowCount,
 int offset)

分页

参数:

rowCount -

offset -

返回:

retrieve

public Datastore retrieve()

retrieve

public Datastore retrieve(boolean isCache)

查询数据集

参数:

isCache -

返回:

getDataPages

public DataPages getDataPages()

生成分页对象

返回:

printLog

public SqlSelectBuilder printLog(boolean logEnable)

printLog

public SqlSelectBuilder printLog(org.apache.logging.log4j.Logger log4j,
 boolean logEnable)

getSql

public String getSql()

getObjList

public List<Object> getObjList()