public class SelectBuilder extends Object
| 构造器和说明 |
|---|
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 |
on(String condition) |
SelectBuilder |
or(String condition) |
SelectBuilder |
orIn(String column,
Collection conditions) |
SelectBuilder |
page(Page page) |
SelectBuilder |
param(List<Param> params) |
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) |
public SelectBuilder select(String... fields)
public SelectBuilder from(Class... classes)
public SelectBuilder from(Class clazz, String alias)
public SelectBuilder leftJoin(Class clazz, String alias)
public SelectBuilder on(String condition)
public SelectBuilder where(String condition)
public SelectBuilder where(String column, Object data)
public SelectBuilder where(String column, Sign sign, Object data)
public SelectBuilder whereIn(String column, Collection conditions)
public SelectBuilder and(String condition)
public SelectBuilder andIn(String column, Collection conditions)
public SelectBuilder or(String condition)
public SelectBuilder orIn(String column, Collection conditions)
public SelectBuilder page(Page page)
public SelectBuilder param(List<Param> params)
public SelectBuilder sort(Map<String,String> sorter)
public SelectBuilder sort(Map<String,String> sorter, String alias)
public String sql()
Copyright © 2019. All rights reserved.