sf.database.jdbc.sql

Interface CrudTemplateIdInf

All Known Implementing Classes:

CrudTemplateIdImpl

public interface CrudTemplateIdInf

根据模板id执行sql语句

Author:

sxf

Method Summary

Modifier and Type	Method and Description
int	execute(Connection conn, String sqlId, Map<String,Object> parameters)
int[]	executeBatch(Connection conn, String sqlId, List<Map<String,Object>> parameters)
int[]	executeBatch(Connection conn, String sqlId, 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 sqlId, Map<String,Object> paramters)
List<Map<String,Object>>	select(Connection conn, String sqlId, Map<String,Object> parameters)
Object[]	selectArray(Connection conn, String sqlId, Map<String,Object> parameters)
<T> void	selectIterator(Connection conn, OrmIterator<T> ormIt, Class<T> returnClass, String sqlId, Map<String,Object> paramters)
<T> List<T>	selectList(Connection conn, Class<T> beanClass, String sqlId, Map<String,Object> parameters)
<T> T	selectOne(Connection conn, Class<T> beanClass, String sqlId, Map<String,Object> parameters)
<T> Page<T>	selectPage(Connection conn, long start, int limit, Class<T> beanClass, String sqlId, Map<String,Object> parameters)
<T> Page<T>	selectPageRaw(Connection conn, long start, int limit, Class<T> beanClass, String countSqlId, Map<String,Object> countParas, String listSqlId, Map<String,Object> listParas) 最原始的分页方法,使用原生sql实现
<T> void	selectStream(Connection conn, OrmStream<T> ormStream, Class<T> returnClass, String sqlId, Map<String,Object> paramters)

Method Detail

executeBatch

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

Parameters:

conn -

sqlId -

parameters -

Returns:

executeBatch

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

Parameters:

conn -

sqlId -

parameters -

insertFast -

batchSize -

pkeys -

keyValues -

Returns:

insert

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

execute

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

Parameters:

conn -

sqlId -

parameters -

Returns:

selectPage

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

Type Parameters:

T -

Parameters:

conn -

start -

limit -

beanClass -

sqlId -

parameters -

Returns:

selectPageRaw

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

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

Type Parameters:

T - 泛型

Parameters:

conn -

start - 起始位置

limit - 限制数量

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

countSqlId - 查询总数的语句id

countParas - 查询总数的参数

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

listParas - 分页列表查询参数

Returns:

分页结果

selectArray

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

Parameters:

conn -

sqlId -

parameters -

Returns:

selectList

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

Type Parameters:

T -

Parameters:

conn -

beanClass -

sqlId -

parameters -

Returns:

selectOne

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

Type Parameters:

T -

Parameters:

conn -

beanClass -

sqlId -

parameters -

Returns:

select

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

Parameters:

conn -

sqlId -

parameters -

Returns:

selectIterator

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

Type Parameters:

T -

Parameters:

conn -

ormIt -

returnClass -

sqlId -

paramters -

selectStream

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

Type Parameters:

T -

Parameters:

conn -

ormStream -

returnClass -

sqlId -

paramters -