public class CrudSqlImpl extends Object implements CrudSqlInf
| Modifier and Type | Field and Description |
|---|---|
static int |
ITERATOR_SIZE
分页迭代数量
|
| Modifier and Type | Method and Description |
|---|---|
<T> T |
execute(Connection con,
ConnectionCallback<T> action)
主要支持存储过程执行
|
<T> Object |
execute(Connection conn,
PreparedStatementCreator psc,
PreparedStatementSetter setter,
ResultSetCallback<T> callback,
String sql,
Object parameters)
执行sql语句可以为DML或DDL语句.
|
int |
execute(Connection conn,
String sql,
Object... parameters) |
int |
execute(Connection conn,
String sql,
Object[] parameters,
boolean insertFast,
List<String> pkeys,
Map<String,Object> keyValues)
执行单一语句
|
int[] |
executeBatch(Connection conn,
String sql,
List<Object[]> parameters)
批量执行语句.
|
int[] |
executeBatch(Connection conn,
String sql,
List<Object[]> parameters,
boolean insertFast,
int batchSize,
List<String> pkeys,
List<Map<String,Object>> keyValues)
批量执行语句.允许返回主键等信息
|
static CrudSqlImpl |
getInstance() |
int |
insert(Connection conn,
List<String> pkeys,
Map<String,Object> keyValues,
String sql,
Object... parameters)
插入
|
int |
insertFast(Connection conn,
String sql,
Object... parameters)
快速插入
|
<T> T |
select(Connection conn,
PreparedStatementCreator psc,
ResultSetCallback<T> rsh,
SQLContext context) |
<T> T |
select(Connection conn,
ResultSetCallback<T> rsh,
String sql,
Object... parameters) |
List<Map<String,Object>> |
select(Connection conn,
String sql,
Object... paras) |
Object[] |
selectArray(Connection conn,
String sql,
Object... parameters) |
<T> T |
selectByContext(Connection conn,
ResultSetCallback<T> rsh,
String sql,
Object... parameters) |
<T> T |
selectForUpdate(Connection conn,
ResultSetCallback<T> callback,
SQLContext context)
支持结果集更新
|
<T> T |
selectForUpdate(Connection conn,
ResultSetCallback<T> callback,
String sql,
Object... parameters)
支持结果集更新
|
protected <T> void |
selectIterator(Connection conn,
sf.database.jdbc.sql.CrudSqlImpl.IteratorResultSetCallBackDeal<T> deal,
boolean usePage,
SQLContext context) |
<T> void |
selectIterator(Connection conn,
OrmIterator<T> ormIt,
Class<T> beanClass,
boolean usePage,
SQLContext context)
支持分页实现的迭代查询
|
<T> void |
selectIterator(Connection conn,
OrmIterator<T> ormIt,
Class<T> beanClass,
boolean usePage,
String sql,
Object... parameters)
迭代接口
|
<T> List<T> |
selectList(Connection conn,
Class<T> beanClass,
long start,
int limit,
String sql,
Object... parameters) |
<T> List<T> |
selectList(Connection conn,
Class<T> beanClass,
String sql,
Object... parameters) |
List<?> |
selectList(Connection conn,
String resultSetMapping,
long start,
int limit,
String sql,
Object... parameters)
根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
|
List<?> |
selectList(Connection conn,
String resultSetMapping,
String sql,
Object... parameters)
根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
|
<T> T |
selectOne(Connection conn,
Class<T> beanClass,
String sql,
Object... parameters) |
Object |
selectOne(Connection conn,
String resultSetMapping,
String sql,
Object... parameters)
根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
|
<T> Page<T> |
selectPage(Connection conn,
long start,
int limit,
Class<T> beanClass,
String sql,
Object... parameters)
分页查询
|
<T> Page<T> |
selectPageRaw(Connection conn,
long start,
int limit,
Class<T> beanClass,
String countSql,
Object[] countParas,
String listSql,
Object[] listParas)
最原始的分页方法,假分页实现,使用result跳过数据,实现
|
<T> Page<T> |
selectPageRaw(Connection conn,
long start,
int limit,
Class<T> beanClass,
String countSql,
Object[] countParas,
String listSql,
Object[] listParas,
PageStrategy strategy)
最原始的分页方法,假分页实现,使用result跳过数据,实现
|
<T> T |
selectResultSet(Connection conn,
PreparedStatementCreator psc,
ResultSetCallback<T> callback,
String sql,
Object... parameters)
查询,允许自定义设置查询参数,自定义处理返回结果
|
<T> T |
selectResultSet(Connection conn,
ResultSetCallback<T> callback,
String sql,
Object... parameters)
查询,允许自定义处理返回结果
|
<T> void |
selectStream(Connection conn,
OrmStream<T> ormStream,
Class<T> beanClass,
boolean usePage,
SQLContext context) |
<T> void |
selectStream(Connection conn,
OrmStream<T> ormStream,
Class<T> beanClass,
boolean usePage,
String sql,
Object... parameters)
支持分页实现的迭代查询
|
public static CrudSqlImpl getInstance()
public List<Map<String,Object>> select(Connection conn, String sql, Object... paras)
select in interface CrudSqlInfpublic List<?> selectList(Connection conn, String resultSetMapping, String sql, Object... parameters)
CrudSqlInfselectList in interface CrudSqlInfresultSetMapping - @SqlResultSetMapping 中的namepublic List<?> selectList(Connection conn, String resultSetMapping, long start, int limit, String sql, Object... parameters)
CrudSqlInfselectList in interface CrudSqlInfresultSetMapping - @SqlResultSetMapping 中的namepublic Object selectOne(Connection conn, String resultSetMapping, String sql, Object... parameters)
CrudSqlInfselectOne in interface CrudSqlInfresultSetMapping - @SqlResultSetMapping 中的namepublic <T> T selectOne(Connection conn, Class<T> beanClass, String sql, Object... parameters)
selectOne in interface CrudSqlInfpublic <T> List<T> selectList(Connection conn, Class<T> beanClass, String sql, Object... parameters)
selectList in interface CrudSqlInfpublic <T> List<T> selectList(Connection conn, Class<T> beanClass, long start, int limit, String sql, Object... parameters)
selectList in interface CrudSqlInfpublic Object[] selectArray(Connection conn, String sql, Object... parameters)
selectArray in interface CrudSqlInfpublic <T> Page<T> selectPage(Connection conn, long start, int limit, Class<T> beanClass, String sql, Object... parameters)
CrudSqlInfselectPage in interface CrudSqlInfsql - 原始的语句,不包含限制条数的内容.public <T> Page<T> selectPageRaw(Connection conn, long start, int limit, Class<T> beanClass, String countSql, Object[] countParas, String listSql, Object[] listParas)
CrudSqlInfselectPageRaw in interface CrudSqlInfT - 泛型start - 起始位置limit - 限制数量beanClass - 返回结果,可以为实体类,Map,List,Object[]countSql - 查询总数的语句countParas - 查询总数的参数listSql - 查询列表的语句,不能包含限制条数(start和limit)的内容.listParas - 查询列表的参数public <T> Page<T> selectPageRaw(Connection conn, long start, int limit, Class<T> beanClass, String countSql, Object[] countParas, String listSql, Object[] listParas, PageStrategy strategy)
CrudSqlInfselectPageRaw in interface CrudSqlInfT - 泛型start - 起始位置limit - 限制数量beanClass - 返回结果,可以为实体类,Map,List,Object[]countSql - 查询总数的语句countParas - 查询总数的参数listSql - 查询列表的语句(需和查询策略配合).listParas - 查询列表的参数strategy - 分页策略public <T> T select(Connection conn, ResultSetCallback<T> rsh, String sql, Object... parameters)
public <T> T selectByContext(Connection conn, ResultSetCallback<T> rsh, String sql, Object... parameters)
public <T> T select(Connection conn, PreparedStatementCreator psc, ResultSetCallback<T> rsh, SQLContext context)
public <T> T selectForUpdate(Connection conn, ResultSetCallback<T> callback, String sql, Object... parameters)
CrudSqlInfselectForUpdate in interface CrudSqlInfpublic <T> T selectForUpdate(Connection conn, ResultSetCallback<T> callback, SQLContext context)
CrudSqlInfselectForUpdate in interface CrudSqlInfpublic <T> void selectIterator(Connection conn, OrmIterator<T> ormIt, Class<T> beanClass, boolean usePage, String sql, Object... parameters)
selectIterator in interface CrudSqlInfT - conn - ormIt - beanClass - usePage - 是否使用分页实现迭代.sql - parameters - 查询参数public <T> void selectIterator(Connection conn, OrmIterator<T> ormIt, Class<T> beanClass, boolean usePage, SQLContext context)
CrudSqlInfselectIterator in interface CrudSqlInfpublic <T> void selectStream(Connection conn, OrmStream<T> ormStream, Class<T> beanClass, boolean usePage, String sql, Object... parameters)
CrudSqlInfselectStream in interface CrudSqlInfT - conn - ormStream - beanClass - usePage - sql - parameters - public <T> void selectStream(Connection conn, OrmStream<T> ormStream, Class<T> beanClass, boolean usePage, SQLContext context)
selectStream in interface CrudSqlInfprotected <T> void selectIterator(Connection conn, sf.database.jdbc.sql.CrudSqlImpl.IteratorResultSetCallBackDeal<T> deal, boolean usePage, SQLContext context)
T - conn - deal - usePage - 是否分页实现迭代.context - public <T> T selectResultSet(Connection conn, ResultSetCallback<T> callback, String sql, Object... parameters)
CrudSqlInfselectResultSet in interface CrudSqlInfpublic <T> T selectResultSet(Connection conn, PreparedStatementCreator psc, ResultSetCallback<T> callback, String sql, Object... parameters)
CrudSqlInfselectResultSet in interface CrudSqlInfpublic <T> T execute(Connection con, ConnectionCallback<T> action)
CrudSqlInfexecute in interface CrudSqlInfpublic int execute(Connection conn, String sql, Object... parameters)
execute in interface CrudSqlInfpublic <T> Object execute(Connection conn, PreparedStatementCreator psc, PreparedStatementSetter setter, ResultSetCallback<T> callback, String sql, Object parameters)
CrudSqlInfexecute in interface CrudSqlInfpublic int insertFast(Connection conn, String sql, Object... parameters)
CrudSqlInfinsertFast in interface CrudSqlInfpublic int insert(Connection conn, List<String> pkeys, Map<String,Object> keyValues, String sql, Object... parameters)
CrudSqlInfinsert in interface CrudSqlInfpkeys - 主键列keyValues - 返回的主键值public int execute(Connection conn, String sql, Object[] parameters, boolean insertFast, List<String> pkeys, Map<String,Object> keyValues)
CrudSqlInfexecute in interface CrudSqlInfsql - sql语句parameters - 参数insertFast - 是否快速插入pkeys - 主键列keyValues - 返回的主键值public int[] executeBatch(Connection conn, String sql, List<Object[]> parameters)
CrudSqlInfexecuteBatch in interface CrudSqlInfpublic int[] executeBatch(Connection conn, String sql, List<Object[]> parameters, boolean insertFast, int batchSize, List<String> pkeys, List<Map<String,Object>> keyValues)
CrudSqlInfexecuteBatch in interface CrudSqlInfconn - 连接sql - 语句parameters - 参数insertFast - 是否快速插入batchSize - 批处理条数pkeys - 主键列keyValues - 返回主键值Copyright © 2020. All rights reserved.