模块 org.redkale

程序包 org.redkale.source

接口 DataSqlSource

所有超级接口:

DataSource, Resourcable

所有已知实现类:

AbstractDataSqlSource, DataJdbcSource

@ClassDepends
public interface DataSqlSource
extends DataSource

关系型sql数据库的数据源， 比DataSource多了操作sql语句的接口。

详情见: https://redkale.org

从以下版本开始:

2.8.0

作者:

zhangjx

方法概要

修饰符和类型	方法	说明
<V> V	nativeQuery(String sql, BiConsumer<Object,Object> consumer, Function<DataResultSet,V> handler)	通过原生的sql查询结果
<V> V	nativeQuery(String sql, BiConsumer<Object,Object> consumer, Function<DataResultSet,V> handler, Map<String,Object> params)	通过原生带参数的sql查询结果
default <V> V	nativeQuery(String sql, Function<DataResultSet,V> handler)
default <V> V	nativeQuery(String sql, Function<DataResultSet,V> handler, Serializable bean)
default <V> V	nativeQuery(String sql, Function<DataResultSet,V> handler, Map<String,Object> params)
<V> CompletableFuture<V>	nativeQueryAsync(String sql, BiConsumer<Object,Object> consumer, Function<DataResultSet,V> handler)	通过原生的sql查询结果
<V> CompletableFuture<V>	nativeQueryAsync(String sql, BiConsumer<Object,Object> consumer, Function<DataResultSet,V> handler, Map<String,Object> params)	通过原生带参数的sql查询结果
default <V> CompletableFuture<V>	nativeQueryAsync(String sql, Function<DataResultSet,V> handler)
default <V> CompletableFuture<V>	nativeQueryAsync(String sql, Function<DataResultSet,V> handler, Serializable bean)
default <V> CompletableFuture<V>	nativeQueryAsync(String sql, Function<DataResultSet,V> handler, Map<String,Object> params)
default <V> List<V>	nativeQueryList(Class<V> type, String sql)
default <V> List<V>	nativeQueryList(Class<V> type, String sql, Serializable bean)
default <V> List<V>	nativeQueryList(Class<V> type, String sql, Map<String,Object> params)
default <V> CompletableFuture<List<V>>	nativeQueryListAsync(Class<V> type, String sql)
default <V> CompletableFuture<List<V>>	nativeQueryListAsync(Class<V> type, String sql, Serializable bean)
default <V> CompletableFuture<List<V>>	nativeQueryListAsync(Class<V> type, String sql, Map<String,Object> params)
default <K,V> Map<K,V>	nativeQueryMap(Class<K> keyType, Class<V> valType, String sql)
default <K,V> Map<K,V>	nativeQueryMap(Class<K> keyType, Class<V> valType, String sql, Serializable bean)
default <K,V> Map<K,V>	nativeQueryMap(Class<K> keyType, Class<V> valType, String sql, Map<String,Object> params)
default <K,V> CompletableFuture<Map<K,V>>	nativeQueryMapAsync(Class<K> keyType, Class<V> valType, String sql)
default <K,V> CompletableFuture<Map<K,V>>	nativeQueryMapAsync(Class<K> keyType, Class<V> valType, String sql, Serializable bean)
default <K,V> CompletableFuture<Map<K,V>>	nativeQueryMapAsync(Class<K> keyType, Class<V> valType, String sql, Map<String,Object> params)
default <V> V	nativeQueryOne(Class<V> type, String sql)
default <V> V	nativeQueryOne(Class<V> type, String sql, Serializable bean)
default <V> V	nativeQueryOne(Class<V> type, String sql, Map<String,Object> params)
default <V> CompletableFuture<V>	nativeQueryOneAsync(Class<V> type, String sql)
default <V> CompletableFuture<V>	nativeQueryOneAsync(Class<V> type, String sql, Serializable bean)
default <V> CompletableFuture<V>	nativeQueryOneAsync(Class<V> type, String sql, Map<String,Object> params)
default <V> Sheet<V>	nativeQuerySheet(Class<V> type, String sql, PageBean pageBean)
default <V> Sheet<V>	nativeQuerySheet(Class<V> type, String sql, RowBound round)
default <V> Sheet<V>	nativeQuerySheet(Class<V> type, String sql, RowBound round, Serializable bean)
<V> Sheet<V>	nativeQuerySheet(Class<V> type, String sql, RowBound round, Map<String,Object> params)
default <V> CompletableFuture<Sheet<V>>	nativeQuerySheetAsync(Class<V> type, String sql, PageBean pageBean)
default <V> CompletableFuture<Sheet<V>>	nativeQuerySheetAsync(Class<V> type, String sql, RowBound round)
default <V> CompletableFuture<Sheet<V>>	nativeQuerySheetAsync(Class<V> type, String sql, RowBound round, Serializable bean)
<V> CompletableFuture<Sheet<V>>	nativeQuerySheetAsync(Class<V> type, String sql, RowBound round, Map<String,Object> params)
default CompletableFuture<Map<String,String>>	nativeQueryStrStrMapAsync(String sql)
default Map<Integer,String>	nativeQueryToIntStrMap(String sql)
default Map<Integer,String>	nativeQueryToIntStrMap(String sql, Serializable bean)
default Map<Integer,String>	nativeQueryToIntStrMap(String sql, Map<String,Object> params)
default CompletableFuture<Map<Integer,String>>	nativeQueryToIntStrMapAsync(String sql)
default CompletableFuture<Map<Integer,String>>	nativeQueryToIntStrMapAsync(String sql, Serializable bean)
default CompletableFuture<Map<Integer,String>>	nativeQueryToIntStrMapAsync(String sql, Map<String,Object> params)
default Map<String,String>	nativeQueryToStrStrMap(String sql)
default Map<String,String>	nativeQueryToStrStrMap(String sql, Serializable bean)
default Map<String,String>	nativeQueryToStrStrMap(String sql, Map<String,Object> params)
default CompletableFuture<Map<String,String>>	nativeQueryToStrStrMapAsync(String sql, Serializable bean)
default CompletableFuture<Map<String,String>>	nativeQueryToStrStrMapAsync(String sql, Map<String,Object> params)
int	nativeUpdate(String sql)	执行原生无参数的sql
default int	nativeUpdate(String sql, Serializable bean)
int	nativeUpdate(String sql, Map<String,Object> params)	执行原生带参数的sql
CompletableFuture<Integer>	nativeUpdateAsync(String sql)	执行原生无参数的sql
default CompletableFuture<Integer>	nativeUpdateAsync(String sql, Serializable bean)
CompletableFuture<Integer>	nativeUpdateAsync(String sql, Map<String,Object> params)	执行原生带参数的sql
int[]	nativeUpdates(String... sqls)	执行多条原生无参数的sql
CompletableFuture<int[]>	nativeUpdatesAsync(String... sqls)	执行多条原生无参数的sql

