SQLExecutor.Mapper (abacus API Documentation)

java.lang.Object
- com.landawn.abacus.util.SQLExecutor.Mapper<T>

Type Parameters:

T -

Enclosing class:

SQLExecutor
```
public static final class SQLExecutor.Mapper<T>
extends java.lang.Object
```
Author:

haiyang li

See Also:

com.landawn.abacus.annotation.ReadOnly}, com.landawn.abacus.annotation.ReadOnlyId}, com.landawn.abacus.annotation.NonUpdatable}, com.landawn.abacus.annotation.Transient}, com.landawn.abacus.annotation.Table}, com.landawn.abacus.annotation.Column}, http://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html, http://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html, http://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html, http://docs.oracle.com/javase/8/docs/api/java/sql/ResultSet.html

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`<ID> ID`	`add(java.sql.Connection conn, java.util.Map<java.lang.String,java.lang.Object> props)`
`<ID> ID`	`add(java.sql.Connection conn, T entity)`
`<ID> ID`	`add(java.sql.Connection conn, T entity, java.util.Collection<java.lang.String> insertPropNames)`
`<ID> ID`	`add(java.util.Map<java.lang.String,java.lang.Object> props)`
`<ID> ID`	`add(T entity)` Insert the specified entity into data store, and set back the auto-generated id to the specified entity if there is the auto-generated id.
`<ID> ID`	`add(T entity, java.util.Collection<java.lang.String> insertPropNames)`
`T`	`addOrUpdate(T entity)` Execute `add` and return the added entity if the record doesn't, otherwise, `update` is executed and updated db record is returned.
`T`	`addOrUpdate(T entity, Condition whereCause)` Execute `add` and return the added entity if the record doesn't, otherwise, `update` is executed and updated db record is returned.
`SQLExecutor.AsyncMapper<T>`	`async()`
`<ID> java.util.List<ID>`	`batchAdd(java.util.Collection<? extends T> entities)` Insert All the records by batch operation.
`<ID> java.util.List<ID>`	`batchAdd(java.util.Collection<? extends T> entities, int batchSize)`
`<ID> java.util.List<ID>`	`batchAdd(java.util.Collection<? extends T> entities, int batchSize, IsolationLevel isolationLevel)`
`<ID> java.util.List<ID>`	`batchAdd(java.sql.Connection conn, java.util.Collection<? extends T> entities)`
`<ID> java.util.List<ID>`	`batchAdd(java.sql.Connection conn, java.util.Collection<? extends T> entities, int batchSize)` Insert All the records by batch operation.
`int`	`batchDelete(java.util.Collection<?> idsOrEntities)` Delete all the records by batch operation.
`int`	`batchDelete(java.util.Collection<?> idsOrEntities, int batchSize)` Delete all the records by batch operation.
`int`	`batchDelete(java.util.Collection<?> idsOrEntities, int batchSize, IsolationLevel isolationLevel)` Delete all the records by batch operation.
`int`	`batchDelete(java.sql.Connection conn, java.util.Collection<?> idsOrEntities)` Delete all the records by batch operation.
`int`	`batchDelete(java.sql.Connection conn, java.util.Collection<?> idsOrEntities, int batchSize)` Delete all the records by batch operation.
`java.util.List<T>`	`batchGet(java.sql.Connection conn, java.util.List<?> ids, java.util.Collection<java.lang.String> selectPropNames, int batchSize)`
`java.util.List<T>`	`batchGet(java.util.List<?> ids)`
`java.util.List<T>`	`batchGet(java.util.List<?> ids, java.util.Collection<java.lang.String> selectPropNames)`
`java.util.List<T>`	`batchGet(java.util.List<?> ids, java.util.Collection<java.lang.String> selectPropNames, int batchSize)`
`int`	`batchUpdate(java.util.Collection<? extends T> entities)` Update All the records by batch operation.
`int`	`batchUpdate(java.util.Collection<? extends T> entities, java.util.Collection<java.lang.String> updatePropNames)`
`int`	`batchUpdate(java.util.Collection<? extends T> entities, java.util.Collection<java.lang.String> updatePropNames, int batchSize)` Update All the records by batch operation.
`int`	`batchUpdate(java.util.Collection<? extends T> entities, java.util.Collection<java.lang.String> updatePropNames, int batchSize, IsolationLevel isolationLevel)`
`int`	`batchUpdate(java.util.Collection<? extends T> entities, int batchSize)`
`int`	`batchUpdate(java.util.Collection<? extends T> entities, int batchSize, IsolationLevel isolationLevel)`
`int`	`batchUpdate(java.sql.Connection conn, java.util.Collection<? extends T> entities)`
`int`	`batchUpdate(java.sql.Connection conn, java.util.Collection<? extends T> entities, java.util.Collection<java.lang.String> updatePropNames)`
`int`	`batchUpdate(java.sql.Connection conn, java.util.Collection<? extends T> entities, java.util.Collection<java.lang.String> updatePropNames, int batchSize)`
`int`	`batchUpdate(java.sql.Connection conn, java.util.Collection<? extends T> entities, int batchSize)`
`int`	`count(Condition whereCause)`
`int`	`count(java.sql.Connection conn, Condition whereCause)`
`int`	`delete(Condition whereCause)`
`int`	`delete(java.sql.Connection conn, Condition whereCause)`
`int`	`delete(java.sql.Connection conn, java.lang.Object idOrEntity)`
`int`	`delete(java.lang.Object idOrEntity)`
`boolean`	`exists(Condition whereCause)`
`boolean`	`exists(java.sql.Connection conn, Condition whereCause)`
`boolean`	`exists(java.sql.Connection conn, java.lang.Object id)`
`boolean`	`exists(java.lang.Object id)`
`u.Optional<T>`	`findFirst(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause)`
`u.Optional<T>`	`findFirst(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> u.Optional<R>`	`findFirst(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> u.Optional<R>`	`findFirst(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`u.Optional<T>`	`findFirst(Condition whereCause)`
`u.Optional<T>`	`findFirst(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, Condition whereCause)`
`u.Optional<T>`	`findFirst(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`u.Optional<T>`	`findFirst(java.sql.Connection conn, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> u.Optional<R>`	`findFirst(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> u.Optional<R>`	`findFirst(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> u.Optional<R>`	`findFirst(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`u.Optional<T>`	`get(java.sql.Connection conn, java.lang.Object id, java.util.Collection<java.lang.String> selectPropNames)`
`u.Optional<T>`	`get(java.lang.Object id)`
`u.Optional<T>`	`get(java.lang.Object id, java.util.Collection<java.lang.String> selectPropNames)`
`T`	`gett(java.sql.Connection conn, java.lang.Object id, java.util.Collection<java.lang.String> selectPropNames)`
`T`	`gett(java.lang.Object id)`
`T`	`gett(java.lang.Object id, java.util.Collection<java.lang.String> selectPropNames)`
`java.util.List<java.lang.String>`	`idPropNameList()`
`java.util.Set<java.lang.String>`	`idPropNameSet()`
`java.util.List<T>`	`list(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause)`
`java.util.List<T>`	`list(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`list(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`list(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`java.util.List<T>`	`list(Condition whereCause)`
`java.util.List<T>`	`list(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, Condition whereCause)`
`java.util.List<T>`	`list(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`java.util.List<T>`	`list(java.sql.Connection conn, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.sql.Connection conn, java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`list(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`list(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)`
`<R> java.util.List<R>`	`list(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`java.util.List<T>`	`listAll(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`<R> java.util.List<R>`	`listAll(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`listAll(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`java.util.List<T>`	`listAll(Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`<R> java.util.List<R>`	`listAll(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<R> java.util.List<R>`	`listAll(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`java.util.List<java.lang.String>`	`propNameList()`
`java.util.Set<java.lang.String>`	`propNameSet()`
`DataSet`	`query(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause)`
`DataSet`	`query(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`DataSet`	`query(Condition whereCause)`
`DataSet`	`query(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, Condition whereCause)`
`DataSet`	`query(java.sql.Connection conn, java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`DataSet`	`query(java.sql.Connection conn, Condition whereCause)`
`DataSet`	`queryAll(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`DataSet`	`queryAll(Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`u.Nullable<java.math.BigDecimal>`	`queryForBigDecimal(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalBoolean`	`queryForBoolean(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalByte`	`queryForByte(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalChar`	`queryForChar(java.lang.String selectPropName, Condition whereCause)`
`u.Nullable<java.sql.Date>`	`queryForDate(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalDouble`	`queryForDouble(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalFloat`	`queryForFloat(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalInt`	`queryForInt(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalLong`	`queryForLong(java.lang.String selectPropName, Condition whereCause)`
`u.OptionalShort`	`queryForShort(java.lang.String selectPropName, Condition whereCause)`
`<V> u.Nullable<V>`	`queryForSingleResult(java.lang.Class<V> targetValueClass, java.sql.Connection conn, java.lang.String selectPropName, Condition whereCause)`
`<V> u.Nullable<V>`	`queryForSingleResult(java.lang.Class<V> targetValueClass, java.sql.Connection conn, java.lang.String selectPropName, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Returns a `Nullable` describing the value in the first row/column if it exists, otherwise return an empty `Nullable`.
`<V> u.Nullable<V>`	`queryForSingleResult(java.lang.Class<V> targetValueClass, java.sql.Connection conn, java.lang.String selectPropName, java.lang.Object id)`
`<V> u.Nullable<V>`	`queryForSingleResult(java.lang.Class<V> targetValueClass, java.lang.String selectPropName, Condition whereCause)`
`<V> u.Nullable<V>`	`queryForSingleResult(java.lang.Class<V> targetValueClass, java.lang.String selectPropName, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<V> u.Nullable<V>`	`queryForSingleResult(java.lang.Class<V> targetValueClass, java.lang.String selectPropName, java.lang.Object id)`
`u.Nullable<java.lang.String>`	`queryForString(java.lang.String selectPropName, Condition whereCause)`
`u.Nullable<java.sql.Time>`	`queryForTime(java.lang.String selectPropName, Condition whereCause)`
`u.Nullable<java.sql.Timestamp>`	`queryForTimestamp(java.lang.String selectPropName, Condition whereCause)`
`<V> u.Nullable<V>`	`queryForUniqueResult(java.lang.Class<V> targetValueClass, java.sql.Connection conn, java.lang.String selectPropName, Condition whereCause)`
`<V> u.Nullable<V>`	`queryForUniqueResult(java.lang.Class<V> targetValueClass, java.sql.Connection conn, java.lang.String selectPropName, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<V> u.Nullable<V>`	`queryForUniqueResult(java.lang.Class<V> targetValueClass, java.sql.Connection conn, java.lang.String selectPropName, java.lang.Object id)`
`<V> u.Nullable<V>`	`queryForUniqueResult(java.lang.Class<V> targetValueClass, java.lang.String selectPropName, Condition whereCause)`
`<V> u.Nullable<V>`	`queryForUniqueResult(java.lang.Class<V> targetValueClass, java.lang.String selectPropName, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)`
`<V> u.Nullable<V>`	`queryForUniqueResult(java.lang.Class<V> targetValueClass, java.lang.String selectPropName, java.lang.Object id)`
`boolean`	`refresh(T entity)`
`boolean`	`refresh(T entity, java.util.Collection<java.lang.String> refreshPropNames)`
`Stream<T>`	`stream(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`Stream<T>`	`stream(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`Stream<T>`	`stream(Condition whereCause)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`<R> Stream<R>`	`stream(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Remember to close the returned `Stream` to close the underlying `ResultSet`.
`Stream<T>`	`streamAll(java.util.Collection<java.lang.String> selectPropNames, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`<R> Stream<R>`	`streamAll(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`<R> Stream<R>`	`streamAll(java.util.Collection<java.lang.String> selectPropNames, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`Stream<T>`	`streamAll(Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`<R> Stream<R>`	`streamAll(java.lang.String selectPropName, JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`<R> Stream<R>`	`streamAll(java.lang.String selectPropName, JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper, Condition whereCause, SQLExecutor.JdbcSettings jdbcSettings)` Query from multiple data sources specified in `JdbcSettings`.
`java.lang.Class<T>`	`targetClass()`
`com.landawn.abacus.type.Type<T>`	`targetType()`
`java.lang.String`	`toStirng()`
`int`	`update(java.sql.Connection conn, java.util.Map<java.lang.String,java.lang.Object> props, Condition whereCause)`
`int`	`update(java.sql.Connection conn, java.lang.Object id, java.util.Map<java.lang.String,java.lang.Object> props)`
`int`	`update(java.sql.Connection conn, T entity)`
`int`	`update(java.sql.Connection conn, T entity, java.util.Collection<java.lang.String> updatePropNames)`
`int`	`update(java.util.Map<java.lang.String,java.lang.Object> props, Condition whereCause)`
`int`	`update(java.lang.Object id, java.util.Map<java.lang.String,java.lang.Object> props)`
`int`	`update(T entity)`
`int`	`update(T entity, java.util.Collection<java.lang.String> updatePropNames)`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

targetClass

public java.lang.Class<T> targetClass()

targetType

public com.landawn.abacus.type.Type<T> targetType()

idPropNameList

public java.util.List<java.lang.String> idPropNameList()

idPropNameSet

public java.util.Set<java.lang.String> idPropNameSet()

propNameList

public java.util.List<java.lang.String> propNameList()

propNameSet

public java.util.Set<java.lang.String> propNameSet()

async

public SQLExecutor.AsyncMapper<T> async()

exists
```
public boolean exists(java.lang.Object id)
```
Parameters:

id - which could be Number/String... or Entity/Map for composed id.

Returns:

exists

public boolean exists(Condition whereCause)

exists

public boolean exists(java.sql.Connection conn,
                      java.lang.Object id)

exists

public boolean exists(java.sql.Connection conn,
                      Condition whereCause)

count

public int count(Condition whereCause)

count

public int count(java.sql.Connection conn,
                 Condition whereCause)

get
```
public u.Optional<T> get(java.lang.Object id)
```
Parameters:

id - which could be Number/String... or Entity/Map for composed id.

Returns:

get

public u.Optional<T> get(java.lang.Object id,
                         java.util.Collection<java.lang.String> selectPropNames)

Parameters:: id - which could be Number/String... or Entity/Map for composed id.; selectPropNames -
Returns:

get

public u.Optional<T> get(java.sql.Connection conn,
                         java.lang.Object id,
                         java.util.Collection<java.lang.String> selectPropNames)

Parameters:: conn -; id - which could be Number/String... or Entity/Map for composed id.; selectPropNames -
Returns:

gett
```
public T gett(java.lang.Object id)
```
Parameters:

id - which could be Number/String... or Entity/Map for composed id.

Returns:

gett

public T gett(java.lang.Object id,
              java.util.Collection<java.lang.String> selectPropNames)

Parameters:: id - which could be Number/String... or Entity/Map for composed id.; selectPropNames -
Returns:

gett

public T gett(java.sql.Connection conn,
              java.lang.Object id,
              java.util.Collection<java.lang.String> selectPropNames)

Parameters:: conn -; id - which could be Number/String... or Entity/Map for composed id.; selectPropNames -
Returns:

batchGet

public java.util.List<T> batchGet(java.util.List<?> ids)

Parameters:: ids -
Returns:

batchGet

public java.util.List<T> batchGet(java.util.List<?> ids,
                                  java.util.Collection<java.lang.String> selectPropNames)

Parameters:: ids -; selectPropNames -
Returns:

batchGet

public java.util.List<T> batchGet(java.util.List<?> ids,
                                  java.util.Collection<java.lang.String> selectPropNames,
                                  int batchSize)

Parameters:: ids -; selectPropNames -; batchSize -
Returns:

batchGet

public java.util.List<T> batchGet(java.sql.Connection conn,
                                  java.util.List<?> ids,
                                  java.util.Collection<java.lang.String> selectPropNames,
                                  int batchSize)

Parameters:: conn -; ids -; selectPropNames -; batchSize -
Returns:

findFirst

public u.Optional<T> findFirst(Condition whereCause)

findFirst

public u.Optional<T> findFirst(java.util.Collection<java.lang.String> selectPropNames,
                               Condition whereCause)

findFirst

public u.Optional<T> findFirst(java.util.Collection<java.lang.String> selectPropNames,
                               Condition whereCause,
                               SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public u.Optional<T> findFirst(java.sql.Connection conn,
                               Condition whereCause)

findFirst

public u.Optional<T> findFirst(java.sql.Connection conn,
                               java.util.Collection<java.lang.String> selectPropNames,
                               Condition whereCause)

findFirst

public u.Optional<T> findFirst(java.sql.Connection conn,
                               java.util.Collection<java.lang.String> selectPropNames,
                               Condition whereCause,
                               SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.lang.String selectPropName,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.lang.String selectPropName,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.lang.String selectPropName,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.lang.String selectPropName,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.lang.String selectPropName,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.lang.String selectPropName,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.lang.String selectPropName,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.lang.String selectPropName,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause)

findFirst

public <R> u.Optional<R> findFirst(java.sql.Connection conn,
                                   java.util.Collection<java.lang.String> selectPropNames,
                                   JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                   Condition whereCause,
                                   SQLExecutor.JdbcSettings jdbcSettings)

list

public java.util.List<T> list(Condition whereCause)

list

public java.util.List<T> list(java.util.Collection<java.lang.String> selectPropNames,
                              Condition whereCause)

list

public java.util.List<T> list(java.util.Collection<java.lang.String> selectPropNames,
                              Condition whereCause,
                              SQLExecutor.JdbcSettings jdbcSettings)

list

public java.util.List<T> list(java.sql.Connection conn,
                              Condition whereCause)

list

public java.util.List<T> list(java.sql.Connection conn,
                              java.util.Collection<java.lang.String> selectPropNames,
                              Condition whereCause)

list

public java.util.List<T> list(java.sql.Connection conn,
                              java.util.Collection<java.lang.String> selectPropNames,
                              Condition whereCause,
                              SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.lang.String selectPropName,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.lang.String selectPropName,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.lang.String selectPropName,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.lang.String selectPropName,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.lang.String selectPropName,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.lang.String selectPropName,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.lang.String selectPropName,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.lang.String selectPropName,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause)

list

public <R> java.util.List<R> list(java.sql.Connection conn,
                                  java.util.Collection<java.lang.String> selectPropNames,
                                  JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                  Condition whereCause,
                                  SQLExecutor.JdbcSettings jdbcSettings)

listAll
```
public java.util.List<T> listAll(Condition whereCause,
                                 SQLExecutor.JdbcSettings jdbcSettings)
```
Query from multiple data sources specified in JdbcSettings.

Parameters:

whereCause -

jdbcSettings -

Returns:

See Also:

SQLExecutor.listAll(Class, String, StatementSetter, JdbcSettings, Object...)

listAll

public java.util.List<T> listAll(java.util.Collection<java.lang.String> selectPropNames,
                                 Condition whereCause,
                                 SQLExecutor.JdbcSettings jdbcSettings)

Query from multiple data sources specified in JdbcSettings.

Parameters:: selectPropNames -; whereCause -; jdbcSettings -
Returns:
See Also:: SQLExecutor.listAll(Class, String, StatementSetter, JdbcSettings, Object...)

listAll

public <R> java.util.List<R> listAll(java.lang.String selectPropName,
                                     JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                     Condition whereCause,
                                     SQLExecutor.JdbcSettings jdbcSettings)

listAll

public <R> java.util.List<R> listAll(java.lang.String selectPropName,
                                     JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                     Condition whereCause,
                                     SQLExecutor.JdbcSettings jdbcSettings)

listAll

public <R> java.util.List<R> listAll(java.util.Collection<java.lang.String> selectPropNames,
                                     JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                                     Condition whereCause,
                                     SQLExecutor.JdbcSettings jdbcSettings)

listAll

public <R> java.util.List<R> listAll(java.util.Collection<java.lang.String> selectPropNames,
                                     JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                                     Condition whereCause,
                                     SQLExecutor.JdbcSettings jdbcSettings)

stream
```
public Stream<T> stream(Condition whereCause)
```
Remember to close the returned Stream to close the underlying ResultSet. stream operation won't be part of transaction or use the connection created by Transaction even it's in transaction block/range.

Parameters:

whereCause -

Returns:

stream
```
public Stream<T> stream(java.util.Collection<java.lang.String> selectPropNames,
                        Condition whereCause)
```
Remember to close the returned Stream to close the underlying ResultSet. stream operation won't be part of transaction or use the connection created by Transaction even it's in transaction block/range.

Parameters:

selectPropNames -

whereCause -

Returns:

stream
```
public Stream<T> stream(java.util.Collection<java.lang.String> selectPropNames,
                        Condition whereCause,
                        SQLExecutor.JdbcSettings jdbcSettings)
```
Remember to close the returned Stream to close the underlying ResultSet. stream operation won't be part of transaction or use the connection created by Transaction even it's in transaction block/range.

Parameters:

selectPropNames -

whereCause -

jdbcSettings -

Returns:

stream

public <R> Stream<R> stream(java.lang.String selectPropName,
                            JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause)

Remember to close the returned Stream to close the underlying ResultSet. stream operation won't be part of transaction or use the connection created by Transaction even it's in transaction block/range.

Parameters:: selectPropName -; rowMapper -; whereCause -
Returns:

stream

public <R> Stream<R> stream(java.lang.String selectPropName,
                            JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause,
                            SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: selectPropName -; rowMapper -; whereCause -; jdbcSettings -
Returns:

stream

public <R> Stream<R> stream(java.lang.String selectPropName,
                            JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause)

Parameters:: selectPropName -; rowMapper -; whereCause -
Returns:

stream

public <R> Stream<R> stream(java.lang.String selectPropName,
                            JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause,
                            SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: selectPropName -; rowMapper -; whereCause -; jdbcSettings -
Returns:

stream

public <R> Stream<R> stream(java.util.Collection<java.lang.String> selectPropNames,
                            JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause)

Parameters:: selectPropNames -; rowMapper -; whereCause -
Returns:

stream

public <R> Stream<R> stream(java.util.Collection<java.lang.String> selectPropNames,
                            JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause,
                            SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: selectPropNames -; rowMapper -; whereCause -; jdbcSettings -
Returns:

stream

public <R> Stream<R> stream(java.util.Collection<java.lang.String> selectPropNames,
                            JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause)

Parameters:: selectPropNames -; rowMapper -; whereCause -
Returns:

stream

public <R> Stream<R> stream(java.util.Collection<java.lang.String> selectPropNames,
                            JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                            Condition whereCause,
                            SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: selectPropNames -; rowMapper -; whereCause -; jdbcSettings -
Returns:

streamAll
```
public Stream<T> streamAll(Condition whereCause,
                           SQLExecutor.JdbcSettings jdbcSettings)
```
Query from multiple data sources specified in JdbcSettings. Remember to close the returned Stream to close the underlying ResultSet. stream operation won't be part of transaction or use the connection created by Transaction even it's in transaction block/range.

Parameters:

whereCause -

jdbcSettings -

Returns:

See Also:

SQLExecutor.streamAll(Class, String, StatementSetter, JdbcSettings, Object...)

streamAll
```
public Stream<T> streamAll(java.util.Collection<java.lang.String> selectPropNames,
                           Condition whereCause,
                           SQLExecutor.JdbcSettings jdbcSettings)
```
Query from multiple data sources specified in JdbcSettings. Remember to close the returned Stream to close the underlying ResultSet. stream operation won't be part of transaction or use the connection created by Transaction even it's in transaction block/range.

Parameters:

selectPropNames -

whereCause -

jdbcSettings -

Returns:

See Also:

SQLExecutor.streamAll(Class, String, StatementSetter, JdbcSettings, Object...)

streamAll

public <R> Stream<R> streamAll(java.lang.String selectPropName,
                               JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                               Condition whereCause,
                               SQLExecutor.JdbcSettings jdbcSettings)

Query from multiple data sources specified in JdbcSettings. Remember to close the returned Stream to close the underlying ResultSet. stream operation won't be part of transaction or use the connection created by Transaction even it's in transaction block/range.

Parameters:: selectPropName -; rowMapper -; whereCause -; jdbcSettings -
Returns:

streamAll

public <R> Stream<R> streamAll(java.lang.String selectPropName,
                               JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                               Condition whereCause,
                               SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: selectPropName -; rowMapper -; whereCause -; jdbcSettings -
Returns:

streamAll

public <R> Stream<R> streamAll(java.util.Collection<java.lang.String> selectPropNames,
                               JdbcUtil.RowMapper<R,java.lang.RuntimeException> rowMapper,
                               Condition whereCause,
                               SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: selectPropNames -; rowMapper -; whereCause -; jdbcSettings -
Returns:

streamAll

public <R> Stream<R> streamAll(java.util.Collection<java.lang.String> selectPropNames,
                               JdbcUtil.BiRowMapper<R,java.lang.RuntimeException> rowMapper,
                               Condition whereCause,
                               SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: selectPropNames -; rowMapper -; whereCause -; jdbcSettings -
Returns:

query

public DataSet query(Condition whereCause)

query

public DataSet query(java.util.Collection<java.lang.String> selectPropNames,
                     Condition whereCause)

query

public DataSet query(java.util.Collection<java.lang.String> selectPropNames,
                     Condition whereCause,
                     SQLExecutor.JdbcSettings jdbcSettings)

query

public DataSet query(java.sql.Connection conn,
                     Condition whereCause)

query

public DataSet query(java.sql.Connection conn,
                     java.util.Collection<java.lang.String> selectPropNames,
                     Condition whereCause)

query

public DataSet query(java.sql.Connection conn,
                     java.util.Collection<java.lang.String> selectPropNames,
                     Condition whereCause,
                     SQLExecutor.JdbcSettings jdbcSettings)

queryAll
```
public DataSet queryAll(Condition whereCause,
                        SQLExecutor.JdbcSettings jdbcSettings)
```
Query from multiple data sources specified in JdbcSettings.

Parameters:

whereCause -

jdbcSettings -

Returns:

See Also:

SQLExecutor.queryAll(String, StatementSetter, JdbcSettings, Object...)

queryAll

public DataSet queryAll(java.util.Collection<java.lang.String> selectPropNames,
                        Condition whereCause,
                        SQLExecutor.JdbcSettings jdbcSettings)

Query from multiple data sources specified in JdbcSettings.

Parameters:: selectPropNames -; whereCause -; jdbcSettings -
Returns:
See Also:: SQLExecutor.queryAll(String, StatementSetter, JdbcSettings, Object...)

queryForBoolean

public u.OptionalBoolean queryForBoolean(java.lang.String selectPropName,
                                         Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForChar

public u.OptionalChar queryForChar(java.lang.String selectPropName,
                                   Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForByte

public u.OptionalByte queryForByte(java.lang.String selectPropName,
                                   Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForShort

public u.OptionalShort queryForShort(java.lang.String selectPropName,
                                     Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForInt

public u.OptionalInt queryForInt(java.lang.String selectPropName,
                                 Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForLong

public u.OptionalLong queryForLong(java.lang.String selectPropName,
                                   Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForFloat

public u.OptionalFloat queryForFloat(java.lang.String selectPropName,
                                     Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForDouble

public u.OptionalDouble queryForDouble(java.lang.String selectPropName,
                                       Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForBigDecimal

public u.Nullable<java.math.BigDecimal> queryForBigDecimal(java.lang.String selectPropName,
                                                           Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForString

public u.Nullable<java.lang.String> queryForString(java.lang.String selectPropName,
                                                   Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForDate

public u.Nullable<java.sql.Date> queryForDate(java.lang.String selectPropName,
                                              Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForTime

public u.Nullable<java.sql.Time> queryForTime(java.lang.String selectPropName,
                                              Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForTimestamp

public u.Nullable<java.sql.Timestamp> queryForTimestamp(java.lang.String selectPropName,
                                                        Condition whereCause)

Parameters:: selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForSingleResult

public <V> u.Nullable<V> queryForSingleResult(java.lang.Class<V> targetValueClass,
                                              java.lang.String selectPropName,
                                              java.lang.Object id)

Parameters:: targetValueClass -; selectPropName -; id -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForSingleResult

public <V> u.Nullable<V> queryForSingleResult(java.lang.Class<V> targetValueClass,
                                              java.lang.String selectPropName,
                                              Condition whereCause)

Parameters:: targetValueClass -; selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForSingleResult

public <V> u.Nullable<V> queryForSingleResult(java.lang.Class<V> targetValueClass,
                                              java.lang.String selectPropName,
                                              Condition whereCause,
                                              SQLExecutor.JdbcSettings jdbcSettings)

Parameters:: targetValueClass -; selectPropName -; whereCause -; jdbcSettings -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForSingleResult

public <V> u.Nullable<V> queryForSingleResult(java.lang.Class<V> targetValueClass,
                                              java.sql.Connection conn,
                                              java.lang.String selectPropName,
                                              java.lang.Object id)

Parameters:: targetValueClass -; conn -; selectPropName -; id -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForSingleResult

public <V> u.Nullable<V> queryForSingleResult(java.lang.Class<V> targetValueClass,
                                              java.sql.Connection conn,
                                              java.lang.String selectPropName,
                                              Condition whereCause)

Parameters:: targetValueClass -; conn -; selectPropName -; whereCause -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForSingleResult

public <V> u.Nullable<V> queryForSingleResult(java.lang.Class<V> targetValueClass,
                                              java.sql.Connection conn,
                                              java.lang.String selectPropName,
                                              Condition whereCause,
                                              SQLExecutor.JdbcSettings jdbcSettings)

Returns a Nullable describing the value in the first row/column if it exists, otherwise return an empty Nullable.

Parameters:: targetValueClass -; conn -; selectPropName -; whereCause -; jdbcSettings -
Returns:
See Also:: Mapper#queryForSingleResult(Class, Connection, String, Condition, JdbcSettings)

queryForUniqueResult

public <V> u.Nullable<V> queryForUniqueResult(java.lang.Class<V> targetValueClass,
                                              java.lang.String selectPropName,
                                              java.lang.Object id)
                                       throws DuplicatedResultException

Throws:: DuplicatedResultException

queryForUniqueResult

public <V> u.Nullable<V> queryForUniqueResult(java.lang.Class<V> targetValueClass,
                                              java.lang.String selectPropName,
                                              Condition whereCause)
                                       throws DuplicatedResultException

Throws:: DuplicatedResultException

queryForUniqueResult

public <V> u.Nullable<V> queryForUniqueResult(java.lang.Class<V> targetValueClass,
                                              java.lang.String selectPropName,
                                              Condition whereCause,
                                              SQLExecutor.JdbcSettings jdbcSettings)
                                       throws DuplicatedResultException

Throws:: DuplicatedResultException

queryForUniqueResult

public <V> u.Nullable<V> queryForUniqueResult(java.lang.Class<V> targetValueClass,
                                              java.sql.Connection conn,
                                              java.lang.String selectPropName,
                                              java.lang.Object id)
                                       throws DuplicatedResultException

Throws:: DuplicatedResultException

queryForUniqueResult

public <V> u.Nullable<V> queryForUniqueResult(java.lang.Class<V> targetValueClass,
                                              java.sql.Connection conn,
                                              java.lang.String selectPropName,
                                              Condition whereCause)
                                       throws DuplicatedResultException

Throws:: DuplicatedResultException

queryForUniqueResult

public <V> u.Nullable<V> queryForUniqueResult(java.lang.Class<V> targetValueClass,
                                              java.sql.Connection conn,
                                              java.lang.String selectPropName,
                                              Condition whereCause,
                                              SQLExecutor.JdbcSettings jdbcSettings)
                                       throws DuplicatedResultException

Throws:: DuplicatedResultException

add
```
public <ID> ID add(T entity)
```
Insert the specified entity into data store, and set back the auto-generated id to the specified entity if there is the auto-generated id.

Parameters:

entity -

Returns:

the auto-generated id or null if there is no auto-generated id.

add

public <ID> ID add(T entity,
                   java.util.Collection<java.lang.String> insertPropNames)

add
```
public <ID> ID add(java.util.Map<java.lang.String,java.lang.Object> props)
```
Parameters:

props -

Returns:

the auto-generated id or null if there is no auto-generated id.

add

public <ID> ID add(java.sql.Connection conn,
                   T entity)

add

public <ID> ID add(java.sql.Connection conn,
                   T entity,
                   java.util.Collection<java.lang.String> insertPropNames)

add

public <ID> ID add(java.sql.Connection conn,
                   java.util.Map<java.lang.String,java.lang.Object> props)

Parameters:: conn -; props -
Returns:: the auto-generated id or null if there is no auto-generated id.

batchAdd
```
public <ID> java.util.List<ID> batchAdd(java.util.Collection<? extends T> entities)
```
Insert All the records by batch operation. And set back auto-generated ids to the specified entities if there are the auto-generated ids.

Parameters:

entities - which must have the same updated properties set.

Returns:

the auto-generated id list or an empty list if there is no auto-generated id.

batchAdd

public <ID> java.util.List<ID> batchAdd(java.util.Collection<? extends T> entities,
                                        int batchSize)

batchAdd

public <ID> java.util.List<ID> batchAdd(java.util.Collection<? extends T> entities,
                                        int batchSize,
                                        IsolationLevel isolationLevel)

batchAdd

public <ID> java.util.List<ID> batchAdd(java.sql.Connection conn,
                                        java.util.Collection<? extends T> entities)

batchAdd
```
public <ID> java.util.List<ID> batchAdd(java.sql.Connection conn,
                                        java.util.Collection<? extends T> entities,
                                        int batchSize)
```
Insert All the records by batch operation. And set back auto-generated ids to the specified entities if there are the auto-generated ids.

Parameters:

entities - which must have the same updated properties set.

batchSize - Default value is 200.

Returns:

the auto-generated id list or an empty list if there is no auto-generated id.

addOrUpdate
```
public T addOrUpdate(T entity)
```
Execute add and return the added entity if the record doesn't, otherwise, update is executed and updated db record is returned.

Parameters:

entity -

Returns:

addOrUpdate
```
public T addOrUpdate(T entity,
                     Condition whereCause)
```
Execute add and return the added entity if the record doesn't, otherwise, update is executed and updated db record is returned.

Parameters:

entity -

whereCause - to verify if the record exists or not.

Returns:

refresh
```
public boolean refresh(T entity)
```

refresh

public boolean refresh(T entity,
                       java.util.Collection<java.lang.String> refreshPropNames)

Parameters:: entity -; refreshPropNames -
Returns:: false if no record found by the ids in the specified entity.

update
```
public int update(T entity)
```

update

public int update(T entity,
                  java.util.Collection<java.lang.String> updatePropNames)

update

public int update(java.lang.Object id,
                  java.util.Map<java.lang.String,java.lang.Object> props)

update

public int update(java.util.Map<java.lang.String,java.lang.Object> props,
                  Condition whereCause)

update

public int update(java.sql.Connection conn,
                  T entity)

update

public int update(java.sql.Connection conn,
                  T entity,
                  java.util.Collection<java.lang.String> updatePropNames)

update

public int update(java.sql.Connection conn,
                  java.lang.Object id,
                  java.util.Map<java.lang.String,java.lang.Object> props)

update

public int update(java.sql.Connection conn,
                  java.util.Map<java.lang.String,java.lang.Object> props,
                  Condition whereCause)

batchUpdate
```
public int batchUpdate(java.util.Collection<? extends T> entities)
```
Update All the records by batch operation.

Parameters:

entities - which must have the same updated properties set.

Returns:

batchUpdate

public int batchUpdate(java.util.Collection<? extends T> entities,
                       java.util.Collection<java.lang.String> updatePropNames)

Parameters:: entities -; updatePropNames -
Returns:

batchUpdate

public int batchUpdate(java.util.Collection<? extends T> entities,
                       int batchSize)

batchUpdate

public int batchUpdate(java.util.Collection<? extends T> entities,
                       java.util.Collection<java.lang.String> updatePropNames,
                       int batchSize)

Update All the records by batch operation.

Parameters:: entities - which must have the same updated properties set.; updatePropNames -; batchSize - Default value is 200.
Returns:

batchUpdate

public int batchUpdate(java.util.Collection<? extends T> entities,
                       int batchSize,
                       IsolationLevel isolationLevel)

batchUpdate

public int batchUpdate(java.util.Collection<? extends T> entities,
                       java.util.Collection<java.lang.String> updatePropNames,
                       int batchSize,
                       IsolationLevel isolationLevel)

batchUpdate

public int batchUpdate(java.sql.Connection conn,
                       java.util.Collection<? extends T> entities)

batchUpdate

public int batchUpdate(java.sql.Connection conn,
                       java.util.Collection<? extends T> entities,
                       java.util.Collection<java.lang.String> updatePropNames)

batchUpdate

public int batchUpdate(java.sql.Connection conn,
                       java.util.Collection<? extends T> entities,
                       int batchSize)

batchUpdate

public int batchUpdate(java.sql.Connection conn,
                       java.util.Collection<? extends T> entities,
                       java.util.Collection<java.lang.String> updatePropNames,
                       int batchSize)

delete

public int delete(java.lang.Object idOrEntity)

delete

public int delete(Condition whereCause)

delete

public int delete(java.sql.Connection conn,
                  java.lang.Object idOrEntity)

delete

public int delete(java.sql.Connection conn,
                  Condition whereCause)

batchDelete
```
public int batchDelete(java.util.Collection<?> idsOrEntities)
```
Delete all the records by batch operation.

Parameters:

idsOrEntities -

Returns:

batchDelete
```
public int batchDelete(java.util.Collection<?> idsOrEntities,
                       int batchSize)
```
Delete all the records by batch operation.

Parameters:

idsOrEntities -

batchSize - Default value is 200.

Returns:

batchDelete

public int batchDelete(java.util.Collection<?> idsOrEntities,
                       int batchSize,
                       IsolationLevel isolationLevel)

Delete all the records by batch operation.

Parameters:: idsOrEntities -; batchSize - Default value is 200.; isolationLevel -
Returns:

batchDelete

public int batchDelete(java.sql.Connection conn,
                       java.util.Collection<?> idsOrEntities)

Delete all the records by batch operation.

Parameters:: conn -; idsOrEntities -
Returns:

batchDelete

public int batchDelete(java.sql.Connection conn,
                       java.util.Collection<?> idsOrEntities,
                       int batchSize)

Delete all the records by batch operation.

Parameters:: conn -; idsOrEntities -; batchSize -
Returns:

toStirng
```
public java.lang.String toStirng()
```

Class SQLExecutor.Mapper<T>

Method Summary

Methods inherited from class java.lang.Object

Method Detail

targetClass

targetType

idPropNameList

idPropNameSet

propNameList

propNameSet

async

exists

exists

exists

exists

count

count

get

get

get

gett

gett

gett

batchGet

batchGet

batchGet

batchGet

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

findFirst

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

list

listAll

listAll

listAll

listAll

listAll

listAll

stream

stream

stream