com.ajaxjs.sqlman.crud

类 Query

java.lang.Object

com.ajaxjs.sqlman.crud.BaseAction

com.ajaxjs.sqlman.crud.Query

public class Query
extends BaseAction

Do query on the database.

字段概要

从类继承的字段 com.ajaxjs.sqlman.crud.BaseAction

startTime

构造器概要

构造器

构造器和说明
Query(Action action) Do the query by an action.

方法概要

限定符和类型	方法和说明
List<Map<String,Object>>	list()
<T> List<T>	list(Class<T> beanClz)
Map<String,Object>	one()
<T> T	one(Class<T> beanClz)
<T> T	oneValue(Class<T> clz)
PageResult<Map<String,Object>>	pageByPageNo(javax.servlet.http.HttpServletRequest req) Do the pagination by pageNo/pageSize.
<T> PageResult<T>	pageByPageNo(javax.servlet.http.HttpServletRequest req, Class<T> beanClz) Do the pagination by pageNo/pageSize.
PageResult<Map<String,Object>>	pageByPageNo(Integer pageNo, Integer pageSize) Do the pagination by pageNo/pageSize.
<T> PageResult<T>	pageByPageNo(Integer pageNo, Integer pageSize, Class<T> beanClz) Do the pagination by pageNo/pageSize.
PageResult<Map<String,Object>>	pageByStartLimit(javax.servlet.http.HttpServletRequest req) Do the pagination by start/limit.
<T> PageResult<T>	pageByStartLimit(javax.servlet.http.HttpServletRequest req, Class<T> beanClz) Do the pagination by start/limit.
PageResult<Map<String,Object>>	pageByStartLimit(Integer start, Integer limit) Do the pagination by start/limit.
<T> PageResult<T>	pageByStartLimit(Integer start, Integer limit, Class<T> beanClz) Do the pagination by start/limit.
protected <T> T	query(ResultSetProcessor<T> processor) Query by any SQL.

从类继承的方法 com.ajaxjs.sqlman.crud.BaseAction

getResultBean, getResultMap

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

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

构造器详细资料

Query

public Query(Action action)

Do the query by an action.

参数:

action - an action object with input Sql, data and config.

方法详细资料

query

protected <T> T query(ResultSetProcessor<T> processor)

Query by any SQL. This is the low-level API.

类型参数:

T - Map or bean.

参数:

processor - How to transform the result set to a target entity.

返回:

The result object.

oneValue

public <T> T oneValue(Class<T> clz)

one

public Map<String,Object> one()

one

public <T> T one(Class<T> beanClz)

list

public List<Map<String,Object>> list()

list

public <T> List<T> list(Class<T> beanClz)

pageByStartLimit

public <T> PageResult<T> pageByStartLimit(Integer start,
                                          Integer limit,
                                          Class<T> beanClz)

Do the pagination by start/limit.

参数:

start - The start position

limit - The limit of records, equals to page size

返回:

The page result in Java Bean format.

pageByStartLimit

public PageResult<Map<String,Object>> pageByStartLimit(Integer start,
                                                       Integer limit)

Do the pagination by start/limit.

参数:

start - The start position

limit - The limit of records, equals to page size

返回:

The page result in Map format.

pageByStartLimit

public <T> PageResult<T> pageByStartLimit(javax.servlet.http.HttpServletRequest req,
                                          Class<T> beanClz)

Do the pagination by start/limit. The parameters are from the request automatically.

参数:

req - The request object.

beanClz - The type of result object, null for Map.

返回:

The page result.

pageByStartLimit

public PageResult<Map<String,Object>> pageByStartLimit(javax.servlet.http.HttpServletRequest req)

Do the pagination by start/limit. The parameters are from the request automatically.

参数:

req - The request object.

返回:

The page result.

pageByPageNo

public <T> PageResult<T> pageByPageNo(Integer pageNo,
                                      Integer pageSize,
                                      Class<T> beanClz)

Do the pagination by pageNo/pageSize.

参数:

pageNo - The number of pages.

pageSize - The size of every page.

返回:

The page result in Java Bean format.

pageByPageNo

public PageResult<Map<String,Object>> pageByPageNo(Integer pageNo,
                                                   Integer pageSize)

Do the pagination by pageNo/pageSize.

参数:

pageNo - The number of pages.

pageSize - The size of every page.

返回:

The page result in Map format.

pageByPageNo

public <T> PageResult<T> pageByPageNo(javax.servlet.http.HttpServletRequest req,
                                      Class<T> beanClz)

Do the pagination by pageNo/pageSize. The parameters are from the request automatically.

参数:

req - The request object.

beanClz - The type of result object, null for Map.

返回:

The page result.

pageByPageNo

public PageResult<Map<String,Object>> pageByPageNo(javax.servlet.http.HttpServletRequest req)

Do the pagination by pageNo/pageSize. The parameters are from the request automatically.

参数:

req - The request object.

返回:

The page result.