从接口继承的方法 org.redkale.source.DataSource

batch, batchAsync, clearTable, clearTable, clearTableAsync, clearTableAsync, compile, createTable, createTableAsync, delete, delete, delete, delete, delete, delete, deleteAsync, deleteAsync, deleteAsync, deleteAsync, deleteAsync, deleteAsync, dropTable, dropTable, dropTableAsync, dropTableAsync, exists, exists, exists, existsAsync, existsAsync, existsAsync, find, find, find, find, find, find, find, find, findAsync, findAsync, findAsync, findAsync, findAsync, findAsync, findAsync, findAsync, findColumn, findColumn, findColumn, findColumn, findColumn, findColumn, findColumnAsync, findColumnAsync, findColumnAsync, findColumnAsync, findColumnAsync, findColumnAsync, finds, finds, finds, finds, findsAsync, findsAsync, findsAsync, findsAsync, findsList, findsListAsync, getNumberMap, getNumberMap, getNumberMap, getNumberMapAsync, getNumberMapAsync, getNumberMapAsync, getNumberResult, getNumberResult, getNumberResult, getNumberResult, getNumberResult, getNumberResult, getNumberResultAsync, getNumberResultAsync, getNumberResultAsync, getNumberResultAsync, getNumberResultAsync, getNumberResultAsync, getType, insert, insert, insert, insertAsync, insertAsync, insertAsync, queryColumnList, queryColumnList, queryColumnList, queryColumnList, queryColumnList, queryColumnListAsync, queryColumnListAsync, queryColumnListAsync, queryColumnListAsync, queryColumnListAsync, queryColumnMap, queryColumnMap, queryColumnMap, queryColumnMap, queryColumnMap, queryColumnMap, queryColumnMap, queryColumnMap, queryColumnMap, queryColumnMapAsync, queryColumnMapAsync, queryColumnMapAsync, queryColumnMapAsync, queryColumnMapAsync, queryColumnMapAsync, queryColumnMapAsync, queryColumnMapAsync, queryColumnMapAsync, queryColumnSet, queryColumnSet, queryColumnSet, queryColumnSet, queryColumnSet, queryColumnSetAsync, queryColumnSetAsync, queryColumnSetAsync, queryColumnSetAsync, queryColumnSetAsync, queryColumnSheet, queryColumnSheet, queryColumnSheet, queryColumnSheetAsync, queryColumnSheetAsync, queryColumnSheetAsync, queryList, queryList, queryList, queryList, queryList, queryList, queryList, queryList, queryList, queryList, queryList, queryList, queryList, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryListAsync, queryMap, queryMap, queryMap, queryMap, queryMap, queryMap, queryMapAsync, queryMapAsync, queryMapAsync, queryMapAsync, queryMapAsync, queryMapAsync, querySet, querySet, querySet, querySet, querySet, querySet, querySet, querySet, querySet, querySet, querySet, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySetAsync, querySheet, querySheet, querySheet, querySheet, querySheet, querySheet, querySheetAsync, querySheetAsync, querySheetAsync, querySheetAsync, querySheetAsync, querySheetAsync, update, update, update, updateAsync, updateAsync, updateAsync, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumn, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync, updateColumnAsync

