com.hecloud.runtime.database.builder

类 SelectBuilder

java.lang.Object

com.hecloud.runtime.database.builder.SelectBuilder

public class SelectBuilder
extends Object

作者:

LoveInBJ

构造器概要

构造器

构造器和说明
SelectBuilder()

方法概要

限定符和类型	方法和说明
SelectBuilder	and(String condition)
SelectBuilder	andIn(String column, Collection conditions)
SelectBuilder	from(Class... classes)
SelectBuilder	from(Class clazz, String alias)
SelectBuilder	leftJoin(Class clazz, String alias)
SelectBuilder	leftJoin(String clazz, String alias)
SelectBuilder	limit(int position, int offset)
static void	main(String[] args)
SelectBuilder	on(String condition)
SelectBuilder	or(String condition)
SelectBuilder	orIn(String column, Collection conditions)
SelectBuilder	page(Page page)
SelectBuilder	page(Page page, String alias)
SelectBuilder	pageLimit(int pageNum, int pageSize)
SelectBuilder	param(List<Param> params, String alias)
SelectBuilder	select(String... fields)
SelectBuilder	sort(Map<String,String> sorter)
SelectBuilder	sort(Map<String,String> sorter, String alias)
String	sql()
SelectBuilder	where(String condition)
SelectBuilder	where(String column, Object data)
SelectBuilder	where(String column, Sign sign, Object data)
SelectBuilder	whereIn(String column, Collection conditions)

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

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

构造器详细资料

SelectBuilder

public SelectBuilder()

方法详细资料

select

public SelectBuilder select(String... fields)

from

public SelectBuilder from(Class... classes)

from

public SelectBuilder from(Class clazz,
                          String alias)

leftJoin

public SelectBuilder leftJoin(Class clazz,
                              String alias)

leftJoin

public SelectBuilder leftJoin(String clazz,
                              String alias)

on

public SelectBuilder on(String condition)

where

public SelectBuilder where(String condition)

where

public SelectBuilder where(String column,
                           Object data)

where

public SelectBuilder where(String column,
                           Sign sign,
                           Object data)

whereIn

public SelectBuilder whereIn(String column,
                             Collection conditions)

and

public SelectBuilder and(String condition)

andIn

public SelectBuilder andIn(String column,
                           Collection conditions)

or

public SelectBuilder or(String condition)

orIn

public SelectBuilder orIn(String column,
                          Collection conditions)

page

public SelectBuilder page(Page page)

page

public SelectBuilder page(Page page,
                          String alias)

param

public SelectBuilder param(List<Param> params,
                           String alias)

sort

public SelectBuilder sort(Map<String,String> sorter)

limit

public SelectBuilder limit(int position,
                           int offset)

pageLimit

public SelectBuilder pageLimit(int pageNum,
                               int pageSize)

main

public static void main(String[] args)

sort

public SelectBuilder sort(Map<String,String> sorter,
                          String alias)

sql

public String sql()