public class CrudTemplateSourceImpl extends Object implements CrudTemplateSourceInf
| Modifier and Type | Method and Description |
|---|---|
int |
execute(Connection conn,
String sqlSource,
Map<String,Object> paramters) |
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) |
static SQLContext |
getBatchSqlContextBySqlSource(String sqlSource,
List<Map<String,Object>> parameters,
List<Object[]> paras) |
static CrudTemplateSourceImpl |
getInstance() |
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> paramters) |
Object[] |
selectArray(Connection conn,
String sqlSource,
Map<String,Object> paramters) |
<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> paramters) |
<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> paramters) |
<T> Page<T> |
selectPage(Connection conn,
long start,
int limit,
Class<T> beanClass,
String sqlSource,
Map<String,Object> paramters) |
<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) |
public static CrudTemplateSourceImpl getInstance()
public static SQLContext getBatchSqlContextBySqlSource(String sqlSource, List<Map<String,Object>> parameters, List<Object[]> paras)
public int[] executeBatch(Connection conn, String sqlSource, List<Map<String,Object>> parameters)
executeBatch in interface CrudTemplateSourceInfpublic int[] executeBatch(Connection conn, String sqlSource, List<Map<String,Object>> parameters, boolean insertFast, int batchSize, List<String> pkeys, List<Map<String,Object>> keyValues)
executeBatch in interface CrudTemplateSourceInfpublic int insert(Connection conn, List<String> pkeys, Map<String,Object> keyValues, String sqlSource, Map<String,Object> paramters)
insert in interface CrudTemplateSourceInfpublic int execute(Connection conn, String sqlSource, Map<String,Object> paramters)
execute in interface CrudTemplateSourceInfpublic <T> Page<T> selectPage(Connection conn, long start, int limit, Class<T> beanClass, String sqlSource, Map<String,Object> paramters)
selectPage in interface CrudTemplateSourceInfpublic <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)
CrudTemplateSourceInfselectPageRaw in interface CrudTemplateSourceInfT - 泛型start - 起始位置limit - 限制数量beanClass - 返回结果,可以为实体类,Map,List,Object[]countSqlSource - 查询总数的语句idcountParas - 查询总数的参数listSqlSource - 分页列表查询语句id,不能包含了start和limit的内容listParas - 分页列表查询参数public Object[] selectArray(Connection conn, String sqlSource, Map<String,Object> paramters)
selectArray in interface CrudTemplateSourceInfpublic <T> List<T> selectList(Connection conn, Class<T> beanClass, String sqlSource, Map<String,Object> paramters)
selectList in interface CrudTemplateSourceInfpublic <T> List<T> selectList(Connection conn, Class<T> beanClass, String sqlSource, Map<String,Object> paramters, long start, int limit)
selectList in interface CrudTemplateSourceInfpublic <T> T selectOne(Connection conn, Class<T> beanClass, String sqlSource, Map<String,Object> paramters)
selectOne in interface CrudTemplateSourceInfpublic List<Map<String,Object>> select(Connection conn, String sqlSource, Map<String,Object> paramters)
select in interface CrudTemplateSourceInfpublic <T> void selectIterator(Connection conn, OrmIterator<T> ormIt, Class<T> returnClass, String sqlSource, Map<String,Object> paramters)
selectIterator in interface CrudTemplateSourceInfpublic <T> void selectStream(Connection conn, OrmStream<T> ormStream, Class<T> returnClass, String sqlSource, Map<String,Object> paramters)
selectStream in interface CrudTemplateSourceInfCopyright © 2020. All rights reserved.