从接口继承的方法 org.redkale.inject.Resourcable

resourceName

方法详细资料

nativeUpdates

int[] nativeUpdates(String... sqls)

执行多条原生无参数的sql

参数:

sqls - 无参数的sql语句

返回:

执行条数

nativeUpdatesAsync

CompletableFuture<int[]> nativeUpdatesAsync(String... sqls)

执行多条原生无参数的sql

参数:

sqls - 无参数的sql语句

返回:

执行条数

nativeUpdate

int nativeUpdate(String sql)

执行原生无参数的sql

参数:

sql - 无参数的sql语句

返回:

执行条数

nativeUpdateAsync

CompletableFuture<Integer> nativeUpdateAsync(String sql)

执行原生无参数的sql

参数:

sql - 无参数的sql语句

返回:

执行条数

nativeUpdate

@ClassDepends
int nativeUpdate(String sql,
                 Map<String,Object> params)

执行原生带参数的sql

参数:

sql - 带参数的sql语句

params - 参数值集合

返回:

执行条数

nativeUpdateAsync

@ClassDepends
CompletableFuture<Integer> nativeUpdateAsync(String sql,
                                             Map<String,Object> params)

执行原生带参数的sql

参数:

sql - 带参数的sql语句

params - 参数值集合

返回:

执行条数

nativeQuery

<V> V nativeQuery(String sql,
                  BiConsumer<Object,Object> consumer,
                  Function<DataResultSet,V> handler)

通过原生的sql查询结果

类型参数:

V - 泛型

参数:

sql - 无参数的sql语句

consumer - BiConsumer 参数1: connection, 参数2: statement

handler - DataResultSet的回调函数

返回:

结果对象

nativeQueryAsync

<V> CompletableFuture<V> nativeQueryAsync(String sql,
                                          BiConsumer<Object,Object> consumer,
                                          Function<DataResultSet,V> handler)

通过原生的sql查询结果

类型参数:

V - 泛型

参数:

sql - 无参数的sql语句

consumer - BiConsumer 参数1: connection, 参数2: statement

handler - DataResultSet的回调函数

返回:

结果对象

nativeQuery

<V> V nativeQuery(String sql,
                  BiConsumer<Object,Object> consumer,
                  Function<DataResultSet,V> handler,
                  Map<String,Object> params)

