Package com.landawn.abacus.jdbc

Class NamedQuery

java.lang.Object

com.landawn.abacus.jdbc.AbstractPreparedQuery<PreparedStatement,NamedQuery>

com.landawn.abacus.jdbc.NamedQuery

All Implemented Interfaces:

Closeable, AutoCloseable

public final class NamedQuery
extends AbstractPreparedQuery<PreparedStatement,NamedQuery>

The backed 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.

Author:

haiyangl

See Also:

• http://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html
• http://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html
• http://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html
• http://docs.oracle.com/javase/8/docs/api/java/sql/ResultSet.html

Method Summary

Modifier and Type	Method	Description
<T> NamedQuery	addBatchParameters(Collection<? extends T> batchParameters)
NamedQuery	setArray(String parameterName, Array x)
NamedQuery	setAsciiStream(String parameterName, InputStream x)	Sets the ascii stream.
NamedQuery	setAsciiStream(String parameterName, InputStream x, long length)	Sets the ascii stream.
NamedQuery	setBigDecimal(String parameterName, BigDecimal x)	Sets the big decimal.
NamedQuery	setBinaryStream(String parameterName, InputStream x)	Sets the binary stream.
NamedQuery	setBinaryStream(String parameterName, InputStream x, long length)	Sets the binary stream.
NamedQuery	setBlob(String parameterName, InputStream x)	Sets the blob.
NamedQuery	setBlob(String parameterName, InputStream x, long length)	Sets the blob.
NamedQuery	setBlob(String parameterName, Blob x)	Sets the blob.
NamedQuery	setBoolean(String parameterName, boolean x)	Sets the boolean.
NamedQuery	setBoolean(String parameterName, Boolean x)	Sets the boolean.
NamedQuery	setByte(String parameterName, byte x)	Sets the byte.
NamedQuery	setByte(String parameterName, Byte x)	Sets the byte.
NamedQuery	setBytes(String parameterName, byte[] x)	Sets the bytes.
NamedQuery	setCharacterStream(String parameterName, Reader x)	Sets the character stream.
NamedQuery	setCharacterStream(String parameterName, Reader x, long length)	Sets the character stream.
NamedQuery	setClob(String parameterName, Reader x)	Sets the clob.
NamedQuery	setClob(String parameterName, Reader x, long length)	Sets the clob.
NamedQuery	setClob(String parameterName, Clob x)	Sets the clob.
NamedQuery	setDate(String parameterName, Date x)	Sets the date.
NamedQuery	setDate(String parameterName, Date x)	Sets the date.
NamedQuery	setDouble(String parameterName, double x)	Sets the double.
NamedQuery	setDouble(String parameterName, Double x)	Sets the double.
NamedQuery	setFloat(String parameterName, float x)	Sets the float.
NamedQuery	setFloat(String parameterName, Float x)	Sets the float.
NamedQuery	setInt(String parameterName, char x)	Deprecated. generally char should be saved as String in db.
NamedQuery	setInt(String parameterName, int x)	Sets the int.
NamedQuery	setInt(String parameterName, Character x)	Deprecated. generally char should be saved as String in db.
NamedQuery	setInt(String parameterName, Integer x)	Sets the int.
NamedQuery	setLong(String parameterName, long x)	Sets the long.
NamedQuery	setLong(String parameterName, Long x)	Sets the long.
NamedQuery	setNCharacterStream(String parameterName, Reader x)	Sets the N character stream.
NamedQuery	setNCharacterStream(String parameterName, Reader x, long length)	Sets the N character stream.
NamedQuery	setNClob(String parameterName, Reader x)	Sets the N clob.
NamedQuery	setNClob(String parameterName, Reader x, long length)	Sets the N clob.
NamedQuery	setNClob(String parameterName, NClob x)	Sets the N clob.
NamedQuery	setNull(String parameterName, int sqlType)	Sets the null.
NamedQuery	setNull(String parameterName, int sqlType, String typeName)	Sets the null.
NamedQuery	setObject(String parameterName, Object x)	Sets the object.
NamedQuery	setObject(String parameterName, Object x, int sqlType)	Sets the object.
NamedQuery	setObject(String parameterName, Object x, int sqlType, int scaleOrLength)	Sets the object.
NamedQuery	setObject(String parameterName, Object x, com.landawn.abacus.type.Type<Object> type)	Sets the object.
NamedQuery	setObject(String parameterName, Object x, SQLType sqlType)	Sets the object.
NamedQuery	setObject(String parameterName, Object x, SQLType sqlType, int scaleOrLength)	Sets the object.
NamedQuery	setParameters(Object parameters)	Sets the parameters.
NamedQuery	setParameters(Object entity, Collection<String> parameterNames)	Sets the parameters.
NamedQuery	setParameters(Map<String,?> parameters)	Sets the parameters.
<T> NamedQuery	setParameters(T paramaters, Jdbc.TriParametersSetter<? super NamedQuery,? super T> paramsSetter)	Sets the parameters.
NamedQuery	setRef(String parameterName, Ref x)
NamedQuery	setRowId(String parameterName, RowId x)
NamedQuery	setShort(String parameterName, short x)	Sets the short.
NamedQuery	setShort(String parameterName, Short x)	Sets the short.
NamedQuery	setSQLXML(String parameterName, SQLXML x)
NamedQuery	setString(String parameterName, char x)
NamedQuery	setString(String parameterName, Character x)
NamedQuery	setString(String parameterName, CharSequence x)
NamedQuery	setString(String parameterName, String x)	Sets the string.
NamedQuery	setTime(String parameterName, Time x)	Sets the time.
NamedQuery	setTime(String parameterName, Date x)	Sets the time.
NamedQuery	setTimestamp(String parameterName, Timestamp x)	Sets the timestamp.
NamedQuery	setTimestamp(String parameterName, Date x)	Sets the timestamp.
NamedQuery	setURL(String parameterName, URL x)

