com.landawn.abacus.util

Class SQLExecutor

java.lang.Object

com.landawn.abacus.util.SQLExecutor

All Implemented Interfaces:

java.io.Closeable, java.lang.AutoCloseable

public final class SQLExecutor
extends java.lang.Object
implements java.io.Closeable

SQLExecutor is a simple sql/jdbc utility class. SQL is supported with different format:

 
 
 INSERT INTO account (first_name, last_name, gui, last_update_time, create_time) VALUES (?,  ?,  ?,  ?,  ?)
 
 INSERT INTO account (first_name, last_name, gui, last_update_time, create_time) VALUES (#{firstName}, #{lastName}, #{gui}, #{lastUpdateTime}, #{createTime})
 
 INSERT INTO account (first_name, last_name, gui, last_update_time, create_time) VALUES (:firstName, :lastName, :gui, :lastUpdateTime, :createTime)
 
 All these kinds of SQLs can be generated by SQLBuilder conveniently. Parameters with format of Array/List parameters are supported for parameterized sql with '?'. 
 Parameters with format of Array/List/Map/Entity are supported for parameterized SQL with named parameters.
 

Here is sample of CRUD(create/read/update/delete):
========================================================================

 
        static final DataSource dataSource = JdbcUtil.createDataSource(...);
        static final SQLExecutor sqlExecutor = new SQLExecutor(dataSource);
        ...
        Account account = createAccount();

        // create
        String sql_insert = NE.insert(GUI, FIRST_NAME, LAST_NAME, LAST_UPDATE_TIME, CREATE_TIME).into(Account.class).sql();
        N.println(sql_insert);
        sqlExecutor.insert(sql_insert, account);

        // read
        String sql_selectByGUI = NE.selectFrom(Account.class, N.asSet(DEVICES)).where(L.eq(GUI, L.QME)).sql();
        N.println(sql_selectByGUI);
        Account dbAccount = sqlExecutor.queryForEntity(Account.class, sql_selectByGUI, account);
        assertEquals(account.getFirstName(), dbAccount.getFirstName());

        // update
        String sql_updateByLastName = NE.update(Account.class).set(FIRST_NAME).where(L.eq(LAST_NAME, L.QME)).sql();
        N.println(sql_updateByLastName);
        dbAccount.setFirstName("newFirstName");
        sqlExecutor.update(sql_updateByLastName, dbAccount);

        // delete
        String sql_deleteByFirstName = NE.deleteFrom(Account.class).where(L.eq(FIRST_NAME, L.QME)).sql();
        N.println(sql_deleteByFirstName);
        sqlExecutor.update(sql_deleteByFirstName, dbAccount);

        dbAccount = sqlExecutor.queryForEntity(Account.class, sql_selectByGUI, account);
        assertNull(dbAccount);
 
 

========================================================================

If conn argument is null or not specified, SQLExecutor is responsible to get the connection from the internal DataSource, start and commit/roll back transaction for batch operations if needed, and close the connection finally. otherwise it's user's responsibility to do such jobs if conn is specified and not null.

The general programming way with SQLExeucte is to execute sql scripts(generated by SQLBuilder) with array/list/map/entity by calling (batch)insert/update/delete/query/... methods. if Transaction is required. it can be started:

 
      final SQLTransaction tran = sqlExecutor.beginTransaction(IsolationLevel.READ_COMMITTED);
        boolean noException = false;
        try {
            // sqlExecutor.insert(tran.getConnection(), ...);
            // sqlExecutor.update(tran.getConnection(), ...);
            // sqlExecutor.query(tran.getConnection(), ...);

            noException = true;
        } finally {
            // The connection will be automatically closed after the transaction is committed or rolled back.            
            if (noException) {
                tran.commit();
            } else {
                tran.rollback();
            }
        }
 
 

SQLExecutor is tread-safe.

Since:

0.8

Author:

Haiyang Li

See Also:

JdbcUtil, http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html, http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html, http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html, http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLExecutor.AbstractResultSetExtractor<T>
static class	SQLExecutor.AbstractStatementSetter
static class	SQLExecutor.JdbcSettings
static class	SQLExecutor.Mapper<T>
static interface	SQLExecutor.ResultSetExtractor<T> Refer to http://landawn.com/introduction-to-jdbc.html about how to read columns/rows from java.sql.ResultSet
static interface	SQLExecutor.StatementSetter Refer to http://landawn.com/introduction-to-jdbc.html about how to set parameters in java.sql.PreparedStatement
static class	SQLExecutor.TypedParameters

Constructor Summary

Constructors

Constructor and Description
SQLExecutor(javax.sql.DataSource dataSource)
SQLExecutor(DataSourceManager dataSourceManager)
SQLExecutor(DataSourceManager dataSourceManager, SQLExecutor.JdbcSettings jdbcSettings)
SQLExecutor(DataSourceManager dataSourceManager, SQLExecutor.JdbcSettings jdbcSettings, SQLMapper sqlMapper)
SQLExecutor(DataSourceManager dataSourceManager, SQLExecutor.JdbcSettings jdbcSettings, SQLMapper sqlMapper, NamingPolicy namingPolicy)
SQLExecutor(DataSourceManager dataSourceManager, SQLExecutor.JdbcSettings jdbcSettings, SQLMapper sqlMapper, NamingPolicy namingPolicy, AsyncExecutor asyncExecutor)
SQLExecutor(javax.sql.DataSource dataSource, SQLExecutor.JdbcSettings jdbcSettings)
SQLExecutor(javax.sql.DataSource dataSource, SQLExecutor.JdbcSettings jdbcSettings, SQLMapper sqlMapper)
SQLExecutor(javax.sql.DataSource dataSource, SQLExecutor.JdbcSettings jdbcSettings, SQLMapper sqlMapper, NamingPolicy namingPolicy)
SQLExecutor(javax.sql.DataSource dataSource, SQLExecutor.JdbcSettings jdbcSettings, SQLMapper sqlMapper, NamingPolicy namingPolicy, AsyncExecutor asyncExecutor)

Method Summary

Modifier and Type	Method and Description
AsyncSQLExecutor	async()
<T> java.util.List<T>	batchInsert(java.sql.Connection conn, java.lang.String sql, java.util.List<?> batchParameters)
<T> java.util.List<T>	batchInsert(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.util.List<?> batchParameters)
<T> java.util.List<T>	batchInsert(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.util.List<?> batchParameters)
<T> java.util.List<T>	batchInsert(java.lang.String sql, java.util.List<?> batchParameters)
<T> java.util.List<T>	batchInsert(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.util.List<?> batchParameters)
<T> java.util.List<T>	batchInsert(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.util.List<?> batchParameters)
int	batchUpdate(java.sql.Connection conn, java.lang.String sql, java.util.List<?> batchParameters)
int	batchUpdate(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.util.List<?> batchParameters)
int	batchUpdate(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.util.List<?> batchParameters)
int	batchUpdate(java.lang.String sql, java.util.List<?> batchParameters)
int	batchUpdate(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.util.List<?> batchParameters)
int	batchUpdate(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.util.List<?> batchParameters)
SQLTransaction	beginTransaction(IsolationLevel isolationLevel) The connection opened in the transaction will be automatically closed after the transaction is committed or rolled back.
void	close() Close the underline data source
void	closeQuietly(java.sql.Connection conn) Unconditionally close an Connection.
void	closeQuietly(java.sql.PreparedStatement stmt) Unconditionally close an Statement.
void	closeQuietly(java.sql.PreparedStatement stmt, java.sql.Connection conn) Unconditionally close the Statement, Connection.
void	closeQuietly(java.sql.ResultSet rs) Unconditionally close an ResultSet.
void	closeQuietly(java.sql.ResultSet rs, java.sql.PreparedStatement stmt) Unconditionally close the ResultSet, Statement.
void	closeQuietly(java.sql.ResultSet rs, java.sql.PreparedStatement stmt, java.sql.Connection conn) Unconditionally close the ResultSet, Statement, Connection.
int	count(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
int	count(java.lang.String sql, java.lang.Object... parameters)
boolean	createTableIfNotExists(java.lang.String tableName, java.lang.String schema) Returns true if succeed to create table, otherwise false is returned.
DataSource	dataSource()
java.lang.String	dbProudctName()
java.lang.String	dbProudctVersion()
DBVersion	dbVersion()
boolean	doesTableExist(java.lang.String tableName)
boolean	dropTableIfExists(java.lang.String tableName) Returns true if succeed to drop table, otherwise false is returned.
void	execute(java.lang.String sql, java.lang.Object... parameters) Execute the sql with the specified parameters.
boolean	exists(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
boolean	exists(java.lang.String sql, java.lang.Object... parameters)
<T> java.util.List<T>	find(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
<T> java.util.List<T>	find(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> java.util.List<T>	find(java.lang.Class<T> targetClass, java.lang.String sql, java.lang.Object... parameters)
<T> java.util.List<T>	find(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> java.util.List<T>	findAll(java.lang.Class<T> targetClass, java.util.List<java.lang.String> sqls, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> java.util.List<T>	findAll(java.lang.Class<T> targetClass, java.util.List<java.lang.String> sqls, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> java.util.List<T>	findAll(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> java.util.List<T>	findAll(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> T	get(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
<T> T	get(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> T	get(java.lang.Class<T> targetClass, java.lang.String sql, java.lang.Object... parameters)
<T> T	get(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
java.util.List<java.lang.String>	getColumnNameList(java.lang.String tableName)
java.sql.Connection	getConnection()
DBLock	getDBLock(java.lang.String tableName) Supports global lock by db table
DBSequence	getDBSequence(java.lang.String tableName, java.lang.String seqName)
DBSequence	getDBSequence(java.lang.String tableName, java.lang.String seqName, long startVal, int seqBufferSize) Supports global sequence by db table.
<T> T	insert(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
<T> T	insert(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
<T> T	insert(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> T	insert(java.lang.String sql, java.lang.Object... parameters)
<T> T	insert(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
<T> T	insert(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
SQLExecutor.JdbcSettings	jdbcSettings()
<T> SQLExecutor.Mapper<T>	mapper(java.lang.Class<T> targetClass)
DataSet	query(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
DataSet	query(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
<T> T	query(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.ResultSetExtractor<T> resultSetExtractor, java.lang.Object... parameters)
<T> T	query(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.ResultSetExtractor<T> resultSetExtractor, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the ResultSet, Statement and Connection if the return type T is ResultSet or RowIterator.
DataSet	query(java.lang.String sql, java.lang.Object... parameters)
DataSet	query(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
<T> T	query(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.ResultSetExtractor<T> resultSetExtractor, java.lang.Object... parameters)
<T> T	query(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.ResultSetExtractor<T> resultSetExtractor, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the ResultSet, Statement and Connection if the return type T is ResultSet or RowIterator.
DataSet	queryAll(java.util.List<java.lang.String> sqls, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
DataSet	queryAll(java.util.List<java.lang.String> sqls, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
DataSet	queryAll(java.lang.String sql, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
DataSet	queryAll(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
OptionalBoolean	queryForBoolean(java.lang.String sql, java.lang.Object... parameters)
OptionalByte	queryForByte(java.lang.String sql, java.lang.Object... parameters)
OptionalChar	queryForChar(java.lang.String sql, java.lang.Object... parameters)
OptionalDouble	queryForDouble(java.lang.String sql, java.lang.Object... parameters)
<T> Optional<T>	queryForEntity(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
<T> Optional<T>	queryForEntity(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Just fetch the result in the 1st row.
<T> Optional<T>	queryForEntity(java.lang.Class<T> targetClass, java.lang.String sql, java.lang.Object... parameters)
<T> Optional<T>	queryForEntity(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
OptionalFloat	queryForFloat(java.lang.String sql, java.lang.Object... parameters)
OptionalInt	queryForInt(java.lang.String sql, java.lang.Object... parameters)
OptionalLong	queryForLong(java.lang.String sql, java.lang.Object... parameters)
OptionalShort	queryForShort(java.lang.String sql, java.lang.Object... parameters)
<T> NullabLe<T>	queryForSingleResult(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
<T> NullabLe<T>	queryForSingleResult(java.lang.Class<T> targetClass, java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Just fetch the result in the 1st row and 1st column.
<T> NullabLe<T>	queryForSingleResult(java.lang.Class<T> targetClass, java.lang.String sql, java.lang.Object... parameters)
<T> NullabLe<T>	queryForSingleResult(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
NullabLe<java.lang.String>	queryForString(java.lang.String sql, java.lang.Object... parameters)
<T> Try<Stream<T>>	stream(java.lang.Class<T> targetClass, java.lang.String sql, java.lang.Object... parameters)
<T> Try<Stream<T>>	stream(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
<T> Try<Stream<T>>	stream(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the returned Stream to close the underlying ResultSet.
Try<Stream<java.lang.Object[]>>	stream(java.lang.String sql, java.lang.Object... parameters)
Try<Stream<java.lang.Object[]>>	stream(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
Try<Stream<java.lang.Object[]>>	stream(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the returned Stream to close the underlying ResultSet.
<T> Try<Stream<T>>	streamAll(java.lang.Class<T> targetClass, java.util.List<java.lang.String> sqls, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> Try<Stream<T>>	streamAll(java.lang.Class<T> targetClass, java.util.List<java.lang.String> sqls, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the returned Stream list to close the underlying ResultSet list.
<T> Try<Stream<T>>	streamAll(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
<T> Try<Stream<T>>	streamAll(java.lang.Class<T> targetClass, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the returned Stream list to close the underlying ResultSet list.
Try<Stream<java.lang.Object[]>>	streamAll(java.util.List<java.lang.String> sqls, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
Try<Stream<java.lang.Object[]>>	streamAll(java.util.List<java.lang.String> sqls, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the returned Stream list to close the underlying ResultSet list.
Try<Stream<java.lang.Object[]>>	streamAll(java.lang.String sql, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
Try<Stream<java.lang.Object[]>>	streamAll(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters) Remember to close the returned Stream list to close the underlying ResultSet list.
int	update(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
int	update(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
int	update(java.sql.Connection conn, java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
int	update(java.lang.String sql, java.lang.Object... parameters)
int	update(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, java.lang.Object... parameters)
int	update(java.lang.String sql, SQLExecutor.StatementSetter statementSetter, SQLExecutor.JdbcSettings jdbcSettings, java.lang.Object... parameters)
static SQLExecutor	w(java.lang.Class<? extends java.sql.Driver> driverClass, java.lang.String url, java.lang.String user, java.lang.String password)
static SQLExecutor	w(java.lang.String url, java.lang.String user, java.lang.String password)
static SQLExecutor	w(java.lang.String driver, java.lang.String url, java.lang.String user, java.lang.String password)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLExecutor

public SQLExecutor(javax.sql.DataSource dataSource)

Parameters:

dataSource -

See Also:

JdbcUtil.createDataSource(String), JdbcUtil.createDataSource(java.io.InputStream)

SQLExecutor

public SQLExecutor(javax.sql.DataSource dataSource,
                   SQLExecutor.JdbcSettings jdbcSettings)

Parameters:

dataSource -

jdbcSettings -

See Also:

JdbcUtil.createDataSource(String), JdbcUtil.createDataSource(java.io.InputStream)

SQLExecutor

public SQLExecutor(javax.sql.DataSource dataSource,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   SQLMapper sqlMapper)

Parameters:

dataSource -

jdbcSettings -

sqlMapper -

See Also:

JdbcUtil.createDataSource(String), JdbcUtil.createDataSource(java.io.InputStream)

SQLExecutor

public SQLExecutor(javax.sql.DataSource dataSource,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   SQLMapper sqlMapper,
                   NamingPolicy namingPolicy)

Parameters:

dataSource -

jdbcSettings -

sqlMapper -

namingPolicy -

See Also:

JdbcUtil.createDataSourceManager(String), JdbcUtil.createDataSourceManager(java.io.InputStream)

SQLExecutor

public SQLExecutor(javax.sql.DataSource dataSource,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   SQLMapper sqlMapper,
                   NamingPolicy namingPolicy,
                   AsyncExecutor asyncExecutor)

Parameters:

dataSource -

jdbcSettings -

sqlMapper -

asyncExecutor -

See Also:

JdbcUtil.createDataSource(String), JdbcUtil.createDataSource(java.io.InputStream)

SQLExecutor

public SQLExecutor(DataSourceManager dataSourceManager)

Parameters:

dataSourceManager -

See Also:

JdbcUtil.createDataSourceManager(String), JdbcUtil.createDataSourceManager(java.io.InputStream)

SQLExecutor

public SQLExecutor(DataSourceManager dataSourceManager,
                   SQLExecutor.JdbcSettings jdbcSettings)

Parameters:

dataSourceManager -

jdbcSettings -

See Also:

JdbcUtil.createDataSourceManager(String), JdbcUtil.createDataSourceManager(java.io.InputStream)

SQLExecutor

public SQLExecutor(DataSourceManager dataSourceManager,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   SQLMapper sqlMapper)

Parameters:

dataSourceManager -

jdbcSettings -

sqlMapper -

See Also:

JdbcUtil.createDataSourceManager(String), JdbcUtil.createDataSourceManager(java.io.InputStream)

SQLExecutor

public SQLExecutor(DataSourceManager dataSourceManager,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   SQLMapper sqlMapper,
                   NamingPolicy namingPolicy)

Parameters:

dataSourceManager -

jdbcSettings -

sqlMapper -

namingPolicy -

See Also:

JdbcUtil.createDataSourceManager(String), JdbcUtil.createDataSourceManager(java.io.InputStream)

SQLExecutor

public SQLExecutor(DataSourceManager dataSourceManager,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   SQLMapper sqlMapper,
                   NamingPolicy namingPolicy,
                   AsyncExecutor asyncExecutor)

Parameters:

dataSourceManager -

jdbcSettings -

sqlMapper -

asyncExecutor -

See Also:

JdbcUtil.createDataSourceManager(String), JdbcUtil.createDataSourceManager(java.io.InputStream)

Method Detail

w

public static SQLExecutor w(java.lang.String url,
                            java.lang.String user,
                            java.lang.String password)

w

public static SQLExecutor w(java.lang.String driver,
                            java.lang.String url,
                            java.lang.String user,
                            java.lang.String password)

w

public static SQLExecutor w(java.lang.Class<? extends java.sql.Driver> driverClass,
                            java.lang.String url,
                            java.lang.String user,
                            java.lang.String password)

mapper

public <T> SQLExecutor.Mapper<T> mapper(java.lang.Class<T> targetClass)

async

public AsyncSQLExecutor async()

dataSource

public DataSource dataSource()

jdbcSettings

public SQLExecutor.JdbcSettings jdbcSettings()

dbProudctName

public java.lang.String dbProudctName()

dbProudctVersion

public java.lang.String dbProudctVersion()

dbVersion

public DBVersion dbVersion()

insert

@SafeVarargs
public final <T> T insert(java.lang.String sql,
                                        java.lang.Object... parameters)

insert

@SafeVarargs
public final <T> T insert(java.lang.String sql,
                                        SQLExecutor.StatementSetter statementSetter,
                                        java.lang.Object... parameters)

insert

@SafeVarargs
public final <T> T insert(java.lang.String sql,
                                        SQLExecutor.StatementSetter statementSetter,
                                        SQLExecutor.JdbcSettings jdbcSettings,
                                        java.lang.Object... parameters)

insert

@SafeVarargs
public final <T> T insert(java.sql.Connection conn,
                                        java.lang.String sql,
                                        java.lang.Object... parameters)

insert

@SafeVarargs
public final <T> T insert(java.sql.Connection conn,
                                        java.lang.String sql,
                                        SQLExecutor.StatementSetter statementSetter,
                                        java.lang.Object... parameters)

insert

@SafeVarargs
public final <T> T insert(java.sql.Connection conn,
                                        java.lang.String sql,
                                        SQLExecutor.StatementSetter statementSetter,
                                        SQLExecutor.JdbcSettings jdbcSettings,
                                        java.lang.Object... parameters)

See Also:

#batchInsert(Connection, String, StatementSetter, JdbcSettings, String, Object[])

batchInsert

public <T> java.util.List<T> batchInsert(java.lang.String sql,
                                         java.util.List<?> batchParameters)

batchInsert

public <T> java.util.List<T> batchInsert(java.lang.String sql,
                                         SQLExecutor.StatementSetter statementSetter,
                                         java.util.List<?> batchParameters)

batchInsert

public <T> java.util.List<T> batchInsert(java.lang.String sql,
                                         SQLExecutor.StatementSetter statementSetter,
                                         SQLExecutor.JdbcSettings jdbcSettings,
                                         java.util.List<?> batchParameters)

batchInsert

public <T> java.util.List<T> batchInsert(java.sql.Connection conn,
                                         java.lang.String sql,
                                         java.util.List<?> batchParameters)

batchInsert

public <T> java.util.List<T> batchInsert(java.sql.Connection conn,
                                         java.lang.String sql,
                                         SQLExecutor.StatementSetter statementSetter,
                                         java.util.List<?> batchParameters)

batchInsert

public <T> java.util.List<T> batchInsert(java.sql.Connection conn,
                                         java.lang.String sql,
                                         SQLExecutor.StatementSetter statementSetter,
                                         SQLExecutor.JdbcSettings jdbcSettings,
                                         java.util.List<?> batchParameters)

See Also:

batchInsert(Connection, String, StatementSetter, JdbcSettings, Object[])

update

@SafeVarargs
public final int update(java.lang.String sql,
                                      java.lang.Object... parameters)

update

@SafeVarargs
public final int update(java.lang.String sql,
                                      SQLExecutor.StatementSetter statementSetter,
                                      java.lang.Object... parameters)

update

@SafeVarargs
public final int update(java.lang.String sql,
                                      SQLExecutor.StatementSetter statementSetter,
                                      SQLExecutor.JdbcSettings jdbcSettings,
                                      java.lang.Object... parameters)

update

@SafeVarargs
public final int update(java.sql.Connection conn,
                                      java.lang.String sql,
                                      java.lang.Object... parameters)

update

@SafeVarargs
public final int update(java.sql.Connection conn,
                                      java.lang.String sql,
                                      SQLExecutor.StatementSetter statementSetter,
                                      java.lang.Object... parameters)

update

@SafeVarargs
public final int update(java.sql.Connection conn,
                                      java.lang.String sql,
                                      SQLExecutor.StatementSetter statementSetter,
                                      SQLExecutor.JdbcSettings jdbcSettings,
                                      java.lang.Object... parameters)

See Also:

batchUpdate(Connection, String, StatementSetter, JdbcSettings, Object[])

batchUpdate

public int batchUpdate(java.lang.String sql,
                       java.util.List<?> batchParameters)

batchUpdate

public int batchUpdate(java.lang.String sql,
                       SQLExecutor.StatementSetter statementSetter,
                       java.util.List<?> batchParameters)

batchUpdate

public int batchUpdate(java.lang.String sql,
                       SQLExecutor.StatementSetter statementSetter,
                       SQLExecutor.JdbcSettings jdbcSettings,
                       java.util.List<?> batchParameters)

batchUpdate

public int batchUpdate(java.sql.Connection conn,
                       java.lang.String sql,
                       java.util.List<?> batchParameters)

batchUpdate

public int batchUpdate(java.sql.Connection conn,
                       java.lang.String sql,
                       SQLExecutor.StatementSetter statementSetter,
                       java.util.List<?> batchParameters)

batchUpdate

public int batchUpdate(java.sql.Connection conn,
                       java.lang.String sql,
                       SQLExecutor.StatementSetter statementSetter,
                       SQLExecutor.JdbcSettings jdbcSettings,
                       java.util.List<?> batchParameters)

See Also:

batchUpdate(Connection, String, StatementSetter, JdbcSettings, Object[])

exists

@SafeVarargs
public final boolean exists(java.lang.String sql,
                                          java.lang.Object... parameters)

exists

@SafeVarargs
public final boolean exists(java.sql.Connection conn,
                                          java.lang.String sql,
                                          java.lang.Object... parameters)

count

@SafeVarargs
public final int count(java.lang.String sql,
                                     java.lang.Object... parameters)

count

@SafeVarargs
public final int count(java.sql.Connection conn,
                                     java.lang.String sql,
                                     java.lang.Object... parameters)

get

@SafeVarargs
public final <T> T get(java.lang.Class<T> targetClass,
                                     java.lang.String sql,
                                     java.lang.Object... parameters)

get

public <T> T get(java.lang.Class<T> targetClass,
                 java.lang.String sql,
                 SQLExecutor.StatementSetter statementSetter,
                 SQLExecutor.JdbcSettings jdbcSettings,
                 java.lang.Object... parameters)

get

@SafeVarargs
public final <T> T get(java.lang.Class<T> targetClass,
                                     java.sql.Connection conn,
                                     java.lang.String sql,
                                     java.lang.Object... parameters)

get

public <T> T get(java.lang.Class<T> targetClass,
                 java.sql.Connection conn,
                 java.lang.String sql,
                 SQLExecutor.StatementSetter statementSetter,
                 SQLExecutor.JdbcSettings jdbcSettings,
                 java.lang.Object... parameters)

Parameters:

targetClass -

conn -

sql -

statementSetter -

jdbcSettings -

parameters -

Returns:

Throws:

com.landawn.abacus.exception.NonUniqueResultException - if two or more records are found.

find

@SafeVarargs
public final <T> java.util.List<T> find(java.lang.Class<T> targetClass,
                                                      java.lang.String sql,
                                                      java.lang.Object... parameters)

find

public <T> java.util.List<T> find(java.lang.Class<T> targetClass,
                                  java.lang.String sql,
                                  SQLExecutor.StatementSetter statementSetter,
                                  SQLExecutor.JdbcSettings jdbcSettings,
                                  java.lang.Object... parameters)

find

@SafeVarargs
public final <T> java.util.List<T> find(java.lang.Class<T> targetClass,
                                                      java.sql.Connection conn,
                                                      java.lang.String sql,
                                                      java.lang.Object... parameters)

find

public <T> java.util.List<T> find(java.lang.Class<T> targetClass,
                                  java.sql.Connection conn,
                                  java.lang.String sql,
                                  SQLExecutor.StatementSetter statementSetter,
                                  SQLExecutor.JdbcSettings jdbcSettings,
                                  java.lang.Object... parameters)

Parameters:

targetClass -

conn -

sql -

statementSetter -

jdbcSettings -

parameters -

Returns:

findAll

@SafeVarargs
public final <T> java.util.List<T> findAll(java.lang.Class<T> targetClass,
                                                         java.lang.String sql,
                                                         SQLExecutor.JdbcSettings jdbcSettings,
                                                         java.lang.Object... parameters)

findAll

public <T> java.util.List<T> findAll(java.lang.Class<T> targetClass,
                                     java.lang.String sql,
                                     SQLExecutor.StatementSetter statementSetter,
                                     SQLExecutor.JdbcSettings jdbcSettings,
                                     java.lang.Object... parameters)

findAll

@SafeVarargs
public final <T> java.util.List<T> findAll(java.lang.Class<T> targetClass,
                                                         java.util.List<java.lang.String> sqls,
                                                         SQLExecutor.JdbcSettings jdbcSettings,
                                                         java.lang.Object... parameters)

findAll

public <T> java.util.List<T> findAll(java.lang.Class<T> targetClass,
                                     java.util.List<java.lang.String> sqls,
                                     SQLExecutor.StatementSetter statementSetter,
                                     SQLExecutor.JdbcSettings jdbcSettings,
                                     java.lang.Object... parameters)

queryForBoolean

@SafeVarargs
public final OptionalBoolean queryForBoolean(java.lang.String sql,
                                                           java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForChar

@SafeVarargs
public final OptionalChar queryForChar(java.lang.String sql,
                                                     java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForByte

@SafeVarargs
public final OptionalByte queryForByte(java.lang.String sql,
                                                     java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForShort

@SafeVarargs
public final OptionalShort queryForShort(java.lang.String sql,
                                                       java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForInt

@SafeVarargs
public final OptionalInt queryForInt(java.lang.String sql,
                                                   java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForLong

@SafeVarargs
public final OptionalLong queryForLong(java.lang.String sql,
                                                     java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForFloat

@SafeVarargs
public final OptionalFloat queryForFloat(java.lang.String sql,
                                                       java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForDouble

@SafeVarargs
public final OptionalDouble queryForDouble(java.lang.String sql,
                                                         java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForString

@SafeVarargs
public final NullabLe<java.lang.String> queryForString(java.lang.String sql,
                                                                     java.lang.Object... parameters)

See Also:

queryForSingleResult(Class, Connection, String, Object...).

queryForSingleResult

@SafeVarargs
public final <T> NullabLe<T> queryForSingleResult(java.lang.Class<T> targetClass,
                                                                java.lang.String sql,
                                                                java.lang.Object... parameters)

queryForSingleResult

public <T> NullabLe<T> queryForSingleResult(java.lang.Class<T> targetClass,
                                            java.lang.String sql,
                                            SQLExecutor.StatementSetter statementSetter,
                                            SQLExecutor.JdbcSettings jdbcSettings,
                                            java.lang.Object... parameters)

queryForSingleResult

@SafeVarargs
public final <T> NullabLe<T> queryForSingleResult(java.lang.Class<T> targetClass,
                                                                java.sql.Connection conn,
                                                                java.lang.String sql,
                                                                java.lang.Object... parameters)

queryForSingleResult

public <T> NullabLe<T> queryForSingleResult(java.lang.Class<T> targetClass,
                                            java.sql.Connection conn,
                                            java.lang.String sql,
                                            SQLExecutor.StatementSetter statementSetter,
                                            SQLExecutor.JdbcSettings jdbcSettings,
                                            java.lang.Object... parameters)

Just fetch the result in the 1st row and 1st column. null is returned if no result is found. And this method will try to convert the result to the specified targetClass if targetClass is not null and it's not assignable from the result. Special note for type conversion for boolean or Boolean type: true is returned if the String value of the target column is "true", case insensitive. or it's an integer with value > 0. Otherwise, false is returned. Remember to add limit condition if big result will be returned by the query.

Parameters:

targetClass - set result type to avoid the NullPointerException if result is null and T is primitive type "int, long. short ... char, boolean..".

conn -

sql -

statementSetter -

jdbcSettings -

parameters -

Throws:

java.lang.ClassCastException

queryForEntity

@SafeVarargs
public final <T> Optional<T> queryForEntity(java.lang.Class<T> targetClass,
                                                          java.lang.String sql,
                                                          java.lang.Object... parameters)

queryForEntity

public <T> Optional<T> queryForEntity(java.lang.Class<T> targetClass,
                                      java.lang.String sql,
                                      SQLExecutor.StatementSetter statementSetter,
                                      SQLExecutor.JdbcSettings jdbcSettings,
                                      java.lang.Object... parameters)

queryForEntity

@SafeVarargs
public final <T> Optional<T> queryForEntity(java.lang.Class<T> targetClass,
                                                          java.sql.Connection conn,
                                                          java.lang.String sql,
                                                          java.lang.Object... parameters)

queryForEntity

public <T> Optional<T> queryForEntity(java.lang.Class<T> targetClass,
                                      java.sql.Connection conn,
                                      java.lang.String sql,
                                      SQLExecutor.StatementSetter statementSetter,
                                      SQLExecutor.JdbcSettings jdbcSettings,
                                      java.lang.Object... parameters)

Just fetch the result in the 1st row. null is returned if no result is found. This method will try to convert the column value to the type of mapping entity property if the mapping entity property is not assignable from column value. Remember to add limit condition if big result will be returned by the query.

Parameters:

targetClass -

conn -

sql -

statementSetter -

jdbcSettings -

parameters -

Returns:

query

@SafeVarargs
public final DataSet query(java.lang.String sql,
                                         java.lang.Object... parameters)

query

@SafeVarargs
public final DataSet query(java.lang.String sql,
                                         SQLExecutor.StatementSetter statementSetter,
                                         java.lang.Object... parameters)

query

@SafeVarargs
public final <T> T query(java.lang.String sql,
                                       SQLExecutor.StatementSetter statementSetter,
                                       SQLExecutor.ResultSetExtractor<T> resultSetExtractor,
                                       java.lang.Object... parameters)

query

public <T> T query(java.lang.String sql,
                   SQLExecutor.StatementSetter statementSetter,
                   SQLExecutor.ResultSetExtractor<T> resultSetExtractor,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   java.lang.Object... parameters)

Remember to close the ResultSet, Statement and Connection if the return type T is ResultSet or RowIterator. If T is RowIterator, call rowIterator.close() to close ResultSet, Statement and Connection.

If T is ResultSet, call below codes to close ResultSet, Statement and Connection.

 
 Connection conn = null;
 Statement stmt = null;
 
 try {
     stmt = rs.getStatement();
     conn = stmt.getConnection();
 } catch (SQLException e) {
     // TODO.
 } finally {
     JdbcUtil.closeQuietly(rs, stmt, conn);
 }
 
 

Parameters:

sql -

statementSetter -

resultSetExtractor -

jdbcSettings -

parameters -

Returns:

query

@SafeVarargs
public final DataSet query(java.sql.Connection conn,
                                         java.lang.String sql,
                                         java.lang.Object... parameters)

query

@SafeVarargs
public final DataSet query(java.sql.Connection conn,
                                         java.lang.String sql,
                                         SQLExecutor.StatementSetter statementSetter,
                                         java.lang.Object... parameters)

query

public <T> T query(java.sql.Connection conn,
                   java.lang.String sql,
                   SQLExecutor.StatementSetter statementSetter,
                   SQLExecutor.ResultSetExtractor<T> resultSetExtractor,
                   java.lang.Object... parameters)

query

public <T> T query(java.sql.Connection conn,
                   java.lang.String sql,
                   SQLExecutor.StatementSetter statementSetter,
                   SQLExecutor.ResultSetExtractor<T> resultSetExtractor,
                   SQLExecutor.JdbcSettings jdbcSettings,
                   java.lang.Object... parameters)

Remember to close the ResultSet, Statement and Connection if the return type T is ResultSet or RowIterator. If T is RowIterator, call rowIterator.close() to close ResultSet, Statement and Connection.

If T is ResultSet, call below codes to close ResultSet, Statement and Connection.

 
 Connection conn = null;
 Statement stmt = null;
 
 try {
     stmt = rs.getStatement();
     conn = stmt.getConnection();
 } catch (SQLException e) {
     // TODO.
 } finally {
     JdbcUtil.closeQuietly(rs, stmt, conn);
 }
 
 

Parameters:

conn -

sql -

statementSetter -

resultSetExtractor -

jdbcSettings -

parameters -

Returns:

queryAll

@SafeVarargs
public final DataSet queryAll(java.lang.String sql,
                                            SQLExecutor.JdbcSettings jdbcSettings,
                                            java.lang.Object... parameters)

queryAll

@SafeVarargs
public final DataSet queryAll(java.lang.String sql,
                                            SQLExecutor.StatementSetter statementSetter,
                                            SQLExecutor.JdbcSettings jdbcSettings,
                                            java.lang.Object... parameters)

queryAll

@SafeVarargs
public final DataSet queryAll(java.util.List<java.lang.String> sqls,
                                            SQLExecutor.JdbcSettings jdbcSettings,
                                            java.lang.Object... parameters)

queryAll

@SafeVarargs
public final DataSet queryAll(java.util.List<java.lang.String> sqls,
                                            SQLExecutor.StatementSetter statementSetter,
                                            SQLExecutor.JdbcSettings jdbcSettings,
                                            java.lang.Object... parameters)

stream

@SafeVarargs
public final Try<Stream<java.lang.Object[]>> stream(java.lang.String sql,
                                                                  java.lang.Object... parameters)

stream

@SafeVarargs
public final Try<Stream<java.lang.Object[]>> stream(java.lang.String sql,
                                                                  SQLExecutor.StatementSetter statementSetter,
                                                                  java.lang.Object... parameters)

stream

@SafeVarargs
public final Try<Stream<java.lang.Object[]>> stream(java.lang.String sql,
                                                                  SQLExecutor.StatementSetter statementSetter,
                                                                  SQLExecutor.JdbcSettings jdbcSettings,
                                                                  java.lang.Object... parameters)

Remember to close the returned Stream to close the underlying ResultSet.

Parameters:

sql -

statementSetter -

jdbcSettings -

parameters -

Returns:

streamAll

@SafeVarargs
public final Try<Stream<java.lang.Object[]>> streamAll(java.lang.String sql,
                                                                     SQLExecutor.JdbcSettings jdbcSettings,
                                                                     java.lang.Object... parameters)

streamAll

public Try<Stream<java.lang.Object[]>> streamAll(java.lang.String sql,
                                                 SQLExecutor.StatementSetter statementSetter,
                                                 SQLExecutor.JdbcSettings jdbcSettings,
                                                 java.lang.Object... parameters)

Remember to close the returned Stream list to close the underlying ResultSet list.

Parameters:

sql -

statementSetter -

jdbcSettings -

parameters -

Returns:

streamAll

@SafeVarargs
public final Try<Stream<java.lang.Object[]>> streamAll(java.util.List<java.lang.String> sqls,
                                                                     SQLExecutor.JdbcSettings jdbcSettings,
                                                                     java.lang.Object... parameters)

streamAll

public Try<Stream<java.lang.Object[]>> streamAll(java.util.List<java.lang.String> sqls,
                                                 SQLExecutor.StatementSetter statementSetter,
                                                 SQLExecutor.JdbcSettings jdbcSettings,
                                                 java.lang.Object... parameters)

Remember to close the returned Stream list to close the underlying ResultSet list.

Parameters:

sqls -

statementSetter -

jdbcSettings -

parameters -

Returns:

stream

@SafeVarargs
public final <T> Try<Stream<T>> stream(java.lang.Class<T> targetClass,
                                                     java.lang.String sql,
                                                     java.lang.Object... parameters)

stream

@SafeVarargs
public final <T> Try<Stream<T>> stream(java.lang.Class<T> targetClass,
                                                     java.lang.String sql,
                                                     SQLExecutor.StatementSetter statementSetter,
                                                     java.lang.Object... parameters)

stream

public <T> Try<Stream<T>> stream(java.lang.Class<T> targetClass,
                                 java.lang.String sql,
                                 SQLExecutor.StatementSetter statementSetter,
                                 SQLExecutor.JdbcSettings jdbcSettings,
                                 java.lang.Object... parameters)

Remember to close the returned Stream to close the underlying ResultSet.

Parameters:

sql -

statementSetter -

jdbcSettings -

parameters -

Returns:

streamAll

@SafeVarargs
public final <T> Try<Stream<T>> streamAll(java.lang.Class<T> targetClass,
                                                        java.lang.String sql,
                                                        SQLExecutor.JdbcSettings jdbcSettings,
                                                        java.lang.Object... parameters)

streamAll

public <T> Try<Stream<T>> streamAll(java.lang.Class<T> targetClass,
                                    java.lang.String sql,
                                    SQLExecutor.StatementSetter statementSetter,
                                    SQLExecutor.JdbcSettings jdbcSettings,
                                    java.lang.Object... parameters)

Remember to close the returned Stream list to close the underlying ResultSet list.

Parameters:

sql -

statementSetter -

jdbcSettings -

parameters -

Returns:

streamAll

@SafeVarargs
public final <T> Try<Stream<T>> streamAll(java.lang.Class<T> targetClass,
                                                        java.util.List<java.lang.String> sqls,
                                                        SQLExecutor.JdbcSettings jdbcSettings,
                                                        java.lang.Object... parameters)

streamAll

public <T> Try<Stream<T>> streamAll(java.lang.Class<T> targetClass,
                                    java.util.List<java.lang.String> sqls,
                                    SQLExecutor.StatementSetter statementSetter,
                                    SQLExecutor.JdbcSettings jdbcSettings,
                                    java.lang.Object... parameters)

Remember to close the returned Stream list to close the underlying ResultSet list.

Parameters:

sqls -

statementSetter -

jdbcSettings -

parameters -

Returns:

execute

@SafeVarargs
public final void execute(java.lang.String sql,
                                        java.lang.Object... parameters)

Execute the sql with the specified parameters.

Parameters:

sql -

parameters -

See Also:

PreparedStatement.execute()

beginTransaction

public SQLTransaction beginTransaction(IsolationLevel isolationLevel)

The connection opened in the transaction will be automatically closed after the transaction is committed or rolled back. DON'T close it again by calling the close method.

Parameters:

isolationLevel -

Returns:

getDBSequence

public DBSequence getDBSequence(java.lang.String tableName,
                                java.lang.String seqName)

getDBSequence

public DBSequence getDBSequence(java.lang.String tableName,
                                java.lang.String seqName,
                                long startVal,
                                int seqBufferSize)

Supports global sequence by db table.

Parameters:

tableName -

seqName -

startVal -

seqBufferSize - the numbers to allocate/reserve from database table when cached numbers are used up.

Returns:

getDBLock

public DBLock getDBLock(java.lang.String tableName)

Supports global lock by db table

Parameters:

tableName -

Returns:

doesTableExist

public boolean doesTableExist(java.lang.String tableName)

createTableIfNotExists

public boolean createTableIfNotExists(java.lang.String tableName,
                                      java.lang.String schema)

Returns true if succeed to create table, otherwise false is returned.

Parameters:

tableName -

schema -

Returns:

dropTableIfExists

public boolean dropTableIfExists(java.lang.String tableName)

Returns true if succeed to drop table, otherwise false is returned.

Parameters:

tableName -

Returns:

getColumnNameList

public java.util.List<java.lang.String> getColumnNameList(java.lang.String tableName)

Parameters:

tableName -

Returns:

getConnection

public java.sql.Connection getConnection()

closeQuietly

public void closeQuietly(java.sql.ResultSet rs)

Unconditionally close an ResultSet.

Equivalent to ResultSet.close(), except any exceptions will be ignored. This is typically used in finally blocks.

Parameters:

rs -

closeQuietly

public void closeQuietly(java.sql.PreparedStatement stmt)

Unconditionally close an Statement.

Equivalent to Statement.close(), except any exceptions will be ignored. This is typically used in finally blocks.

Parameters:

stmt -

closeQuietly

public void closeQuietly(java.sql.Connection conn)

Unconditionally close an Connection.

Equivalent to Connection.close(), except any exceptions will be ignored. This is typically used in finally blocks.

Parameters:

conn -

closeQuietly

public void closeQuietly(java.sql.ResultSet rs,
                         java.sql.PreparedStatement stmt)

Unconditionally close the ResultSet, Statement.

Equivalent to ResultSet.close(), Statement.close(), except any exceptions will be ignored. This is typically used in finally blocks.

Parameters:

rs -

stmt -

conn -

closeQuietly

public void closeQuietly(java.sql.PreparedStatement stmt,
                         java.sql.Connection conn)

Unconditionally close the Statement, Connection.

Equivalent to Statement.close(), Connection.close(), except any exceptions will be ignored. This is typically used in finally blocks.

Parameters:

rs -

stmt -

conn -

closeQuietly

public void closeQuietly(java.sql.ResultSet rs,
                         java.sql.PreparedStatement stmt,
                         java.sql.Connection conn)

Unconditionally close the ResultSet, Statement, Connection.

Equivalent to ResultSet.close(), Statement.close(), Connection.close(), except any exceptions will be ignored. This is typically used in finally blocks.

Parameters:

rs -

stmt -

conn -

close

public void close()
           throws java.io.IOException

Close the underline data source

Specified by:

close in interface java.io.Closeable

Specified by:

close in interface java.lang.AutoCloseable

Throws:

java.io.IOException