通过原生带参数的sql查询结果

类型参数:

V - 泛型

参数:

sql - 带参数的sql语句

consumer - BiConsumer 参数1: connection, 参数2: statement

handler - DataResultSet的回调函数

params - 参数值集合

返回:

结果对象

nativeQueryAsync

<V> CompletableFuture<V> nativeQueryAsync(String sql,
                                          BiConsumer<Object,Object> consumer,
                                          Function<DataResultSet,V> handler,
                                          Map<String,Object> params)

通过原生带参数的sql查询结果

类型参数:

V - 泛型

参数:

sql - 带参数的sql语句

consumer - BiConsumer 参数1: connection, 参数2: statement

handler - DataResultSet的回调函数

params - 参数值集合

返回:

结果对象

nativeQuerySheet

@ClassDepends
<V> Sheet<V> nativeQuerySheet(Class<V> type,
                              String sql,
                              RowBound round,
                              Map<String,Object> params)

nativeQuerySheetAsync

@ClassDepends
<V> CompletableFuture<Sheet<V>> nativeQuerySheetAsync(Class<V> type,
                                                      String sql,
                                                      RowBound round,
                                                      Map<String,Object> params)

nativeQuery

default <V> V nativeQuery(String sql,
                          Function<DataResultSet,V> handler)

nativeQueryAsync

default <V> CompletableFuture<V> nativeQueryAsync(String sql,
                                                  Function<DataResultSet,V> handler)

nativeQueryOne

@ClassDepends
default <V> V nativeQueryOne(Class<V> type,
                             String sql)

nativeQueryOneAsync

@ClassDepends
default <V> CompletableFuture<V> nativeQueryOneAsync(Class<V> type,
                                                     String sql)

nativeQueryList

@ClassDepends
default <V> List<V> nativeQueryList(Class<V> type,
                                    String sql)

nativeQueryListAsync

@ClassDepends
default <V> CompletableFuture<List<V>> nativeQueryListAsync(Class<V> type,
                                                            String sql)

nativeQuerySheet

@ClassDepends
default <V> Sheet<V> nativeQuerySheet(Class<V> type,
                                      String sql,
                                      RowBound round)

nativeQuerySheetAsync

@ClassDepends
default <V> CompletableFuture<Sheet<V>> nativeQuerySheetAsync(Class<V> type,
                                                              String sql,
                                                              RowBound round)

nativeQueryMap

@ClassDepends
default <K,V> Map<K,V> nativeQueryMap(Class<K> keyType,
                                                  Class<V> valType,
                                                  String sql)

nativeQueryMapAsync

@ClassDepends
default <K,V> CompletableFuture<Map<K,V>> nativeQueryMapAsync(Class<K> keyType,
                                                                          Class<V> valType,
                                                                          String sql)

nativeQueryToStrStrMap

default Map<String,String> nativeQueryToStrStrMap(String sql)

nativeQueryStrStrMapAsync

default CompletableFuture<Map<String,String>> nativeQueryStrStrMapAsync(String sql)

nativeQueryToIntStrMap

default Map<Integer,String> nativeQueryToIntStrMap(String sql)

nativeQueryToIntStrMapAsync

default CompletableFuture<Map<Integer,String>> nativeQueryToIntStrMapAsync(String sql)

nativeQuery

default <V> V nativeQuery(String sql,
                          Function<DataResultSet,V> handler,
                          Map<String,Object> params)

nativeQueryAsync

default <V> CompletableFuture<V> nativeQueryAsync(String sql,
                                                  Function<DataResultSet,V> handler,
                                                  Map<String,Object> params)

nativeQueryOne

@ClassDepends
default <V> V nativeQueryOne(Class<V> type,
                             String sql,
                             Map<String,Object> params)

nativeQueryOneAsync

@ClassDepends
default <V> CompletableFuture<V> nativeQueryOneAsync(Class<V> type,
                                                     String sql,
                                                     Map<String,Object> params)

nativeQueryList

@ClassDepends
default <V> List<V> nativeQueryList(Class<V> type,
                                    String sql,
                                    Map<String,Object> params)

nativeQueryListAsync

