org.tinygroup.tinydb.operator

Interface DbSqlOperator<K>

All Known Subinterfaces:

DBOperator<K>

All Known Implementing Classes:

BeanDBSqlOperator, BeanDBSqlQueryOperator, BeanStringOperator, GenericDbOperator

public interface DbSqlOperator<K>

DB相关的批量操作

Author:

luoguo

Method Summary

Modifier and Type	Method and Description
int	account(Bean bean) 根据bean对象查询该bean对象的记录数
int	account(String sql, List<Object> parameters)
int	account(String sql, Map<String,Object> parameters)
int	account(String sql, Object... parameters)
int	execute(String sql, List<Object> parameters)
int	execute(String sql, Map<String,Object> parameters) 执行带参数的sql语句
int	execute(String sql, Object... parameters) 执行带参数的sql语句
Bean[]	getBeans(Bean bean, int start, int limit) 分页查询bean
Bean[]	getBeans(String sql)
Bean[]	getBeans(String sql, List<Object> parameters)
Bean[]	getBeans(String sql, Map<String,Object> parameters)
Bean[]	getBeans(String sql, Object... parameters)
Bean[]	getCursorPageBeans(String sql, int start, int limit)
Bean[]	getCursorPageBeans(String sql, int start, int limit, List<Object> parameters)
Bean[]	getCursorPageBeans(String sql, int start, int limit, Map<String,Object> parameters)
Bean[]	getCursorPageBeans(String sql, int start, int limit, Object... parameters)
Bean[]	getDialectPageBeans(String sql, int start, int limit)
Bean[]	getDialectPageBeans(String sql, int start, int limit, List<Object> parameters)
Bean[]	getDialectPageBeans(String sql, int start, int limit, Map<String,Object> parameters)
Bean[]	getDialectPageBeans(String sql, int start, int limit, Object... parameters)
Bean[]	getPageBeans(String sql, int start, int limit)
Bean[]	getPageBeans(String sql, int start, int limit, List<Object> parameters)
Bean[]	getPageBeans(String sql, int start, int limit, Map<String,Object> parameters)
Bean[]	getPageBeans(String sql, int start, int limit, Object... parameters)
Pager	getPager(Bean bean, int start, int limit) 分页查询bean
Pager	getPager(String sql, int start, int limit)
Pager	getPager(String sql, int start, int limit, List<Object> parameters)
Pager	getPager(String sql, int start, int limit, Map<String,Object> parameters)
Pager	getPager(String sql, int start, int limit, Object... parameters)
Bean	getSingleValue(String sql)
Bean	getSingleValue(String sql, List<Object> parameters)
Bean	getSingleValue(String sql, Map<String,Object> parameters)
Bean	getSingleValue(String sql, Object... parameters)

Method Detail

getBeans

Bean[] getBeans(String sql)
         throws TinyDbException

Throws:

TinyDbException

getBeans

Bean[] getBeans(String sql,
                Object... parameters)
         throws TinyDbException

Throws:

TinyDbException

getBeans

Bean[] getBeans(String sql,
                List<Object> parameters)
         throws TinyDbException

Throws:

TinyDbException

getBeans

Bean[] getBeans(String sql,
                Map<String,Object> parameters)
         throws TinyDbException

Throws:

TinyDbException

getPageBeans

Bean[] getPageBeans(String sql,
                    int start,
                    int limit)
             throws TinyDbException

Throws:

TinyDbException

getCursorPageBeans

Bean[] getCursorPageBeans(String sql,
                          int start,
                          int limit)
                   throws TinyDbException

Throws:

TinyDbException

getDialectPageBeans

Bean[] getDialectPageBeans(String sql,
                           int start,
                           int limit)
                    throws TinyDbException

Throws:

TinyDbException

getPageBeans

Bean[] getPageBeans(String sql,
                    int start,
                    int limit,
                    Object... parameters)
             throws TinyDbException

Throws:

TinyDbException

getCursorPageBeans

