public interface ParameterList
Abstraction of a list of parameters to be substituted into a Query. The protocol-specific details of how to efficiently store and stream the parameters is hidden behind implementations of this interface.
In general, instances of ParameterList are associated with a particular Query object (the one that created them) and shouldn't be used against another Query.
Parameter indexes are 1-based to match JDBC's PreparedStatement, i.e. the first parameter has index 1.
Modifier and Type | Method and Description |
---|---|
void |
appendAll(ParameterList list)
Use this operation to append more parameters to the current list.
|
void |
clear()
Unbind all parameter values bound in this list.
|
ParameterList |
copy()
Perform a shallow copy of this ParameterList, returning a new instance (still suitable for
passing to the owning Query).
|
int |
getInParameterCount()
Get the number of IN parameters in this list.
|
int |
getOutParameterCount()
Get the number of OUT parameters in this list.
|
int |
getParameterCount()
Get the number of parameters in this list.
|
int[] |
getTypeOIDs()
Return the oids of the parameters in this list.
|
Object[] |
getValues()
Returns the bound parameter values.
|
void |
registerOutParameter(int index,
int sqlType) |
void |
setBinaryParameter(int index,
byte[] value,
int oid)
Binds given byte[] value to a parameter.
|
void |
setBytea(int index,
byte[] data,
int offset,
int length)
Binds a binary bytea value stored as a bytearray to a parameter.
|
void |
setBytea(int index,
ByteStreamWriter writer)
Binds a binary bytea value stored as a ByteStreamWriter.
|
void |
setBytea(int index,
InputStream stream)
Binds a binary bytea value stored as an InputStream.
|
void |
setBytea(int index,
InputStream stream,
int length)
Binds a binary bytea value stored as an InputStream.
|
void |
setIntParameter(int index,
int value)
Binds an integer value to a parameter.
|
void |
setLiteralParameter(int index,
String value,
int oid)
Binds a String value that is an unquoted literal to the server's query parser (for example, a
bare integer) to a parameter.
|
void |
setNull(int index,
int oid)
Binds a SQL NULL value to a parameter.
|
void |
setStringParameter(int index,
String value,
int oid)
Binds a String value that needs to be quoted for the server's parser to understand (for
example, a timestamp) to a parameter.
|
void |
setText(int index,
InputStream stream)
Binds a text value stored as an InputStream that is a valid UTF-8 byte stream.
|
String |
toString(int index,
boolean standardConformingStrings)
Return a human-readable representation of a particular parameter in this ParameterList.
|
void registerOutParameter(int index, int sqlType) throws SQLException
SQLException
int getParameterCount()
int getInParameterCount()
int getOutParameterCount()
int[] getTypeOIDs()
void setIntParameter(int index, int value) throws SQLException
index
- the 1-based parameter index to bind.value
- the integer value to use.SQLException
- on error or if index
is out of rangevoid setLiteralParameter(int index, String value, int oid) throws SQLException
index
- the 1-based parameter index to bind.value
- the unquoted literal string to use.oid
- the type OID of the parameter, or 0
to infer the type.SQLException
- on error or if index
is out of rangevoid setStringParameter(int index, String value, int oid) throws SQLException
index
- the 1-based parameter index to bind.value
- the quoted string to use.oid
- the type OID of the parameter, or 0
to infer the type.SQLException
- on error or if index
is out of rangevoid setBytea(int index, byte[] data, int offset, int length) throws SQLException
index
- the 1-based parameter index to bind.data
- an array containing the raw data valueoffset
- the offset within data
of the start of the parameter data.length
- the number of bytes of parameter data within data
to use.SQLException
- on error or if index
is out of rangevoid setBytea(int index, InputStream stream, int length) throws SQLException
index
- the 1-based parameter index to bind.stream
- a stream containing the parameter data.length
- the number of bytes of parameter data to read from stream
.SQLException
- on error or if index
is out of rangevoid setBytea(int index, InputStream stream) throws SQLException
index
- the 1-based parameter index to bind.stream
- a stream containing the parameter data.SQLException
- on error or if index
is out of rangevoid setBytea(int index, ByteStreamWriter writer) throws SQLException
index
- the 1-based parameter index to bind.writer
- a writer that can write the bytes for the parameterSQLException
- on error or if index
is out of rangevoid setText(int index, InputStream stream) throws SQLException
index
- the 1-based parameter index to bind.stream
- a stream containing the parameter data.SQLException
- on error or if index
is out of rangevoid setBinaryParameter(int index, byte[] value, int oid) throws SQLException
index
- the 1-based parameter index to bind.value
- the bytes to send.oid
- the type OID of the parameter.SQLException
- on error or if index
is out of rangevoid setNull(int index, int oid) throws SQLException
index
- the 1-based parameter index to bind.oid
- the type OID of the parameter, or 0
to infer the type.SQLException
- on error or if index
is out of rangeParameterList copy()
void clear()
String toString(int index, boolean standardConformingStrings)
index
- the 1-based parameter index to bind.standardConformingStrings
- true if \ is not an escape character in strings literalsvoid appendAll(ParameterList list) throws SQLException
list
- of parameters to append with.SQLException
- fault raised if driver or back end throw an exceptionObject[] getValues()
Copyright © 1997-2020 PostgreSQL Global Development Group. All Rights Reserved.