public class CrudTemplateIdImpl extends Object implements CrudTemplateIdInf
| Modifier and Type | Method and Description |
|---|---|
int |
execute(Connection conn,
String sqlId,
Map<String,Object> paramters) |
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) |
static SQLContext |
getBatchSqlContextBySqlId(String sqlId,
List<Map<String,Object>> parameters,
List<Object[]> paras) |
static String |
getDialectSqlId(Connection conn,
String sqlId)
是否使用dialect处理,主要解决应用跨数据库访问的问题
|
static CrudTemplateIdImpl |
getInstance() |
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> paramters) |
Object[] |
selectArray(Connection conn,
String sqlId,
Map<String,Object> paramters) |
<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> paramters) |
<T> T |
selectOne(Connection conn,
Class<T> beanClass,
String sqlId,
Map<String,Object> paramters) |
<T> Page<T> |
selectPage(Connection conn,
long start,
int limit,
Class<T> beanClass,
String sqlId,
Map<String,Object> paramters) |
<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) |
public static CrudTemplateIdImpl getInstance()
public static SQLContext getBatchSqlContextBySqlId(String sqlId, List<Map<String,Object>> parameters, List<Object[]> paras)
public static String getDialectSqlId(Connection conn, String sqlId)
conn - sqlId - public int[] executeBatch(Connection conn, String sqlId, List<Map<String,Object>> parameters)
executeBatch in interface CrudTemplateIdInfpublic int[] executeBatch(Connection conn, String sqlId, List<Map<String,Object>> parameters, boolean insertFast, int batchSize, List<String> pkeys, List<Map<String,Object>> keyValues)
executeBatch in interface CrudTemplateIdInfpublic int insert(Connection conn, List<String> pkeys, Map<String,Object> keyValues, String sqlId, Map<String,Object> paramters)
insert in interface CrudTemplateIdInfpublic int execute(Connection conn, String sqlId, Map<String,Object> paramters)
execute in interface CrudTemplateIdInfpublic <T> Page<T> selectPage(Connection conn, long start, int limit, Class<T> beanClass, String sqlId, Map<String,Object> paramters)
selectPage in interface CrudTemplateIdInfpublic <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)
CrudTemplateIdInfselectPageRaw in interface CrudTemplateIdInfT - 泛型start - 起始位置limit - 限制数量beanClass - 返回结果,可以为实体类,Map,List,Object[]countSqlId - 查询总数的语句idcountParas - 查询总数的参数listSqlId - 分页列表查询语句id,不能包含了start和limit的内容listParas - 分页列表查询参数public Object[] selectArray(Connection conn, String sqlId, Map<String,Object> paramters)
selectArray in interface CrudTemplateIdInfpublic <T> List<T> selectList(Connection conn, Class<T> beanClass, String sqlId, Map<String,Object> paramters)
selectList in interface CrudTemplateIdInfpublic <T> T selectOne(Connection conn, Class<T> beanClass, String sqlId, Map<String,Object> paramters)
selectOne in interface CrudTemplateIdInfpublic List<Map<String,Object>> select(Connection conn, String sqlId, Map<String,Object> paramters)
select in interface CrudTemplateIdInfpublic <T> void selectIterator(Connection conn, OrmIterator<T> ormIt, Class<T> returnClass, String sqlId, Map<String,Object> paramters)
selectIterator in interface CrudTemplateIdInfpublic <T> void selectStream(Connection conn, OrmStream<T> ormStream, Class<T> returnClass, String sqlId, Map<String,Object> paramters)
selectStream in interface CrudTemplateIdInfCopyright © 2020. All rights reserved.