sf.database.jdbc.sql

Interface CrudTemplateSourceInf

All Known Implementing Classes:

CrudTemplateSourceImpl

public interface CrudTemplateSourceInf

直接执行sql模版语句，sql是模板

Author:

sxf

Method Summary

Modifier and Type	Method and Description
int	execute(Connection conn, String sqlSource, Map<String,Object> parameters)
int[]	executeBatch(Connection conn, String sqlSource, List<Map<String,Object>> parameters)
int[]	executeBatch(Connection conn, String sqlSource, List<Map<String,Object>> parameters, boolean insertFast, int batchSize, List<String> pkeys, List<Map<String,Object>> keyValues)
int	insert(Connection conn, List<String> pkeys, Map<String,Object> keyValues, String sqlSource, Map<String,Object> paramters)
List<Map<String,Object>>	select(Connection conn, String sqlSource, Map<String,Object> parameters)
Object[]	selectArray(Connection conn, String sqlSource, Map<String,Object> parameters)
<T> void	selectIterator(Connection conn, OrmIterator<T> ormIt, Class<T> returnClass, String sqlSource, Map<String,Object> paramters)
<T> List<T>	selectList(Connection conn, Class<T> beanClass, String sqlSource, Map<String,Object> parameters)
<T> List<T>	selectList(Connection conn, Class<T> beanClass, String sqlSource, Map<String,Object> paramters, long start, int limit)
<T> T	selectOne(Connection conn, Class<T> beanClass, String sqlSource, Map<String,Object> parameters)
<T> Page<T>	selectPage(Connection conn, long start, int limit, Class<T> beanClass, String sqlSource, Map<String,Object> parameters)
<T> Page<T>	selectPageRaw(Connection conn, long start, int limit, Class<T> beanClass, String countSqlSource, Map<String,Object> countParas, String listSqlSource, Map<String,Object> listParas) 最原始的分页方法,使用原生sql实现
<T> void	selectStream(Connection conn, OrmStream<T> ormStream, Class<T> returnClass, String sqlSource, Map<String,Object> paramters)

Method Detail

executeBatch

int[] executeBatch(Connection conn,
                   String sqlSource,
                   List<Map<String,Object>> parameters)

Parameters:

conn -

sqlSource -

parameters -

Returns:

executeBatch

int[] executeBatch(Connection conn,
                   String sqlSource,
                   List<Map<String,Object>> parameters,
                   boolean insertFast,
                   int batchSize,
                   List<String> pkeys,
                   List<Map<String,Object>> keyValues)

Parameters:

conn -

sqlSource -

parameters -

insertFast -

batchSize -

pkeys -

keyValues -

Returns:

insert

int insert(Connection conn,
           List<String> pkeys,
           Map<String,Object> keyValues,
           String sqlSource,
           Map<String,Object> paramters)

Parameters:

conn -

pkeys -

keyValues -

sqlSource -

paramters -

Returns:

execute

int execute(Connection conn,
            String sqlSource,
            Map<String,Object> parameters)

Parameters:

conn -

sqlSource -

parameters -

Returns:

selectPage

<T> Page<T> selectPage(Connection conn,
                       long start,
                       int limit,
                       Class<T> beanClass,
                       String sqlSource,
                       Map<String,Object> parameters)

Type Parameters:

T -

Parameters:

conn -

start -

limit -

beanClass -

sqlSource -

parameters -

Returns:

selectPageRaw

<T> Page<T> selectPageRaw(Connection conn,
                          long start,
                          int limit,
                          Class<T> beanClass,
                          String countSqlSource,
                          Map<String,Object> countParas,
                          String listSqlSource,
                          Map<String,Object> listParas)

最原始的分页方法,使用原生sql实现

Type Parameters:

T - 泛型

Parameters:

conn -

start - 起始位置

limit - 限制数量

beanClass - 返回结果,可以为实体类,Map,List,Object[]

countSqlSource - 查询总数的语句id

countParas - 查询总数的参数

listSqlSource - 分页列表查询语句id,不能包含了start和limit的内容

listParas - 分页列表查询参数

Returns:

分页结果

selectArray

Object[] selectArray(Connection conn,
                     String sqlSource,
                     Map<String,Object> parameters)

Parameters:

conn -

sqlSource -

parameters -

Returns:

selectList

<T> List<T> selectList(Connection conn,
                       Class<T> beanClass,
                       String sqlSource,
                       Map<String,Object> parameters)

Type Parameters:

T -

Parameters:

conn -

beanClass -

sqlSource -

parameters -

Returns:

selectList

<T> List<T> selectList(Connection conn,
                       Class<T> beanClass,
                       String sqlSource,
                       Map<String,Object> paramters,
                       long start,
                       int limit)

Type Parameters:

T -

Parameters:

conn -

beanClass -

sqlSource -

paramters -

start -

limit -

Returns:

selectOne

<T> T selectOne(Connection conn,
                Class<T> beanClass,
                String sqlSource,
                Map<String,Object> parameters)

Type Parameters:

T -

Parameters:

conn -

beanClass -

sqlSource -

parameters -

Returns:

select

List<Map<String,Object>> select(Connection conn,
                                String sqlSource,
                                Map<String,Object> parameters)

Parameters:

conn -

sqlSource -

parameters -

Returns:

selectIterator

<T> void selectIterator(Connection conn,
                        OrmIterator<T> ormIt,
                        Class<T> returnClass,
                        String sqlSource,
                        Map<String,Object> paramters)

Type Parameters:

T -

Parameters:

conn -

ormIt -

returnClass -

sqlSource -

paramters -

selectStream

<T> void selectStream(Connection conn,
                      OrmStream<T> ormStream,
                      Class<T> returnClass,
                      String sqlSource,
                      Map<String,Object> paramters)

Type Parameters:

T -

Parameters:

conn -

ormStream -

returnClass -

sqlSource -

paramters -