cn.xphsc.jpamapper.core.jdbc

类 SQLBuilder

java.lang.Object

cn.xphsc.jpamapper.core.jdbc.SQLBuilder

public class SQLBuilder
extends Object

从以下版本开始:

1.0.0

作者:

huipei.x

构造器概要

构造器

构造器和说明
SQLBuilder()

方法概要

方法

限定符和类型	方法和说明
SQLBuilder	between(String column, Object from, Object to)
static SQLBuilder	builder()
SQLBuilder	eq(String column, Object value)
SQLBuilder	from(String from)
SQLBuilder	groupBy(String groupBy)
SQLBuilder	gt(String column, Object value)
SQLBuilder	gte(String column, Object value)
SQLBuilder	having(String having)
SQLBuilder	in(String column, Collection<?> value)
SQLBuilder	like(String column, Object value)
SQLBuilder	limit(String limit)
SQLBuilder	lt(String column, Object value)
SQLBuilder	lte(String column, Object value)
SQLBuilder	ne(String column, Object value)
SQLBuilder	notIn(String column, Collection<?> value)
SQLBuilder	notLike(String column, Object value)
SQLBuilder	orderBy(String orderBy)
SQLBuilder	select(String select)
String	sql()
static String	sqlParam(String sqlParam)
SQLBuilder	where(String where)
SQLBuilder	where(String columnOperator, Object value)

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

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

构造器详细资料

SQLBuilder

public SQLBuilder()

方法详细资料

builder

public static SQLBuilder builder()

select

public SQLBuilder select(String select)

参数:

select -

*

column1,column2,...

count(column1),sum(column2),avg(column3),...

user.id,user.name,account.amount,...

from

public SQLBuilder from(String from)

参数:

from -

ts_user

ts_user u left join ts_account a on u.ts_user_id = a.ts_user_id

jpql: TsUser user left join user.tsAccount account

where

public SQLBuilder where(String where)

参数:

where -

null, to reset where

name like '%Jack%'

id in (1,2,3)

exists (select a.id from acount a where a.user_id=user.id)

name is empty

where

public SQLBuilder where(String columnOperator,
               Object value)

参数:

columnOperator -

column1 >=

column2 !=

groupBy

public SQLBuilder groupBy(String groupBy)

having

public SQLBuilder having(String having)

orderBy

public SQLBuilder orderBy(String orderBy)

limit

public SQLBuilder limit(String limit)

参数:

limit -

limit 0,10

eq

public SQLBuilder eq(String column,
            Object value)

ne

public SQLBuilder ne(String column,
            Object value)

like

public SQLBuilder like(String column,
              Object value)

notLike

public SQLBuilder notLike(String column,
                 Object value)

in

public SQLBuilder in(String column,
            Collection<?> value)

notIn

public SQLBuilder notIn(String column,
               Collection<?> value)

gt

public SQLBuilder gt(String column,
            Object value)

gte

public SQLBuilder gte(String column,
             Object value)

lt

public SQLBuilder lt(String column,
            Object value)

lte

public SQLBuilder lte(String column,
             Object value)

between

public SQLBuilder between(String column,
                 Object from,
                 Object to)

sql

public String sql()

sqlParam

public static String sqlParam(String sqlParam)