com.landawn.abacus.util

Class JdbcUtil

java.lang.Object

com.landawn.abacus.util.JdbcUtil

public final class JdbcUtil
extends java.lang.Object

Since:

0.8

Author:

Haiyang Li

See Also:

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

Method Summary

Modifier and Type	Method and Description
static java.sql.CallableStatement	batchPrepareCall(java.sql.Connection conn, java.lang.String sql, java.util.List<?> parametersList)
static java.sql.PreparedStatement	batchPrepareStatement(java.sql.Connection conn, java.lang.String sql, java.util.List<?> parametersList)
static SQLTransaction	beginTransaction(java.sql.Connection conn, IsolationLevel isolationLevel)
static void	close(java.sql.Connection conn)
static void	close(java.sql.ResultSet rs)
static void	close(java.sql.ResultSet rs, java.sql.Statement stmt)
static void	close(java.sql.ResultSet rs, java.sql.Statement stmt, java.sql.Connection conn)
static void	close(java.sql.Statement stmt)
static void	close(java.sql.Statement stmt, java.sql.Connection conn)
static void	closeQuietly(java.sql.Connection conn) Unconditionally close an Connection.
static void	closeQuietly(java.sql.ResultSet rs) Unconditionally close an ResultSet.
static void	closeQuietly(java.sql.ResultSet rs, java.sql.Statement stmt) Unconditionally close the ResultSet, Statement.
static void	closeQuietly(java.sql.ResultSet rs, java.sql.Statement stmt, java.sql.Connection conn) Unconditionally close the ResultSet, Statement, Connection.
static void	closeQuietly(java.sql.Statement stmt) Unconditionally close an Statement.
static void	closeQuietly(java.sql.Statement stmt, java.sql.Connection conn) Unconditionally close the Statement, Connection.
static long	copy(java.sql.Connection sourceConn, java.lang.String selectSql, java.sql.Connection targetConn, java.lang.String insertSql)
static long	copy(java.sql.Connection sourceConn, java.lang.String selectSql, int fetchSize, long offset, long count, java.sql.Connection targetConn, java.lang.String insertSql, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter, int batchSize, int batchInterval, boolean inParallel)
static long	copy(java.sql.PreparedStatement selectStmt, long offset, long count, java.sql.PreparedStatement insertStmt, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter, int batchSize, int batchInterval, boolean inParallel)
static long	copy(java.sql.PreparedStatement selectStmt, java.sql.PreparedStatement insertStmt, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)
static java.sql.Connection	createConnection(java.lang.Class<? extends java.sql.Driver> driverClass, java.lang.String url, java.lang.String user, java.lang.String password)
static java.sql.Connection	createConnection(java.lang.String url, java.lang.String user, java.lang.String password)
static java.sql.Connection	createConnection(java.lang.String driverClass, java.lang.String url, java.lang.String user, java.lang.String password)
static DataSource	createDataSource(java.lang.Class<? extends java.sql.Driver> driverClass, java.lang.String url, java.lang.String user, java.lang.String password)
static DataSource	createDataSource(java.io.InputStream dataSourceInputStream)
static DataSource	createDataSource(java.util.Map<java.lang.String,?> props)
static DataSource	createDataSource(java.lang.String dataSourceFile)
static DataSource	createDataSource(java.lang.String url, java.lang.String user, java.lang.String password)
static DataSource	createDataSource(java.lang.String driver, java.lang.String url, java.lang.String user, java.lang.String password)
static DataSourceManager	createDataSourceManager(java.io.InputStream dataSourceXmlInputStream)
static DataSourceManager	createDataSourceManager(java.lang.String dataSourceXmlFile)
static boolean	createTableIfNotExists(java.sql.Connection conn, java.lang.String tableName, java.lang.String schema) Returns true if succeed to create table, otherwise false is returned.
static boolean	doesTableExist(java.sql.Connection conn, java.lang.String tableName)
static boolean	dropTableIfExists(java.sql.Connection conn, java.lang.String tableName) Returns true if succeed to drop table, otherwise false is returned.
static boolean	execute(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
static boolean	execute(java.sql.PreparedStatement stmt)
static DataSet	executeQuery(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
static DataSet	executeQuery(java.sql.PreparedStatement stmt)
static int	executeUpdate(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
static int	executeUpdate(java.sql.PreparedStatement stmt)
static DataSet	extractData(java.sql.ResultSet rs)
static DataSet	extractData(java.sql.ResultSet rs, boolean closeResultSet)
static DataSet	extractData(java.sql.ResultSet rs, int offset, int count)
static DataSet	extractData(java.sql.ResultSet rs, int offset, int count, boolean closeResultSet)
static <E extends java.lang.Exception> DataSet	extractData(java.sql.ResultSet rs, int offset, int count, Try.Predicate<? super java.lang.Object[],E> filter, boolean closeResultSet)
static java.util.List<java.lang.String>	getColumnNameList(java.sql.Connection conn, java.lang.String tableName)
static DBVersion	getDBVersion(java.sql.Connection conn)
static int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, java.sql.Connection conn, java.lang.String insertSQL) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, int offset, int count, java.sql.Connection conn, java.lang.String insertSQL) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, int offset, int count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, int offset, int count, java.sql.PreparedStatement stmt) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, int offset, int count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval) Imports the data from DataSet to database.
static <E extends java.lang.Exception> int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, int offset, int count, Try.Predicate<? super java.lang.Object[],E> filter, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval) Imports the data from DataSet to database.
static <E extends java.lang.Exception> int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, int offset, int count, Try.Predicate<? super java.lang.Object[],E> filter, java.sql.PreparedStatement stmt, int batchSize, int batchInterval) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.util.Collection<java.lang.String> selectColumnNames, java.sql.PreparedStatement stmt) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.sql.Connection conn, java.lang.String insertSQL) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.sql.Connection conn, java.lang.String insertSQL, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.sql.Connection conn, java.lang.String insertSQL, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.Connection conn, java.lang.String insertSQL, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.Connection conn, java.lang.String insertSQL, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.PreparedStatement stmt, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static int	importData(DataSet dataset, int offset, int count, java.sql.PreparedStatement stmt, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter) Imports the data from DataSet to database.
static <E extends java.lang.Exception> int	importData(DataSet dataset, int offset, int count, Try.Predicate<? super java.lang.Object[],E> filter, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static <E extends java.lang.Exception> int	importData(DataSet dataset, int offset, int count, Try.Predicate<? super java.lang.Object[],E> filter, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter) Imports the data from DataSet to database.
static <E extends java.lang.Exception> int	importData(DataSet dataset, int offset, int count, Try.Predicate<? super java.lang.Object[],E> filter, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static <E extends java.lang.Exception> int	importData(DataSet dataset, int offset, int count, Try.Predicate<? super java.lang.Object[],E> filter, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.sql.PreparedStatement stmt) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.sql.PreparedStatement stmt, java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap) Imports the data from DataSet to database.
static int	importData(DataSet dataset, java.sql.PreparedStatement stmt, Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)
static <E extends java.lang.Exception> long	importData(java.io.File file, java.sql.Connection conn, java.lang.String insertSQL, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.File file, long offset, long count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.File file, long offset, long count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.Function<java.lang.String,java.lang.Object[],E> func) Imports the data from file to database.
static <E extends java.lang.Exception> long	importData(java.io.File file, java.sql.PreparedStatement stmt, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.InputStream is, java.sql.Connection conn, java.lang.String insertSQL, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.InputStream is, long offset, long count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.InputStream is, long offset, long count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.Function<java.lang.String,java.lang.Object[],E> func) Imports the data from file to database.
static <E extends java.lang.Exception> long	importData(java.io.InputStream is, java.sql.PreparedStatement stmt, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <T> long	importData(java.util.Iterator<T> iter, java.sql.Connection conn, java.lang.String insertSQL, Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)
static <T,E extends java.lang.Exception> long	importData(java.util.Iterator<T> iter, java.sql.Connection conn, java.lang.String insertSQL, Try.Function<T,java.lang.Object[],E> func)
static <T> long	importData(java.util.Iterator<T> iter, long offset, long count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)
static <T,E extends java.lang.Exception> long	importData(java.util.Iterator<T> iter, long offset, long count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.Function<T,java.lang.Object[],E> func)
static <T> long	importData(java.util.Iterator<T> iter, long offset, long count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)
static <T,E extends java.lang.Exception> long	importData(java.util.Iterator<T> iter, long offset, long count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.Function<T,java.lang.Object[],E> func) Imports the data from Iterator to database.
static <T,E extends java.lang.Exception> long	importData(java.util.Iterator<T> iter, long offset, long count, Try.Predicate<? super T,E> filter, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)
static <T,E extends java.lang.Exception> long	importData(java.util.Iterator<T> iter, long offset, long count, Try.Predicate<? super T,E> filter, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter) Imports the data from Iterator to database.
static <T> long	importData(java.util.Iterator<T> iter, java.sql.PreparedStatement stmt, Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)
static <T,E extends java.lang.Exception> long	importData(java.util.Iterator<T> iter, java.sql.PreparedStatement stmt, Try.Function<T,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.Reader reader, java.sql.Connection conn, java.lang.String insertSQL, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.Reader reader, long offset, long count, java.sql.Connection conn, java.lang.String insertSQL, int batchSize, int batchInterval, Try.Function<java.lang.String,java.lang.Object[],E> func)
static <E extends java.lang.Exception> long	importData(java.io.Reader reader, long offset, long count, java.sql.PreparedStatement stmt, int batchSize, int batchInterval, Try.Function<java.lang.String,java.lang.Object[],E> func) Imports the data from file to database.
static <E extends java.lang.Exception> long	importData(java.io.Reader reader, java.sql.PreparedStatement stmt, Try.Function<java.lang.String,java.lang.Object[],E> func)
static RowIterator	iterate(java.sql.ResultSet rs)
static <E extends java.lang.Exception> void	parse(java.sql.Connection conn, java.lang.String sql, long offset, long count, int processThreadNum, int queueSize, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.Connection conn, java.lang.String sql, long offset, long count, int processThreadNum, int queueSize, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete) Parse the ResultSet obtained by executing query with the specified Connection and sql.
static <E extends java.lang.Exception> void	parse(java.sql.Connection conn, java.lang.String sql, long offset, long count, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.Connection conn, java.lang.String sql, long offset, long count, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete)
static <E extends java.lang.Exception> void	parse(java.sql.Connection conn, java.lang.String sql, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.Connection conn, java.lang.String sql, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete)
static <E extends java.lang.Exception> void	parse(java.sql.PreparedStatement stmt, long offset, long count, int processThreadNum, int queueSize, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.PreparedStatement stmt, long offset, long count, int processThreadNum, int queueSize, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete) Parse the ResultSet obtained by executing query with the specified PreparedStatement.
static <E extends java.lang.Exception> void	parse(java.sql.PreparedStatement stmt, long offset, long count, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.PreparedStatement stmt, long offset, long count, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete)
static <E extends java.lang.Exception> void	parse(java.sql.PreparedStatement stmt, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.PreparedStatement stmt, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete)
static <E extends java.lang.Exception> void	parse(java.sql.ResultSet rs, long offset, long count, int processThreadNum, int queueSize, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.ResultSet rs, long offset, long count, int processThreadNum, int queueSize, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete) Parse the ResultSet.
static <E extends java.lang.Exception> void	parse(java.sql.ResultSet rs, long offset, long count, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.ResultSet rs, long offset, long count, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete)
static <E extends java.lang.Exception> void	parse(java.sql.ResultSet rs, Try.Consumer<java.lang.Object[],E> rowParser)
static <E extends java.lang.Exception,E2 extends java.lang.Exception> void	parse(java.sql.ResultSet rs, Try.Consumer<java.lang.Object[],E> rowParser, Try.Runnable<E2> onComplete)
static java.sql.CallableStatement	prepareCall(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
static java.sql.PreparedStatement	prepareStatement(java.sql.Connection conn, java.lang.String sql, java.lang.Object... parameters)
static DataSource	wrap(javax.sql.DataSource sqlDataSource)

Methods inherited from class java.lang.Object

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

Method Detail

getDBVersion

public static DBVersion getDBVersion(java.sql.Connection conn)

createDataSourceManager

public static DataSourceManager createDataSourceManager(java.lang.String dataSourceXmlFile)

Parameters:

dataSourceXmlFile -

Returns:

DataSourceManager

See Also:

DataSource.xsd

createDataSourceManager

public static DataSourceManager createDataSourceManager(java.io.InputStream dataSourceXmlInputStream)

Parameters:

dataSourceXmlInputStream -

Returns:

DataSourceManager

See Also:

DataSource.xsd

createDataSource

public static DataSource createDataSource(java.lang.String dataSourceFile)

createDataSource

public static DataSource createDataSource(java.io.InputStream dataSourceInputStream)

createDataSource

public static DataSource createDataSource(java.lang.String url,
                                          java.lang.String user,
                                          java.lang.String password)

createDataSource

public static DataSource createDataSource(java.lang.String driver,
                                          java.lang.String url,
                                          java.lang.String user,
                                          java.lang.String password)

createDataSource

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

createDataSource

public static DataSource createDataSource(java.util.Map<java.lang.String,?> props)

Parameters:

props - refer to Connection.xsd for the supported properties.

Returns:

wrap

public static DataSource wrap(javax.sql.DataSource sqlDataSource)

createConnection

public static java.sql.Connection createConnection(java.lang.String url,
                                                   java.lang.String user,
                                                   java.lang.String password)

createConnection

public static java.sql.Connection createConnection(java.lang.String driverClass,
                                                   java.lang.String url,
                                                   java.lang.String user,
                                                   java.lang.String password)

createConnection

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

close

public static void close(java.sql.ResultSet rs)

close

public static void close(java.sql.Statement stmt)

close

public static void close(java.sql.Connection conn)

close

public static void close(java.sql.ResultSet rs,
                         java.sql.Statement stmt)

close

public static void close(java.sql.Statement stmt,
                         java.sql.Connection conn)

close

public static void close(java.sql.ResultSet rs,
                         java.sql.Statement stmt,
                         java.sql.Connection conn)

closeQuietly

public static 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 static void closeQuietly(java.sql.Statement 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 static 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 static void closeQuietly(java.sql.ResultSet rs,
                                java.sql.Statement 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 -

closeQuietly

public static void closeQuietly(java.sql.Statement 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:

stmt -

conn -

closeQuietly

public static void closeQuietly(java.sql.ResultSet rs,
                                java.sql.Statement 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 -

beginTransaction

public static SQLTransaction beginTransaction(java.sql.Connection conn,
                                              IsolationLevel isolationLevel)

prepareStatement

@SafeVarargs
public static java.sql.PreparedStatement prepareStatement(java.sql.Connection conn,
                                                                        java.lang.String sql,
                                                                        java.lang.Object... parameters)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareCall

@SafeVarargs
public static java.sql.CallableStatement prepareCall(java.sql.Connection conn,
                                                                   java.lang.String sql,
                                                                   java.lang.Object... parameters)
                                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

batchPrepareStatement

public static java.sql.PreparedStatement batchPrepareStatement(java.sql.Connection conn,
                                                               java.lang.String sql,
                                                               java.util.List<?> parametersList)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

batchPrepareCall

public static java.sql.CallableStatement batchPrepareCall(java.sql.Connection conn,
                                                          java.lang.String sql,
                                                          java.util.List<?> parametersList)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQuery

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

executeQuery

public static DataSet executeQuery(java.sql.PreparedStatement stmt)

executeUpdate

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

executeUpdate

public static int executeUpdate(java.sql.PreparedStatement stmt)

execute

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

execute

public static boolean execute(java.sql.PreparedStatement stmt)

iterate

public static RowIterator iterate(java.sql.ResultSet rs)

Parameters:

rs -

extractData

public static DataSet extractData(java.sql.ResultSet rs)

extractData

public static DataSet extractData(java.sql.ResultSet rs,
                                  boolean closeResultSet)

extractData

public static DataSet extractData(java.sql.ResultSet rs,
                                  int offset,
                                  int count)

extractData

public static DataSet extractData(java.sql.ResultSet rs,
                                  int offset,
                                  int count,
                                  boolean closeResultSet)

extractData

public static <E extends java.lang.Exception> DataSet extractData(java.sql.ResultSet rs,
                                                                  int offset,
                                                                  int count,
                                                                  Try.Predicate<? super java.lang.Object[],E> filter,
                                                                  boolean closeResultSet)
                                                           throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static int importData(DataSet dataset,
                             java.sql.Connection conn,
                             java.lang.String insertSQL)

Imports the data from DataSet to database.

Parameters:

dataset -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

Returns:

importData

public static int importData(DataSet dataset,
                             java.util.Collection<java.lang.String> selectColumnNames,
                             java.sql.Connection conn,
                             java.lang.String insertSQL)

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

Returns:

importData

public static int importData(DataSet dataset,
                             java.util.Collection<java.lang.String> selectColumnNames,
                             int offset,
                             int count,
                             java.sql.Connection conn,
                             java.lang.String insertSQL)

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

offset -

count -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

Returns:

importData

public static int importData(DataSet dataset,
                             java.util.Collection<java.lang.String> selectColumnNames,
                             int offset,
                             int count,
                             java.sql.Connection conn,
                             java.lang.String insertSQL,
                             int batchSize,
                             int batchInterval)

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

offset -

count -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

batchSize -

batchInterval -

Returns:

importData

public static <E extends java.lang.Exception> int importData(DataSet dataset,
                                                             java.util.Collection<java.lang.String> selectColumnNames,
                                                             int offset,
                                                             int count,
                                                             Try.Predicate<? super java.lang.Object[],E> filter,
                                                             java.sql.Connection conn,
                                                             java.lang.String insertSQL,
                                                             int batchSize,
                                                             int batchInterval)
                                                      throws E extends java.lang.Exception

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

offset -

count -

filter -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

batchSize -

batchInterval -

Returns:

Throws:

E extends java.lang.Exception

importData

public static int importData(DataSet dataset,
                             java.sql.Connection conn,
                             java.lang.String insertSQL,
                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)

Imports the data from DataSet to database.

Parameters:

dataset -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

columnTypeMap -

Returns:

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.Connection conn,
                             java.lang.String insertSQL,
                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

columnTypeMap -

Returns:

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.Connection conn,
                             java.lang.String insertSQL,
                             int batchSize,
                             int batchInterval,
                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

batchSize -

batchInterval -

columnTypeMap -

Returns:

importData

public static <E extends java.lang.Exception> int importData(DataSet dataset,
                                                             int offset,
                                                             int count,
                                                             Try.Predicate<? super java.lang.Object[],E> filter,
                                                             java.sql.Connection conn,
                                                             java.lang.String insertSQL,
                                                             int batchSize,
                                                             int batchInterval,
                                                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)
                                                      throws E extends java.lang.Exception

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

filter -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

batchSize -

batchInterval -

columnTypeMap -

Returns:

Throws:

E extends java.lang.Exception

importData

public static int importData(DataSet dataset,
                             java.sql.Connection conn,
                             java.lang.String insertSQL,
                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)

Imports the data from DataSet to database.

Parameters:

dataset -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

stmtSetter -

Returns:

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.Connection conn,
                             java.lang.String insertSQL,
                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

stmtSetter -

Returns:

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.Connection conn,
                             java.lang.String insertSQL,
                             int batchSize,
                             int batchInterval,
                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

batchSize -

batchInterval -

stmtSetter -

Returns:

importData

public static <E extends java.lang.Exception> int importData(DataSet dataset,
                                                             int offset,
                                                             int count,
                                                             Try.Predicate<? super java.lang.Object[],E> filter,
                                                             java.sql.Connection conn,
                                                             java.lang.String insertSQL,
                                                             int batchSize,
                                                             int batchInterval,
                                                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)
                                                      throws E extends java.lang.Exception

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

filter -

conn -

insertSQL - the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:

        List columnNameList = new ArrayList<>(dataset.columnNameList());
        columnNameList.retainAll(yourSelectColumnNames);        
        String sql = RE.insert(columnNameList).into(tableName).sql();  
 

batchSize -

batchInterval -

stmtSetter -

Returns:

Throws:

E extends java.lang.Exception

importData

public static int importData(DataSet dataset,
                             java.sql.PreparedStatement stmt)

Imports the data from DataSet to database.

Parameters:

dataset -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

Returns:

importData

public static int importData(DataSet dataset,
                             java.util.Collection<java.lang.String> selectColumnNames,
                             java.sql.PreparedStatement stmt)

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

Returns:

importData

public static int importData(DataSet dataset,
                             java.util.Collection<java.lang.String> selectColumnNames,
                             int offset,
                             int count,
                             java.sql.PreparedStatement stmt)

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

offset -

count -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

Returns:

importData

public static int importData(DataSet dataset,
                             java.util.Collection<java.lang.String> selectColumnNames,
                             int offset,
                             int count,
                             java.sql.PreparedStatement stmt,
                             int batchSize,
                             int batchInterval)

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

offset -

count -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

Returns:

importData

public static <E extends java.lang.Exception> int importData(DataSet dataset,
                                                             java.util.Collection<java.lang.String> selectColumnNames,
                                                             int offset,
                                                             int count,
                                                             Try.Predicate<? super java.lang.Object[],E> filter,
                                                             java.sql.PreparedStatement stmt,
                                                             int batchSize,
                                                             int batchInterval)
                                                      throws E extends java.lang.Exception

Imports the data from DataSet to database.

Parameters:

dataset -

selectColumnNames -

offset -

count -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

batchSize -

batchInterval -

Returns:

Throws:

E extends java.lang.Exception

importData

public static int importData(DataSet dataset,
                             java.sql.PreparedStatement stmt,
                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)

Imports the data from DataSet to database.

Parameters:

dataset -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

columnTypeMap -

Returns:

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.PreparedStatement stmt,
                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

columnTypeMap -

Returns:

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.PreparedStatement stmt,
                             int batchSize,
                             int batchInterval,
                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

columnTypeMap -

filter -

Returns:

importData

public static <E extends java.lang.Exception> int importData(DataSet dataset,
                                                             int offset,
                                                             int count,
                                                             Try.Predicate<? super java.lang.Object[],E> filter,
                                                             java.sql.PreparedStatement stmt,
                                                             int batchSize,
                                                             int batchInterval,
                                                             java.util.Map<java.lang.String,? extends com.landawn.abacus.type.Type> columnTypeMap)
                                                      throws E extends java.lang.Exception

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

filter -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

batchSize -

batchInterval -

columnTypeMap -

Returns:

Throws:

E extends java.lang.Exception

importData

public static int importData(DataSet dataset,
                             java.sql.PreparedStatement stmt,
                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.PreparedStatement stmt,
                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

Returns:

importData

public static int importData(DataSet dataset,
                             int offset,
                             int count,
                             java.sql.PreparedStatement stmt,
                             int batchSize,
                             int batchInterval,
                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)

Imports the data from DataSet to database.

Parameters:

dataset -

columnTypeMap -

offset -

count -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

filter -

stmtSetter -

Returns:

importData

public static <E extends java.lang.Exception> int importData(DataSet dataset,
                                                             int offset,
                                                             int count,
                                                             Try.Predicate<? super java.lang.Object[],E> filter,
                                                             java.sql.PreparedStatement stmt,
                                                             int batchSize,
                                                             int batchInterval,
                                                             Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)
                                                      throws E extends java.lang.Exception

Imports the data from DataSet to database.

Parameters:

dataset -

offset -

count -

filter -

stmt - the column order in the sql must be consistent with the column order in the DataSet.

batchSize -

batchInterval -

stmtSetter -

columnTypeMap -

Returns:

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.File file,
                                                              java.sql.Connection conn,
                                                              java.lang.String insertSQL,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.File file,
                                                              long offset,
                                                              long count,
                                                              java.sql.Connection conn,
                                                              java.lang.String insertSQL,
                                                              int batchSize,
                                                              int batchInterval,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.File file,
                                                              java.sql.PreparedStatement stmt,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.File file,
                                                              long offset,
                                                              long count,
                                                              java.sql.PreparedStatement stmt,
                                                              int batchSize,
                                                              int batchInterval,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Imports the data from file to database.

Parameters:

file -

offset -

count -

stmt -

batchSize -

batchInterval -

func - convert line to the parameters for record insert. Returns a null array to skip the line.

Returns:

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.InputStream is,
                                                              java.sql.Connection conn,
                                                              java.lang.String insertSQL,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.InputStream is,
                                                              long offset,
                                                              long count,
                                                              java.sql.Connection conn,
                                                              java.lang.String insertSQL,
                                                              int batchSize,
                                                              int batchInterval,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.InputStream is,
                                                              java.sql.PreparedStatement stmt,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.InputStream is,
                                                              long offset,
                                                              long count,
                                                              java.sql.PreparedStatement stmt,
                                                              int batchSize,
                                                              int batchInterval,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Imports the data from file to database.

Parameters:

is -

offset -

count -

stmt -

batchSize -

batchInterval -

func - convert line to the parameters for record insert. Returns a null array to skip the line.

Returns:

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.Reader reader,
                                                              java.sql.Connection conn,
                                                              java.lang.String insertSQL,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.Reader reader,
                                                              long offset,
                                                              long count,
                                                              java.sql.Connection conn,
                                                              java.lang.String insertSQL,
                                                              int batchSize,
                                                              int batchInterval,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.Reader reader,
                                                              java.sql.PreparedStatement stmt,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <E extends java.lang.Exception> long importData(java.io.Reader reader,
                                                              long offset,
                                                              long count,
                                                              java.sql.PreparedStatement stmt,
                                                              int batchSize,
                                                              int batchInterval,
                                                              Try.Function<java.lang.String,java.lang.Object[],E> func)
                                                       throws E extends java.lang.Exception

Imports the data from file to database.

Parameters:

reader -

offset -

count -

stmt -

batchSize -

batchInterval -

func - convert line to the parameters for record insert. Returns a null array to skip the line.

Returns:

Throws:

E extends java.lang.Exception

importData

public static <T,E extends java.lang.Exception> long importData(java.util.Iterator<T> iter,
                                                                java.sql.Connection conn,
                                                                java.lang.String insertSQL,
                                                                Try.Function<T,java.lang.Object[],E> func)
                                                         throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <T,E extends java.lang.Exception> long importData(java.util.Iterator<T> iter,
                                                                long offset,
                                                                long count,
                                                                java.sql.Connection conn,
                                                                java.lang.String insertSQL,
                                                                int batchSize,
                                                                int batchInterval,
                                                                Try.Function<T,java.lang.Object[],E> func)
                                                         throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <T,E extends java.lang.Exception> long importData(java.util.Iterator<T> iter,
                                                                java.sql.PreparedStatement stmt,
                                                                Try.Function<T,java.lang.Object[],E> func)
                                                         throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

importData

public static <T,E extends java.lang.Exception> long importData(java.util.Iterator<T> iter,
                                                                long offset,
                                                                long count,
                                                                java.sql.PreparedStatement stmt,
                                                                int batchSize,
                                                                int batchInterval,
                                                                Try.Function<T,java.lang.Object[],E> func)
                                                         throws E extends java.lang.Exception

Imports the data from Iterator to database.

Parameters:

iter -

offset -

count -

stmt -

batchSize -

batchInterval -

func - convert element to the parameters for record insert. Returns a null array to skip the line.

Returns:

Throws:

E extends java.lang.Exception

importData

public static <T> long importData(java.util.Iterator<T> iter,
                                  java.sql.Connection conn,
                                  java.lang.String insertSQL,
                                  Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)

importData

public static <T> long importData(java.util.Iterator<T> iter,
                                  long offset,
                                  long count,
                                  java.sql.Connection conn,
                                  java.lang.String insertSQL,
                                  int batchSize,
                                  int batchInterval,
                                  Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)

importData

public static <T,E extends java.lang.Exception> long importData(java.util.Iterator<T> iter,
                                                                long offset,
                                                                long count,
                                                                Try.Predicate<? super T,E> filter,
                                                                java.sql.Connection conn,
                                                                java.lang.String insertSQL,
                                                                int batchSize,
                                                                int batchInterval,
                                                                Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)
                                                         throws E extends java.lang.Exception

Parameters:

iter -

offset -

count -

filter -

conn -

insertSQL -

batchSize -

batchInterval -

stmtSetter -

Returns:

Throws:

E extends java.lang.Exception

importData

public static <T> long importData(java.util.Iterator<T> iter,
                                  java.sql.PreparedStatement stmt,
                                  Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)

importData

public static <T> long importData(java.util.Iterator<T> iter,
                                  long offset,
                                  long count,
                                  java.sql.PreparedStatement stmt,
                                  int batchSize,
                                  int batchInterval,
                                  Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)

importData

public static <T,E extends java.lang.Exception> long importData(java.util.Iterator<T> iter,
                                                                long offset,
                                                                long count,
                                                                Try.Predicate<? super T,E> filter,
                                                                java.sql.PreparedStatement stmt,
                                                                int batchSize,
                                                                int batchInterval,
                                                                Try.BiConsumer<? super java.sql.PreparedStatement,? super T,java.sql.SQLException> stmtSetter)
                                                         throws E extends java.lang.Exception

Imports the data from Iterator to database.

Parameters:

iter -

offset -

count -

filter -

stmt -

batchSize -

batchInterval -

stmtSetter -

Returns:

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.Connection conn,
                                                         java.lang.String sql,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.Connection conn,
                                                                                        java.lang.String sql,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.Connection conn,
                                                         java.lang.String sql,
                                                         long offset,
                                                         long count,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.Connection conn,
                                                                                        java.lang.String sql,
                                                                                        long offset,
                                                                                        long count,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.Connection conn,
                                                         java.lang.String sql,
                                                         long offset,
                                                         long count,
                                                         int processThreadNum,
                                                         int queueSize,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.Connection conn,
                                                                                        java.lang.String sql,
                                                                                        long offset,
                                                                                        long count,
                                                                                        int processThreadNum,
                                                                                        int queueSize,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Parse the ResultSet obtained by executing query with the specified Connection and sql.

Parameters:

conn -

sql -

offset -

count -

processThreadNum - new threads started to parse/process the lines/records

queueSize - size of queue to save the processing records/lines loaded from source data. Default size is 1024.

rowParser -

onComplete -

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.PreparedStatement stmt,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.PreparedStatement stmt,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.PreparedStatement stmt,
                                                         long offset,
                                                         long count,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.PreparedStatement stmt,
                                                                                        long offset,
                                                                                        long count,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.PreparedStatement stmt,
                                                         long offset,
                                                         long count,
                                                         int processThreadNum,
                                                         int queueSize,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.PreparedStatement stmt,
                                                                                        long offset,
                                                                                        long count,
                                                                                        int processThreadNum,
                                                                                        int queueSize,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Parse the ResultSet obtained by executing query with the specified PreparedStatement.

Parameters:

stmt -

offset -

count -

processThreadNum - new threads started to parse/process the lines/records

queueSize - size of queue to save the processing records/lines loaded from source data. Default size is 1024.

rowParser -

onComplete -

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.ResultSet rs,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.ResultSet rs,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.ResultSet rs,
                                                         long offset,
                                                         long count,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.ResultSet rs,
                                                                                        long offset,
                                                                                        long count,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception> void parse(java.sql.ResultSet rs,
                                                         long offset,
                                                         long count,
                                                         int processThreadNum,
                                                         int queueSize,
                                                         Try.Consumer<java.lang.Object[],E> rowParser)
                                                  throws E extends java.lang.Exception

Throws:

E extends java.lang.Exception

parse

public static <E extends java.lang.Exception,E2 extends java.lang.Exception> void parse(java.sql.ResultSet rs,
                                                                                        long offset,
                                                                                        long count,
                                                                                        int processThreadNum,
                                                                                        int queueSize,
                                                                                        Try.Consumer<java.lang.Object[],E> rowParser,
                                                                                        Try.Runnable<E2> onComplete)
                                                                                 throws E extends java.lang.Exception,
                                                                                        E2 extends java.lang.Exception

Parse the ResultSet.

Parameters:

stmt -

offset -

count -

processThreadNum - new threads started to parse/process the lines/records

queueSize - size of queue to save the processing records/lines loaded from source data. Default size is 1024.

rowParser -

onComplete -

Throws:

E extends java.lang.Exception

copy

public static long copy(java.sql.Connection sourceConn,
                        java.lang.String selectSql,
                        java.sql.Connection targetConn,
                        java.lang.String insertSql)

copy

public static long copy(java.sql.Connection sourceConn,
                        java.lang.String selectSql,
                        int fetchSize,
                        long offset,
                        long count,
                        java.sql.Connection targetConn,
                        java.lang.String insertSql,
                        Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter,
                        int batchSize,
                        int batchInterval,
                        boolean inParallel)

Parameters:

sourceConn -

selectSql -

fetchSize -

offset -

count -

targetConn -

insertSql -

stmtSetter -

batchSize -

batchInterval -

inParallel - do the read and write in separated threads.

Returns:

copy

public static long copy(java.sql.PreparedStatement selectStmt,
                        java.sql.PreparedStatement insertStmt,
                        Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter)

copy

public static long copy(java.sql.PreparedStatement selectStmt,
                        long offset,
                        long count,
                        java.sql.PreparedStatement insertStmt,
                        Try.BiConsumer<? super java.sql.PreparedStatement,? super java.lang.Object[],java.sql.SQLException> stmtSetter,
                        int batchSize,
                        int batchInterval,
                        boolean inParallel)

Parameters:

selectStmt -

offset -

count -

insertStmt -

stmtSetter -

batchSize -

batchInterval -

inParallel - do the read and write in separated threads.

Returns:

doesTableExist

public static boolean doesTableExist(java.sql.Connection conn,
                                     java.lang.String tableName)

createTableIfNotExists

public static boolean createTableIfNotExists(java.sql.Connection conn,
                                             java.lang.String tableName,
                                             java.lang.String schema)

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

Parameters:

conn -

tableName -

schema -

Returns:

dropTableIfExists

public static boolean dropTableIfExists(java.sql.Connection conn,
                                        java.lang.String tableName)

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

Parameters:

conn -

tableName -

Returns:

getColumnNameList

public static java.util.List<java.lang.String> getColumnNameList(java.sql.Connection conn,
                                                                 java.lang.String tableName)

Parameters:

conn -

tableName -

Returns: