类的使用
org.redkale.util.Sheet

使用Sheet的程序包

程序包	说明
org.redkale.source	数据源(数据库、缓存)操作包
org.redkale.util	Redkale工具包

org.redkale.source中Sheet的使用

返回Sheet的org.redkale.source中的方法

修饰符和类型	方法	说明
<V> Sheet<V>	AbstractDataSqlSource.nativeQuerySheet(Class<V> type, String sql, RowBound round, Map<String,Object> params)
<V> Sheet<V>	DataJdbcSource.nativeQuerySheet(Class<V> type, String sql, Flipper flipper, Map<String,Object> params)
default <V> Sheet<V>	DataSqlSource.nativeQuerySheet(Class<V> type, String sql, PageBean pageBean)
default <V> Sheet<V>	DataSqlSource.nativeQuerySheet(Class<V> type, String sql, RowBound round)
default <V> Sheet<V>	DataSqlSource.nativeQuerySheet(Class<V> type, String sql, RowBound round, Serializable bean)
<V> Sheet<V>	DataSqlSource.nativeQuerySheet(Class<V> type, String sql, RowBound round, Map<String,Object> params)
<T,V extends Serializable> Sheet<V>	AbstractDataSource.queryColumnSheet(String selectedColumn, Class<T> clazz, Flipper flipper, FilterBean bean)	根据指定参数查询对象某个字段的集合
<T,V extends Serializable> Sheet<V>	AbstractDataSqlSource.queryColumnSheet(String selectedColumn, Class<T> clazz, Flipper flipper, FilterNode node)
<T,V extends Serializable> Sheet<V>	DataMemorySource.queryColumnSheet(String selectedColumn, Class<T> clazz, Flipper flipper, FilterNode node)
default <T,V extends Serializable> Sheet<V>	DataSource.queryColumnSheet(String selectedColumn, Class<T> clazz, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
<T,V extends Serializable> Sheet<V>	DataSource.queryColumnSheet(String selectedColumn, Class<T> clazz, Flipper flipper, FilterNode node)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T,V extends Serializable,F extends FilterBean> Sheet<V>	DataSource.queryColumnSheet(String selectedColumn, Class<T> clazz, PageBean<F> pageBean)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <V extends Serializable> Sheet<V>	DataSqlMapper.queryColumnSheet(String selectedColumn, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <V extends Serializable> Sheet<V>	DataSqlMapper.queryColumnSheet(String selectedColumn, Flipper flipper, FilterNode node)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
<T> Sheet<T>	AbstractDataSource.querySheet(Class<T> clazz, Flipper flipper, FilterBean bean)	根据过滤对象FilterBean和翻页对象Flipper查询一页的数据
<T> Sheet<T>	AbstractDataSource.querySheet(Class<T> clazz, Flipper flipper, FilterNode node)
<T> Sheet<T>	AbstractDataSource.querySheet(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterBean bean)	根据过滤对象FilterBean和翻页对象Flipper查询一页的数据， 对象只填充或排除SelectField指定的字段
protected <T> Sheet<T>	AbstractDataSqlSource.querySheet(boolean readCache, boolean needTotal, boolean distinct, Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)
<T> Sheet<T>	AbstractDataSqlSource.querySheet(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)
<T> Sheet<T>	DataMemorySource.querySheet(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)
default <T> Sheet<T>	DataSource.querySheet(Class<T> clazz, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T> Sheet<T>	DataSource.querySheet(Class<T> clazz, Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T,F extends FilterBean> Sheet<T>	DataSource.querySheet(Class<T> clazz, PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T> Sheet<T>	DataSource.querySheet(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
<T> Sheet<T>	DataSource.querySheet(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T,F extends FilterBean> Sheet<T>	DataSource.querySheet(Class<T> clazz, SelectColumn selects, PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default Sheet<T>	DataSqlMapper.querySheet(Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default Sheet<T>	DataSqlMapper.querySheet(Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <F extends FilterBean> Sheet<T>	DataSqlMapper.querySheet(PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default Sheet<T>	DataSqlMapper.querySheet(SelectColumn selects, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default Sheet<T>	DataSqlMapper.querySheet(SelectColumn selects, Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <F extends FilterBean> Sheet<T>	DataSqlMapper.querySheet(SelectColumn selects, PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
Sheet<T>	EntityCache.querySheet(boolean needTotal, boolean distinct, SelectColumn selects, Flipper flipper, FilterNode node)
Sheet<T>	EntityCache.querySheet(SelectColumn selects, Flipper flipper, FilterNode node)
protected <T> Sheet<T>	AbstractDataSqlSource.querySheetDB(EntityInfo<T> info, boolean readcache, boolean needtotal, boolean distinct, SelectColumn selects, Flipper flipper, FilterNode node)
protected <T> Sheet<T>	DataJdbcSource.querySheetDB(EntityInfo<T> info, boolean readCache, boolean needTotal, boolean distinct, SelectColumn selects, Flipper flipper, FilterNode node)
protected <T> Sheet<T>	DataJdbcSource.querySheetFullListDB(EntityInfo<T> info)

返回变量类型为Sheet的类型的org.redkale.source中的方法

修饰符和类型	方法	说明
<V> CompletableFuture<Sheet<V>>	DataJdbcSource.nativeQuerySheetAsync(Class<V> type, String sql, RowBound round, Map<String,Object> params)
default <V> CompletableFuture<Sheet<V>>	DataSqlSource.nativeQuerySheetAsync(Class<V> type, String sql, PageBean pageBean)
default <V> CompletableFuture<Sheet<V>>	DataSqlSource.nativeQuerySheetAsync(Class<V> type, String sql, RowBound round)
default <V> CompletableFuture<Sheet<V>>	DataSqlSource.nativeQuerySheetAsync(Class<V> type, String sql, RowBound round, Serializable bean)
<V> CompletableFuture<Sheet<V>>	DataSqlSource.nativeQuerySheetAsync(Class<V> type, String sql, RowBound round, Map<String,Object> params)
<T,V extends Serializable> CompletableFuture<Sheet<V>>	AbstractDataSource.queryColumnSheetAsync(String selectedColumn, Class<T> clazz, Flipper flipper, FilterBean bean)
<T,V extends Serializable> CompletableFuture<Sheet<V>>	AbstractDataSqlSource.queryColumnSheetAsync(String selectedColumn, Class<T> clazz, Flipper flipper, FilterNode node)
<T,V extends Serializable> CompletableFuture<Sheet<V>>	DataMemorySource.queryColumnSheetAsync(String selectedColumn, Class<T> clazz, Flipper flipper, FilterNode node)
default <T,V extends Serializable> CompletableFuture<Sheet<V>>	DataSource.queryColumnSheetAsync(String selectedColumn, Class<T> clazz, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
<T,V extends Serializable> CompletableFuture<Sheet<V>>	DataSource.queryColumnSheetAsync(String selectedColumn, Class<T> clazz, Flipper flipper, FilterNode node)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T,V extends Serializable,F extends FilterBean> CompletableFuture<Sheet<V>>	DataSource.queryColumnSheetAsync(String selectedColumn, Class<T> clazz, PageBean<F> pageBean)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <V extends Serializable> CompletableFuture<Sheet<V>>	DataSqlMapper.queryColumnSheetAsync(String selectedColumn, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <V extends Serializable> CompletableFuture<Sheet<V>>	DataSqlMapper.queryColumnSheetAsync(String selectedColumn, Flipper flipper, FilterNode node)	查询符合过滤条件记录的某个字段Sheet集合 等价SQL: SELECT {selectedColumn} FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
<T> CompletableFuture<Sheet<T>>	AbstractDataSource.querySheetAsync(Class<T> clazz, Flipper flipper, FilterBean bean)
<T> CompletableFuture<Sheet<T>>	AbstractDataSource.querySheetAsync(Class<T> clazz, Flipper flipper, FilterNode node)
<T> CompletableFuture<Sheet<T>>	AbstractDataSource.querySheetAsync(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterBean bean)
protected <T> CompletableFuture<Sheet<T>>	AbstractDataSqlSource.querySheetAsync(boolean readCache, boolean needTotal, boolean distinct, Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)
<T> CompletableFuture<Sheet<T>>	AbstractDataSqlSource.querySheetAsync(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)
<T> CompletableFuture<Sheet<T>>	DataMemorySource.querySheetAsync(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)
default <T> CompletableFuture<Sheet<T>>	DataSource.querySheetAsync(Class<T> clazz, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T> CompletableFuture<Sheet<T>>	DataSource.querySheetAsync(Class<T> clazz, Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T,F extends FilterBean> CompletableFuture<Sheet<T>>	DataSource.querySheetAsync(Class<T> clazz, PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T> CompletableFuture<Sheet<T>>	DataSource.querySheetAsync(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
<T> CompletableFuture<Sheet<T>>	DataSource.querySheetAsync(Class<T> clazz, SelectColumn selects, Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <T,F extends FilterBean> CompletableFuture<Sheet<T>>	DataSource.querySheetAsync(Class<T> clazz, SelectColumn selects, PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default CompletableFuture<Sheet<T>>	DataSqlMapper.querySheetAsync(Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default CompletableFuture<Sheet<T>>	DataSqlMapper.querySheetAsync(Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <F extends FilterBean> CompletableFuture<Sheet<T>>	DataSqlMapper.querySheetAsync(PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT * FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default CompletableFuture<Sheet<T>>	DataSqlMapper.querySheetAsync(SelectColumn selects, Flipper flipper, FilterBean bean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default CompletableFuture<Sheet<T>>	DataSqlMapper.querySheetAsync(SelectColumn selects, Flipper flipper, FilterNode node)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter node} ORDER BY {flipper.sort} LIMIT {flipper.limit}
default <F extends FilterBean> CompletableFuture<Sheet<T>>	DataSqlMapper.querySheetAsync(SelectColumn selects, PageBean<F> pageBean)	查询符合过滤条件记录的Sheet集合 等价SQL: SELECT {column1},{column2}, ··· FROM {table} WHERE {filter bean} ORDER BY {flipper.sort} LIMIT {flipper.limit}
protected abstract <T> CompletableFuture<Sheet<T>>	AbstractDataSqlSource.querySheetDBAsync(EntityInfo<T> info, boolean readcache, boolean needtotal, boolean distinct, SelectColumn selects, Flipper flipper, FilterNode node, boolean inCacheLoad)
protected <T> CompletableFuture<Sheet<T>>	DataJdbcSource.querySheetDBAsync(EntityInfo<T> info, boolean readCache, boolean needTotal, boolean distinct, SelectColumn selects, Flipper flipper, FilterNode node, boolean inCacheLoad)

org.redkale.util中Sheet的使用

返回Sheet的org.redkale.util中的方法

修饰符和类型	方法	说明
static <E> Sheet<E>	Sheet.asSheet(Collection<E> data)
Sheet<T>	Sheet.copyTo(Sheet<T> copy)
static <E> Sheet<E>	Sheet.empty()
<R> Sheet<R>	Sheet.map(Function<T,R> mapper)

参数类型为Sheet的org.redkale.util中的方法

修饰符和类型	方法	说明
Sheet<T>	Sheet.copyTo(Sheet<T> copy)