club.spreadme.database.dao

类 CrudOption

java.lang.Object

club.spreadme.database.dao.CrudOption

直接已知子类:

DefaultDao

public class CrudOption
extends java.lang.Object

Basic CRUD

从以下版本开始:

2018-6-21

作者:

Wangshuwei

构造器概要

构造器

构造器和说明
CrudOption(javax.sql.DataSource dataSource)
CrudOption(Executor executor)

方法概要

限定符和类型	方法和说明
void	addPlugin(Interceptor interceptor)
int[]	batch(java.lang.String... sqls) batch sql
int[]	batch(java.lang.String sql, java.util.List<java.lang.Object[]> objectss) batch sql
protected <T> T	query(PreparedStatementBuilder builder, ResultSetParser<T> parser)
<T> java.util.List<Record>	query(java.lang.String sql) Find list of record
<T> java.util.List<Record>	query(java.lang.String sql, java.lang.Object... objects)
protected <T> T	query(java.lang.String sql, ResultSetParser<T> resultSetParser)
<T> java.util.List<T>	query(java.lang.String sql, RowMapper<T> rowMapper)
<T> java.util.List<T>	query(java.lang.String sql, RowMapper<T> rowMapper, java.lang.Object... objects)
<T> Record	queryOne(java.lang.String sql) Find one record
<T> Record	queryOne(java.lang.String sql, java.lang.Object... objects) Find one record
<T> T	queryOne(java.lang.String sql, RowMapper<T> rowMapper)
<T> T	queryOne(java.lang.String sql, RowMapper<T> rowMapper, java.lang.Object... objects)
<T> void	queryStreamBean(java.lang.String sql, java.lang.Class<T> clazz, ResultSetStream<T> stream, java.lang.Object... objects)
<T> void	queryStreamRecord(java.lang.String sql, ResultSetStream<Record> stream, java.lang.Object... objects)
int	update(java.lang.String sql)
int	update(java.lang.String sql, java.lang.Object... objects)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

CrudOption

public CrudOption(javax.sql.DataSource dataSource)

参数:

dataSource - Datasource

CrudOption

public CrudOption(Executor executor)

参数:

executor - executor

方法详细资料

queryOne

public <T> Record queryOne(java.lang.String sql)

Find one record

参数:

sql - sql statement

返回:

Record

queryOne

public <T> Record queryOne(java.lang.String sql,
                           java.lang.Object... objects)

Find one record

参数:

sql - sql statement

objects - Parameters

返回:

Record

queryOne

public <T> T queryOne(java.lang.String sql,
                      RowMapper<T> rowMapper)

参数:

sql - Sql statement

rowMapper - ResultSet mapping to an object

返回:

Bean

queryOne

public <T> T queryOne(java.lang.String sql,
                      RowMapper<T> rowMapper,
                      java.lang.Object... objects)

参数:

sql - Sql statement

rowMapper - ResultSet mapping to an object

objects - Parameters

返回:

Bean

query

public <T> java.util.List<Record> query(java.lang.String sql)

Find list of record

参数:

sql - sql statement

返回:

list of record

query

public <T> java.util.List<Record> query(java.lang.String sql,
                                        java.lang.Object... objects)

参数:

sql - sql statement

objects - parameters

返回:

List of record

query

public <T> java.util.List<T> query(java.lang.String sql,
                                   RowMapper<T> rowMapper)

参数:

sql - Sql statement

rowMapper - ResultSet mapping to an object

返回:

List

query

public <T> java.util.List<T> query(java.lang.String sql,
                                   RowMapper<T> rowMapper,
                                   java.lang.Object... objects)

参数:

sql - Sql statement

rowMapper - ResultSet mapping to an object

objects - Paramters

返回:

List of bean

queryStreamRecord

public <T> void queryStreamRecord(java.lang.String sql,
                                  ResultSetStream<Record> stream,
                                  java.lang.Object... objects)

参数:

sql - Sql statement

stream - ResultSet Stream

objects - Paramters

queryStreamBean

public <T> void queryStreamBean(java.lang.String sql,
                                java.lang.Class<T> clazz,
                                ResultSetStream<T> stream,
                                java.lang.Object... objects)

参数:

sql - Sql statement

clazz - Class of bean

stream - ResultSet Stream

objects - Paramters

update

public int update(java.lang.String sql)

参数:

sql - Sql statement

返回:

Affected rows

update

public int update(java.lang.String sql,
                  java.lang.Object... objects)

参数:

sql - Sql statement

objects - Paramters

返回:

Affected rows

batch

public int[] batch(java.lang.String... sqls)

batch sql

batch

public int[] batch(java.lang.String sql,
                   java.util.List<java.lang.Object[]> objectss)

batch sql

参数:

sql - Sql statement

objectss - Paramters

返回:

Affected rows

addPlugin

public void addPlugin(Interceptor interceptor)

query

protected <T> T query(java.lang.String sql,
                      ResultSetParser<T> resultSetParser)

参数:

sql - sql statement

resultSetParser - Resutlset Parser

返回:

Object

query

protected <T> T query(PreparedStatementBuilder builder,
                      ResultSetParser<T> parser)

参数:

builder - PreparedStatement builder

parser - ResultSet Parser

返回:

Object