Methods inherited from class com.landawn.abacus.jdbc.AbstractPreparedQuery

addBatch, 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, queryForBytes, queryForChar, queryForDate, queryForDouble, queryForFloat, queryForInt, queryForLong, queryForShort, queryForSingleNonNull, queryForSingleNonNull, queryForSingleResult, queryForSingleResult, queryForString, queryForTime, queryForTimestamp, queryForUniqueNonNull, queryForUniqueNonNull, queryForUniqueResult, 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, setDoubleForMultiPositions, setDoubleForMultiPositions, 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, 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

Methods inherited from class java.lang.Object

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

Method Details

setNull

public NamedQuery setNull(String parameterName,
 int sqlType)
                   throws SQLException

Sets the null.

Parameters:

parameterName -

sqlType -

Returns:

Throws:

SQLException - the SQL exception

See Also:

• Types

setNull

public NamedQuery setNull(String parameterName,
 int sqlType,
 String typeName)
                   throws SQLException

Sets the null.

Parameters:

parameterName -

sqlType -

typeName -

Returns:

Throws:

SQLException - the SQL exception

See Also:

• Types

setBoolean

public NamedQuery setBoolean(String parameterName,
 boolean x)
                      throws SQLException

Sets the boolean.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setBoolean

public NamedQuery setBoolean(String parameterName,
 Boolean x)
                      throws SQLException

Sets the boolean.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setByte

public NamedQuery setByte(String parameterName,
 byte x)
                   throws SQLException

Sets the byte.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setByte

public NamedQuery setByte(String parameterName,
 Byte x)
                   throws SQLException

Sets the byte.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setShort

public NamedQuery setShort(String parameterName,
 short x)
                    throws SQLException

Sets the short.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setShort

public NamedQuery setShort(String parameterName,
 Short x)
                    throws SQLException

Sets the short.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setInt

public NamedQuery setInt(String parameterName,
 int x)
                  throws SQLException

Sets the int.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setInt

public NamedQuery setInt(String parameterName,
 Integer x)
                  throws SQLException

Sets the int.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setInt

@Deprecated
public NamedQuery setInt(String parameterName,
 char x)
                  throws SQLException

Deprecated.

generally char should be saved as String in db.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException

See Also:

• setString(String, char)

setInt

@Deprecated
public NamedQuery setInt(String parameterName,
 Character x)
                  throws SQLException

Deprecated.

generally char should be saved as String in db.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException

See Also:

• setString(String, Character)

setLong

public NamedQuery setLong(String parameterName,
 long x)
                   throws SQLException