@ClassDepends
default <V> CompletableFuture<List<V>> nativeQueryListAsync(Class<V> type,
                                                            String sql,
                                                            Map<String,Object> params)

nativeQueryMap

@ClassDepends
default <K,V> Map<K,V> nativeQueryMap(Class<K> keyType,
                                                  Class<V> valType,
                                                  String sql,
                                                  Map<String,Object> params)

nativeQueryMapAsync

@ClassDepends
default <K,V> CompletableFuture<Map<K,V>> nativeQueryMapAsync(Class<K> keyType,
                                                                          Class<V> valType,
                                                                          String sql,
                                                                          Map<String,Object> params)

nativeQueryToStrStrMap

default Map<String,String> nativeQueryToStrStrMap(String sql,
                                                        Map<String,Object> params)

nativeQueryToStrStrMapAsync

default CompletableFuture<Map<String,String>> nativeQueryToStrStrMapAsync(String sql,
                                                                                Map<String,Object> params)

nativeQueryToIntStrMap

default Map<Integer,String> nativeQueryToIntStrMap(String sql,
                                                         Map<String,Object> params)

nativeQueryToIntStrMapAsync

default CompletableFuture<Map<Integer,String>> nativeQueryToIntStrMapAsync(String sql,
                                                                                 Map<String,Object> params)

nativeUpdate

default int nativeUpdate(String sql,
                         Serializable bean)

nativeUpdateAsync

default CompletableFuture<Integer> nativeUpdateAsync(String sql,
                                                     Serializable bean)

nativeQuery

default <V> V nativeQuery(String sql,
                          Function<DataResultSet,V> handler,
                          Serializable bean)

nativeQueryAsync

default <V> CompletableFuture<V> nativeQueryAsync(String sql,
                                                  Function<DataResultSet,V> handler,
                                                  Serializable bean)

nativeQueryOne

default <V> V nativeQueryOne(Class<V> type,
                             String sql,
                             Serializable bean)

nativeQueryOneAsync

default <V> CompletableFuture<V> nativeQueryOneAsync(Class<V> type,
                                                     String sql,
                                                     Serializable bean)

nativeQueryList

default <V> List<V> nativeQueryList(Class<V> type,
                                    String sql,
                                    Serializable bean)

nativeQueryListAsync

default <V> CompletableFuture<List<V>> nativeQueryListAsync(Class<V> type,
                                                            String sql,
                                                            Serializable bean)

nativeQueryMap

default <K,V> Map<K,V> nativeQueryMap(Class<K> keyType,
                                                  Class<V> valType,
                                                  String sql,
                                                  Serializable bean)

nativeQueryMapAsync

default <K,V> CompletableFuture<Map<K,V>> nativeQueryMapAsync(Class<K> keyType,
                                                                          Class<V> valType,
                                                                          String sql,
                                                                          Serializable bean)

nativeQueryToStrStrMap

default Map<String,String> nativeQueryToStrStrMap(String sql,
                                                        Serializable bean)

nativeQueryToStrStrMapAsync

default CompletableFuture<Map<String,String>> nativeQueryToStrStrMapAsync(String sql,
                                                                                Serializable bean)

nativeQueryToIntStrMap

default Map<Integer,String> nativeQueryToIntStrMap(String sql,
                                                         Serializable bean)

nativeQueryToIntStrMapAsync

default CompletableFuture<Map<Integer,String>> nativeQueryToIntStrMapAsync(String sql,
                                                                                 Serializable bean)

nativeQuerySheet

default <V> Sheet<V> nativeQuerySheet(Class<V> type,
                                      String sql,
                                      RowBound round,
                                      Serializable bean)

nativeQuerySheetAsync

default <V> CompletableFuture<Sheet<V>> nativeQuerySheetAsync(Class<V> type,
                                                              String sql,
                                                              RowBound round,
                                                              Serializable bean)

nativeQuerySheet

default <V> Sheet<V> nativeQuerySheet(Class<V> type,
                                      String sql,
                                      PageBean pageBean)

nativeQuerySheetAsync

default <V> CompletableFuture<Sheet<V>> nativeQuerySheetAsync(Class<V> type,
                                                              String sql,
                                                              PageBean pageBean)