Uses of Class
com.landawn.abacus.jdbc.PreparedQuery
Packages that use PreparedQuery
-
Uses of PreparedQuery in com.landawn.abacus.jdbc
Methods in com.landawn.abacus.jdbc that return PreparedQueryModifier and TypeMethodDescriptionstatic PreparedQuery
JdbcUtil.prepareQuery
(Connection conn, String sql) Never write below code because it will definitely causeConnection
leak:static PreparedQuery
JdbcUtil.prepareQuery
(Connection conn, String sql, boolean autoGeneratedKeys) Never write below code because it will definitely causeConnection
leak:static PreparedQuery
JdbcUtil.prepareQuery
(Connection conn, String sql, int[] returnColumnIndexes) Never write below code because it will definitely causeConnection
leak:static PreparedQuery
JdbcUtil.prepareQuery
(Connection conn, String sql, com.landawn.abacus.util.Throwables.BiFunction<Connection, String, PreparedStatement, SQLException> stmtCreator) Never write below code because it will definitely causeConnection
leak:static PreparedQuery
JdbcUtil.prepareQuery
(Connection conn, String sql, String[] returnColumnNames) Never write below code because it will definitely causeConnection
leak:static PreparedQuery
JdbcUtil.prepareQuery
(DataSource ds, String sql) If this method is called where a transaction is started byJdbcUtil.beginTransaction
or inSpring
with the sameDataSource
in the same thread, theConnection
started the Transaction will be used here.static PreparedQuery
JdbcUtil.prepareQuery
(DataSource ds, String sql, boolean autoGeneratedKeys) If this method is called where a transaction is started byJdbcUtil.beginTransaction
or inSpring
with the sameDataSource
in the same thread, theConnection
started the Transaction will be used here.static PreparedQuery
JdbcUtil.prepareQuery
(DataSource ds, String sql, int[] returnColumnIndexes) static PreparedQuery
JdbcUtil.prepareQuery
(DataSource ds, String sql, com.landawn.abacus.util.Throwables.BiFunction<Connection, String, PreparedStatement, SQLException> stmtCreator) If this method is called where a transaction is started byJdbcUtil.beginTransaction
or inSpring
with the sameDataSource
in the same thread, theConnection
started the Transaction will be used here.static PreparedQuery
JdbcUtil.prepareQuery
(DataSource ds, String sql, String[] returnColumnNames) static PreparedQuery
JdbcUtil.prepareQueryForBigResult
(Connection conn, String sql) Prepareselect
query for big result set.static PreparedQuery
JdbcUtil.prepareQueryForBigResult
(DataSource ds, String sql) Prepareselect
query for big result set.Method parameters in com.landawn.abacus.jdbc with type arguments of type PreparedQueryModifier and TypeMethodDescriptionstatic long
JdbcUtils.copy
(Connection sourceConn, String selectSql, int fetchSize, long offset, long count, Connection targetConn, String insertSql, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super ResultSet, SQLException> stmtSetter) static long
JdbcUtils.copy
(Connection sourceConn, String selectSql, int fetchSize, Connection targetConn, String insertSql, int batchSize, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super ResultSet, SQLException> stmtSetter) static long
JdbcUtils.copy
(Connection sourceConn, String selectSql, Connection targetConn, String insertSql, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super ResultSet, SQLException> stmtSetter) static long
JdbcUtils.copy
(PreparedStatement selectStmt, long offset, long count, PreparedStatement insertStmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super ResultSet, SQLException> stmtSetter) static long
JdbcUtils.copy
(PreparedStatement selectStmt, PreparedStatement insertStmt, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super ResultSet, SQLException> stmtSetter) static long
JdbcUtils.copy
(DataSource sourceDataSource, String selectSql, int fetchSize, DataSource targetDataSource, String insertSql, int batchSize, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super ResultSet, SQLException> stmtSetter) static long
JdbcUtils.copy
(DataSource sourceDataSource, String selectSql, DataSource targetDataSource, String insertSql, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super ResultSet, SQLException> stmtSetter) static <E extends Exception>
longJdbcUtils.importCSV
(File file, long offset, long count, com.landawn.abacus.util.Throwables.Predicate<String[], E> filter, Connection conn, String insertSQL, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static <E extends Exception>
longJdbcUtils.importCSV
(File file, long offset, long count, com.landawn.abacus.util.Throwables.Predicate<String[], E> filter, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) Imports the data from CSV to database.static long
JdbcUtils.importCSV
(File file, long offset, long count, Connection conn, String insertSQL, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static long
JdbcUtils.importCSV
(File file, long offset, long count, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static long
JdbcUtils.importCSV
(File file, Connection conn, String insertSQL, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) Imports the data from CSV to database.static long
JdbcUtils.importCSV
(File file, PreparedStatement stmt, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static <E extends Exception>
longJdbcUtils.importCSV
(InputStream is, long offset, long count, com.landawn.abacus.util.Throwables.Predicate<String[], E> filter, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) Imports the data from CSV to database.static long
JdbcUtils.importCSV
(InputStream is, long offset, long count, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static long
JdbcUtils.importCSV
(InputStream is, PreparedStatement stmt, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static <E extends Exception>
longJdbcUtils.importCSV
(Reader reader, long offset, long count, com.landawn.abacus.util.Throwables.Predicate<String[], E> filter, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) Imports the data from CSV to database.static long
JdbcUtils.importCSV
(Reader reader, long offset, long count, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static long
JdbcUtils.importCSV
(Reader reader, PreparedStatement stmt, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super String[], SQLException> stmtSetter) static <E extends Exception>
intJdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, int offset, int count, com.landawn.abacus.util.Throwables.Predicate<? super Object[], E> filter, Connection conn, String insertSQL, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) Imports the data fromDataSet
to database.static <E extends Exception>
intJdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, int offset, int count, com.landawn.abacus.util.Throwables.Predicate<? super Object[], E> filter, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) Imports the data fromDataSet
to database.static int
JdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, int offset, int count, Connection conn, String insertSQL, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) Imports the data fromDataSet
to database.static int
JdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, int offset, int count, Connection conn, String insertSQL, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) Imports the data fromDataSet
to database.static int
JdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, int offset, int count, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) Imports the data fromDataSet
to database.static int
JdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, int offset, int count, PreparedStatement stmt, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) Imports the data fromDataSet
to database.static int
JdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, Connection conn, String insertSQL, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) Imports the data fromDataSet
to database.static int
JdbcUtils.importData
(com.landawn.abacus.util.DataSet dataset, PreparedStatement stmt, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super Object[], SQLException> stmtSetter) static <T,
E extends Exception>
longJdbcUtils.importData
(Iterator<? extends T> iter, long offset, long count, com.landawn.abacus.util.Throwables.Predicate<? super T, E> filter, Connection conn, String insertSQL, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super T, SQLException> stmtSetter) static <T,
E extends Exception>
longJdbcUtils.importData
(Iterator<? extends T> iter, long offset, long count, com.landawn.abacus.util.Throwables.Predicate<? super T, E> filter, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super T, SQLException> stmtSetter) Imports the data from Iterator to database.static <T> long
JdbcUtils.importData
(Iterator<? extends T> iter, long offset, long count, Connection conn, String insertSQL, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super T, SQLException> stmtSetter) static <T> long
JdbcUtils.importData
(Iterator<? extends T> iter, long offset, long count, PreparedStatement stmt, int batchSize, long batchIntervalInMillis, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super T, SQLException> stmtSetter) static <T> long
JdbcUtils.importData
(Iterator<? extends T> iter, Connection conn, String insertSQL, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super T, SQLException> stmtSetter) static <T> long
JdbcUtils.importData
(Iterator<? extends T> iter, PreparedStatement stmt, com.landawn.abacus.util.Throwables.BiConsumer<? super PreparedQuery, ? super T, SQLException> stmtSetter) -
Uses of PreparedQuery in com.landawn.abacus.jdbc.dao
Methods in com.landawn.abacus.jdbc.dao that return PreparedQueryModifier and TypeMethodDescriptiondefault PreparedQuery
Dao.prepareQuery
(com.landawn.abacus.condition.Condition cond) Prepare aselect
query by specifiedcond
.default PreparedQuery
Dao.prepareQuery
(String query) default PreparedQuery
Dao.prepareQuery
(String query, boolean generateKeys) default PreparedQuery
Dao.prepareQuery
(String query, int[] returnColumnIndexes) default PreparedQuery
Dao.prepareQuery
(String sql, com.landawn.abacus.util.Throwables.BiFunction<Connection, String, PreparedStatement, SQLException> stmtCreator) default PreparedQuery
Dao.prepareQuery
(String query, String[] returnColumnNames) default PreparedQuery
Dao.prepareQuery
(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond) Prepare aselect
query by specifiedselectPropNames
andcond
.default PreparedQuery
NoUpdateDao.prepareQuery
(String query) default PreparedQuery
NoUpdateDao.prepareQuery
(String query, boolean generateKeys) default PreparedQuery
NoUpdateDao.prepareQuery
(String query, int[] returnColumnIndexes) default PreparedQuery
NoUpdateDao.prepareQuery
(String query, com.landawn.abacus.util.Throwables.BiFunction<Connection, String, PreparedStatement, SQLException> stmtCreator) Deprecated.unsupported Operationdefault PreparedQuery
NoUpdateDao.prepareQuery
(String query, String[] returnColumnNames) default PreparedQuery
ReadOnlyDao.prepareQuery
(String query) default PreparedQuery
ReadOnlyDao.prepareQuery
(String query, boolean generateKeys) Deprecated.unsupported Operationdefault PreparedQuery
ReadOnlyDao.prepareQuery
(String query, int[] returnColumnIndexes) Deprecated.unsupported Operationdefault PreparedQuery
ReadOnlyDao.prepareQuery
(String query, String[] returnColumnNames) Deprecated.unsupported Operationdefault PreparedQuery
Dao.prepareQueryForBigResult
(com.landawn.abacus.condition.Condition cond) Prepare a big resultselect
query by specifiedcond
.default PreparedQuery
Dao.prepareQueryForBigResult
(String query) default PreparedQuery
Dao.prepareQueryForBigResult
(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond) Prepare a big resultselect
query by specifiedselectPropNames
andcond
.