Sets the long.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setLong

public NamedQuery setLong(String parameterName,
 Long x)
                   throws SQLException

Sets the long.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setFloat

public NamedQuery setFloat(String parameterName,
 float x)
                    throws SQLException

Sets the float.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setFloat

public NamedQuery setFloat(String parameterName,
 Float x)
                    throws SQLException

Sets the float.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setDouble

public NamedQuery setDouble(String parameterName,
 double x)
                     throws SQLException

Sets the double.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setDouble

public NamedQuery setDouble(String parameterName,
 Double x)
                     throws SQLException

Sets the double.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setBigDecimal

public NamedQuery setBigDecimal(String parameterName,
 BigDecimal x)
                         throws SQLException

Sets the big decimal.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setString

public NamedQuery setString(String parameterName,
 String x)
                     throws SQLException

Sets the string.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setString

public NamedQuery setString(String parameterName,
 CharSequence x)
                     throws SQLException

Throws:

SQLException

setString

public NamedQuery setString(String parameterName,
 char x)
                     throws SQLException

Throws:

SQLException

setString

public NamedQuery setString(String parameterName,
 Character x)
                     throws SQLException

Throws:

SQLException

setDate

public NamedQuery setDate(String parameterName,
 Date x)
                   throws SQLException

Sets the date.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setDate

public NamedQuery setDate(String parameterName,
 Date x)
                   throws SQLException

Sets the date.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setTime

public NamedQuery setTime(String parameterName,
 Time x)
                   throws SQLException

Sets the time.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setTime

public NamedQuery setTime(String parameterName,
 Date x)
                   throws SQLException

Sets the time.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setTimestamp

public NamedQuery setTimestamp(String parameterName,
 Timestamp x)
                        throws SQLException

Sets the timestamp.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setTimestamp

public NamedQuery setTimestamp(String parameterName,
 Date x)
                        throws SQLException

Sets the timestamp.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setBytes

public NamedQuery setBytes(String parameterName,
 byte[] x)
                    throws SQLException

Sets the bytes.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setAsciiStream

public NamedQuery setAsciiStream(String parameterName,
 InputStream x)
                          throws SQLException

Sets the ascii stream.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setAsciiStream

public NamedQuery setAsciiStream(String parameterName,
 InputStream x,
 long length)
                          throws SQLException

Sets the ascii stream.

Parameters:

parameterName -

x -

length -

Returns:

Throws:

SQLException - the SQL exception

setBinaryStream

public NamedQuery setBinaryStream(String parameterName,
 InputStream x)
                           throws SQLException

Sets the binary stream.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setBinaryStream

public NamedQuery setBinaryStream(String parameterName,
 InputStream x,
 long length)
                           throws SQLException

Sets the binary stream.

Parameters:

parameterName -

x -

length -

Returns:

Throws:

SQLException - the SQL exception

setCharacterStream

public NamedQuery setCharacterStream(String parameterName,
 Reader x)
                              throws SQLException

Sets the character stream.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setCharacterStream

public NamedQuery setCharacterStream(String parameterName,
 Reader x,
 long length)
                              throws SQLException

Sets the character stream.

Parameters:

parameterName -

x -

length -

Returns:

Throws:

SQLException - the SQL exception

setNCharacterStream

public NamedQuery setNCharacterStream(String parameterName,
 Reader x)
                               throws SQLException

Sets the N character stream.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setNCharacterStream

public NamedQuery setNCharacterStream(String parameterName,
 Reader x,
 long length)
                               throws SQLException

Sets the N character stream.

Parameters:

parameterName -

x -

length -

Returns:

Throws:

SQLException - the SQL exception

setBlob

public NamedQuery setBlob(String parameterName,
 Blob x)
                   throws SQLException

Sets the blob.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setBlob

public NamedQuery setBlob(String parameterName,
 InputStream x)
                   throws SQLException

Sets the blob.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setBlob

public NamedQuery setBlob(String parameterName,
 InputStream x,
 long length)
                   throws SQLException

Sets the blob.

Parameters:

parameterName -

x -

length -

Returns:

Throws:

SQLException - the SQL exception

setClob

public NamedQuery setClob(String parameterName,
 Clob x)
                   throws SQLException

