程序包 jaskell.sql

类 SQL

java.lang.Object

jaskell.sql.SQL

public class SQL
extends Object

构造器概要

构造器

构造器	说明
SQL()

方法概要

修饰符和类型	方法	说明
static Case	_case()
static Case	_case(Directive expr)
static And	and(Directive left, Directive right)
static Predicate	br(Predicate predicate)
static Coalesce	coalesce(Directive... names)
static Coalesce	coalesce(String names)
static Coalesce	coalesce(String... names)
static Count	count()
static Count	count(Name name)
static Count	count(String name)
static Delete	delete()
static Equal	eq(Directive left, Directive right)
static Func	func(String name)
static Func	func(String name, Directive arg)
static Func	func(String name, Directive... args)
static GreateOrEqual	ge(Directive left, Directive right)
static Great	gt(Directive left, Directive right)
static Insert	insert()
static <T> Literal	l(T v)
static LessOrEqual	le(Directive left, Directive right)
static Like	like(Directive left, Directive right)
static Less	lt(Directive left, Directive right)
static Name	n(String name)
static NotEqual	ne(Directive left, Directive right)
static Not	not()
static Not	not(Directive directive)
static Or	or(Directive left, Directive right)
static Parameter	p(int index)
static <T> Parameter	p(int index, Class<T> cls)
static Parameter	p(String key)
static Parameter	p(String placeHolder, int index)
static <T> Parameter	p(String placeHolder, int index, Class<T> cls)
static <T> Parameter	p(String key, Class<T> cls)
static Parameter	p(String placeHolder, String key)
static <T> Parameter	p(String placeHolder, String key, Class<T> cls)
static Quot	q(String name)
static List<Quot>	qs(String... names)
static Select	select()
static Select	select(Directive... names)
static Select	select(String names)
static Select	select(String... names)
static Select	select(List<Directive> names)
static Sum	sum()
static Sum	sum(Name name)
static Sum	sum(String name)
static Literal	text(String content)
static Update	update(Name name)
static Update	update(String name)
static With	with()
static With	with(Name name)
static With	with(String name)

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

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

构造器详细资料

SQL

public SQL()

方法详细资料

select

public static Select select()

select

public static Select select(String names)

select

public static Select select(String... names)

select

public static Select select(Directive... names)

select

public static Select select(List<Directive> names)

insert

public static Insert insert()

update

public static Update update(String name)

update

public static Update update(Name name)

delete

public static Delete delete()

with

public static With with()

with

public static With with(String name)

with

public static With with(Name name)

n

public static Name n(String name)

q

public static Quot q(String name)

qs

public static List<Quot> qs(String... names)

text

public static Literal text(String content)

l

public static <T> Literal l(T v)

br

public static Predicate br(Predicate predicate)

p

public static Parameter p(int index)

p

public static <T> Parameter p(int index,
Class<T> cls)

p

public static Parameter p(String key)

p

public static <T> Parameter p(String key,
Class<T> cls)

p

public static Parameter p(String placeHolder,
int index)

p

public static <T> Parameter p(String placeHolder,
int index,
Class<T> cls)

p

public static Parameter p(String placeHolder,
String key)

p

public static <T> Parameter p(String placeHolder,
String key,
Class<T> cls)

and

public static And and(Directive left,
Directive right)

or

public static Or or(Directive left,
Directive right)

eq

public static Equal eq(Directive left,
Directive right)

gt

public static Great gt(Directive left,
Directive right)

lt

public static Less lt(Directive left,
Directive right)

ge

public static GreateOrEqual ge(Directive left,
Directive right)

le

public static LessOrEqual le(Directive left,
Directive right)

ne

public static NotEqual ne(Directive left,
Directive right)

like

public static Like like(Directive left,
Directive right)

not

public static Not not(Directive directive)

not

public static Not not()

func

public static Func func(String name)

func

public static Func func(String name,
Directive arg)

func

public static Func func(String name,
Directive... args)

count

public static Count count()

count

public static Count count(String name)

count

public static Count count(Name name)

sum

public static Sum sum()

sum

public static Sum sum(String name)

sum

public static Sum sum(Name name)

_case

public static Case _case()

_case

public static Case _case(Directive expr)

coalesce

public static Coalesce coalesce(String names)

coalesce

public static Coalesce coalesce(String... names)

coalesce

public static Coalesce coalesce(Directive... names)