Package com.landawn.abacus.jdbc
Class PreparedQuery
java.lang.Object
com.landawn.abacus.jdbc.AbstractPreparedQuery<PreparedStatement,PreparedQuery>
com.landawn.abacus.jdbc.PreparedQuery
- All Implemented Interfaces:
Closeable
,AutoCloseable
The backed
Generally, don't cache or reuse the instance of this class, except the
The
Remember: parameter/column index in
PreparedStatement/CallableStatement
will be closed by default
after any execution methods(which will trigger the backed PreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).
except the 'closeAfterExecution'
flag is set to false
by calling #closeAfterExecution(false)
.
Generally, don't cache or reuse the instance of this class, except the
'closeAfterExecution'
flag is set to false
by calling #closeAfterExecution(false)
.
The
ResultSet
returned by query will always be closed after execution, even 'closeAfterExecution'
flag is set to false
.
Remember: parameter/column index in
PreparedStatement/ResultSet
starts from 1, not 0.-
Method Summary
Methods inherited from class com.landawn.abacus.jdbc.AbstractPreparedQuery
addBatch, addBatchParameters, addBatchParameters, addBatchParameters, addBatchParameters, addBatchParameters, addBatchParameters, addBatchParameters, addBatchParameters, allMatch, allMatch, anyMatch, anyMatch, asyncCall, asyncCall, asyncRun, asyncRun, batchInsert, batchInsert, batchInsert, batchUpdate, batchUpdateAndReturnGeneratedKeys, batchUpdateAndReturnGeneratedKeys, close, closeAfterExecution, configStmt, configStmt, count, count, count, execute, executeThenAccept, executeThenAccept, executeThenApply, executeThenApply, exists, findFirst, findFirst, findFirst, findFirst, findFirst, findFirst, findFirstOrNull, findFirstOrNull, findFirstOrNull, findFirstOrNull, findFirstOrNull, findFirstOrNull, findOnlyOne, findOnlyOne, findOnlyOne, findOnlyOne, findOnlyOneOrNull, findOnlyOneOrNull, findOnlyOneOrNull, findOnlyOneOrNull, foreach, foreach, forEach, forEach, forEach, forEach, get, get, get, gett, gett, gett, ifExists, ifExists, ifExistsOrElse, ifExistsOrElse, insert, insert, insert, largeBatchUpdate, largeUpdate, list, list, list, list, list, list, list, list, list, list, list, noneMatch, noneMatch, notExists, onClose, query, query, query, queryForBigDecimal, queryForBigInteger, queryForBoolean, queryForByte, queryForChar, queryForDate, queryForDouble, queryForFloat, queryForInt, queryForLong, queryForShort, queryForSingleNonNull, queryForSingleResult, queryForString, queryForTime, queryForTimestamp, queryForUniqueNonNull, queryForUniqueResult, setArray, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDateForMultiPositions, setDateForMultiPositions, setDouble, setDouble, setFetchDirection, setFetchDirectionToForward, setFetchSize, setFloat, setFloat, setInt, setInt, setInt, setInt, setIntegerForMultiPositions, setIntForMultiPositions, setLargeMaxRows, setLong, setLong, setLongForMultiPositions, setLongForMultiPositions, setMaxFieldSize, setMaxRows, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setObject, setObjectForMultiPositions, setParameter, setParameter, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setParameters, setQueryTimeout, setRef, setRowId, setShort, setShort, setSQLXML, setString, setString, setString, setString, setStringForMultiPositions, setTime, setTime, setTimeForMultiPositions, setTimeForMultiPositions, setTimestamp, setTimestamp, setTimestampForMultiPositions, setTimestampForMultiPositions, settParameters, settParameters, settParameters, settParameters, settParameters, settParameters, settParameters, settParameters, setURL, stream, stream, stream, stream, stream, stream, update, updateAndReturnGeneratedKeys, updateAndReturnGeneratedKeys