Sets the clob.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setClob

public NamedQuery setClob(String parameterName,
 Reader x)
                   throws SQLException

Sets the clob.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setClob

public NamedQuery setClob(String parameterName,
 Reader x,
 long length)
                   throws SQLException

Sets the clob.

Parameters:

parameterName -

x -

length -

Returns:

Throws:

SQLException - the SQL exception

setNClob

public NamedQuery setNClob(String parameterName,
 NClob x)
                    throws SQLException

Sets the N clob.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setNClob

public NamedQuery setNClob(String parameterName,
 Reader x)
                    throws SQLException

Sets the N clob.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setNClob

public NamedQuery setNClob(String parameterName,
 Reader x,
 long length)
                    throws SQLException

Sets the N clob.

Parameters:

parameterName -

x -

length -

Returns:

Throws:

SQLException - the SQL exception

setURL

public NamedQuery setURL(String parameterName,
 URL x)
                  throws SQLException

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setSQLXML

public NamedQuery setSQLXML(String parameterName,
 SQLXML x)
                     throws SQLException

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setRowId

public NamedQuery setRowId(String parameterName,
 RowId x)
                    throws SQLException

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setRef

public NamedQuery setRef(String parameterName,
 Ref x)
                  throws SQLException

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setArray

public NamedQuery setArray(String parameterName,
 Array x)
                    throws SQLException

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setObject

public NamedQuery setObject(String parameterName,
 Object x)
                     throws SQLException

Sets the object.

Parameters:

parameterName -

x -

Returns:

Throws:

SQLException - the SQL exception

setObject

public NamedQuery setObject(String parameterName,
 Object x,
 int sqlType)
                     throws SQLException

Sets the object.

Parameters:

parameterName -

x -

sqlType -

Returns:

Throws:

SQLException - the SQL exception

See Also:

• Types

setObject

public NamedQuery setObject(String parameterName,
 Object x,
 int sqlType,
 int scaleOrLength)
                     throws SQLException

Sets the object.

Parameters:

parameterName -

x -

sqlType -

scaleOrLength -

Returns:

Throws:

SQLException - the SQL exception

See Also:

• Types

setObject

public NamedQuery setObject(String parameterName,
 Object x,
 SQLType sqlType)
                     throws SQLException

Sets the object.

Parameters:

parameterName -

x -

sqlType -

Returns:

Throws:

SQLException - the SQL exception

setObject

public NamedQuery setObject(String parameterName,
 Object x,
 SQLType sqlType,
 int scaleOrLength)
                     throws SQLException

Sets the object.

Parameters:

parameterName -

x -

sqlType -

scaleOrLength -

Returns:

Throws:

SQLException - the SQL exception

setObject

public NamedQuery setObject(String parameterName,
 Object x,
 com.landawn.abacus.type.Type<Object> type)
                     throws SQLException

Sets the object.

Parameters:

parameterName -

x -

type -

Returns:

Throws:

SQLException - the SQL exception

setParameters

public NamedQuery setParameters(Map<String,?> parameters)
                         throws SQLException

Sets the parameters.

Parameters:

parameters -

Returns:

Throws:

SQLException - the SQL exception

setParameters

public NamedQuery setParameters(Object parameters)
                         throws SQLException

Sets the parameters.

Parameters:

parameters - with getter/setter methods

Returns:

Throws:

SQLException - the SQL exception

setParameters

public NamedQuery setParameters(Object entity,
 Collection<String> parameterNames)
                         throws SQLException

Sets the parameters.

Parameters:

entity -

parameterNames -

Returns:

Throws:

SQLException - the SQL exception

setParameters

public <T> NamedQuery setParameters(T paramaters,
 Jdbc.TriParametersSetter<? super NamedQuery,? super T> paramsSetter)
                             throws SQLException

Sets the parameters.

Type Parameters:

T -

Parameters:

paramaters -

paramsSetter -

Returns:

Throws:

SQLException - the SQL exception

addBatchParameters

public <T> NamedQuery addBatchParameters(Collection<? extends T> batchParameters)
                                  throws SQLException

Overrides:

addBatchParameters in class AbstractPreparedQuery<PreparedStatement,NamedQuery>

Returns:

Throws:

SQLException