Bean[] getCursorPageBeans(String sql,
                          int start,
                          int limit,
                          Object... parameters)
                   throws TinyDbException

Throws:

TinyDbException

getDialectPageBeans

Bean[] getDialectPageBeans(String sql,
                           int start,
                           int limit,
                           Object... parameters)
                    throws TinyDbException

Throws:

TinyDbException

getPageBeans

Bean[] getPageBeans(String sql,
                    int start,
                    int limit,
                    List<Object> parameters)
             throws TinyDbException

Throws:

TinyDbException

getCursorPageBeans

Bean[] getCursorPageBeans(String sql,
                          int start,
                          int limit,
                          List<Object> parameters)
                   throws TinyDbException

Throws:

TinyDbException

getDialectPageBeans

Bean[] getDialectPageBeans(String sql,
                           int start,
                           int limit,
                           List<Object> parameters)
                    throws TinyDbException

Throws:

TinyDbException

getPageBeans

Bean[] getPageBeans(String sql,
                    int start,
                    int limit,
                    Map<String,Object> parameters)
             throws TinyDbException

Throws:

TinyDbException

getCursorPageBeans

Bean[] getCursorPageBeans(String sql,
                          int start,
                          int limit,
                          Map<String,Object> parameters)
                   throws TinyDbException

Throws:

TinyDbException

getDialectPageBeans

Bean[] getDialectPageBeans(String sql,
                           int start,
                           int limit,
                           Map<String,Object> parameters)
                    throws TinyDbException

Throws:

TinyDbException

getSingleValue

Bean getSingleValue(String sql)
             throws TinyDbException

Throws:

TinyDbException

getSingleValue

Bean getSingleValue(String sql,
                    Map<String,Object> parameters)
             throws TinyDbException

Throws:

TinyDbException

getSingleValue

Bean getSingleValue(String sql,
                    Object... parameters)
             throws TinyDbException

Throws:

TinyDbException

getSingleValue

Bean getSingleValue(String sql,
                    List<Object> parameters)
             throws TinyDbException

Throws:

TinyDbException

execute

int execute(String sql,
            Map<String,Object> parameters)
     throws TinyDbException

执行带参数的sql语句

Parameters:

sql -

parameters -

Returns:

Throws:

TinyDbException

execute

int execute(String sql,
            Object... parameters)
     throws TinyDbException

执行带参数的sql语句

Parameters:

sql -

parameters -

Returns:

Throws:

TinyDbException

execute

int execute(String sql,
            List<Object> parameters)
     throws TinyDbException

Throws:

TinyDbException

account

int account(String sql,
            Object... parameters)
     throws TinyDbException

Throws:

TinyDbException

account

int account(String sql,
            List<Object> parameters)
     throws TinyDbException

Throws:

TinyDbException

account

int account(String sql,
            Map<String,Object> parameters)
     throws TinyDbException

Throws:

TinyDbException

account

int account(Bean bean)
     throws TinyDbException

根据bean对象查询该bean对象的记录数

Parameters:

bean -

Returns:

Throws:

TinyDbException

getPager

Pager getPager(String sql,
               int start,
               int limit)
        throws TinyDbException

Throws:

TinyDbException

getPager

Pager getPager(String sql,
               int start,
               int limit,
               Object... parameters)
        throws TinyDbException

Throws:

TinyDbException

getPager

Pager getPager(String sql,
               int start,
               int limit,
               List<Object> parameters)
        throws TinyDbException

Throws:

TinyDbException

getPager

Pager getPager(String sql,
               int start,
               int limit,
               Map<String,Object> parameters)
        throws TinyDbException

Throws:

TinyDbException

getBeans

Bean[] getBeans(Bean bean,
                int start,
                int limit)
         throws TinyDbException

分页查询bean

Parameters:

bean -

start -

limit -

Returns:

Throws:

TinyDbException

getPager

Pager getPager(Bean bean,
               int start,
               int limit)
        throws TinyDbException

分页查询bean

Parameters:

bean -

start -

limit -

Returns:

Throws:

TinyDbException