PASSING INPUT PARAMETERS TO PREPAREDSTATEMENT in Font

Encode PDF-417 2d barcode in Font PASSING INPUT PARAMETERS TO PREPAREDSTATEMENT

void void setArray(int i, Array x) setAsciiStream (int parameterIndex, InputStream x, int length)

Sets the designated parameter to the given Array object. Sets the designated parameter to the given input stream, which will have the specified number of bytes. (By using the int data type for length, the JDBC API assumes that the stream will be up to 2GB.) Sets the designated parameter to the given java.math.BigDecimal value. Sets the designated parameter to the given input stream, which will have the specified number of bytes. (By using the int data type for length, the JDBC API assumes that the stream will be up to 2GB.) Sets the designated parameter to the given Blob object. Sets the designated parameter to the given Java boolean value. Sets the designated parameter to the given Java byte value. Sets the designated parameter to the given Java array of bytes. Sets the designated parameter to the given Reader object, which is the given number of characters long. Sets the designated parameter to the given Clob object. Sets the designated parameter to the given java.sql.Date value. Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. Sets the designated parameter to the given Java double value. Sets the designated parameter to the given Java float value. Sets the designated parameter to the given Java int value. Sets the designated parameter to the given Java long value. Sets the designated parameter to SQL NULL. Sets the designated parameter to SQL NULL. Sets the value of the designated parameter using the given object. Sets the value of the designated parameter with the given object.

setBigDecimal (int parameterIndex,BigDecimal x) setBinaryStream (int parameterIndex, InputStream x, int length)

setBlob(int i, Blob x) setBoolean (int parameterIndex, boolean x) setByte (int parameterIndex, byte x) setBytes (int parameterIndex, byte[] x) setCharacterStream (int parameterIndex, Reader reader, int length) setClob(int i, Clob x) setDate (int parameterIndex, Date x) setDate(int parameterIndex, Date x, Calendar cal) setDouble (int parameterIndex, double x) setFloat (int parameterIndex, float x) setInt (int parameterIndex, int x) setLong (int parameterIndex, long x) setNull (int parameterIndex, int sqlType) setNull(int paramIndex, int sqlType, String typeName) setObject(int parameterIndex, Object x) setObject(int parameterIndex, Object x, int targetSqlType)

void setObject(int parameterIndex, Object x, int targetSqlType, int scale) setRef(int i, Ref x) setShort(int parameterIndex, short x) setString(int parameterIndex, String x) setTime(int parameterIndex, Time x) setTime(int parameterIndex, Time x, Calendar cal) setTimestamp(int parameterIndex, Timestamp x) setTimestamp(int parameterIndex, Timestamp x, Calendar cal) setURL(int parameterIndex, URL x)

Sets the value of the designated parameter with the given object. Sets the designated parameter to the given REF(<structured-type>) value. Sets the designated parameter to the given Java short value. Sets the designated parameter to the given Java String value. Sets the designated parameter to the given java.sql.Time value. Sets the designated parameter to the given java.sql.Time value, using the given Calendar object. Sets the designated parameter to the given java.sql.Timestamp value. Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. Sets the designated parameter to the given java.net.URL value.

13-2. How Do You Use PreparedStatement.setArray()

The following sections show how to pass a java.sql.Array object (as an input parameter) to a PreparedStatement object.

The signature of PreparedStatement.setArray() is as follows: void setArray(int parameterIndex, java.sql.Array array) throws SQLException This sets the designated parameter to the given Array object. The driver converts this to a SQL ARRAY value when it sends it to the database. The parameters are as follows: parameterIndex: The first parameter is 1, the second is 2, and so on. array: This is a java.sql.Array object, which must be implemented by a class. What is java.sql.Array This is the mapping in the Java programming language for the SQL type ARRAY. By default, an Array value is a transaction-duration reference to a SQL ARRAY value. By default, an Array object is implemented using a SQL LOCATOR (array) internally, which means that an Array object contains a logical pointer to the data in the SQL ARRAY value rather than containing the ARRAY value s data. The Array interface provides methods for bringing a SQL ARRAY value s data to the client as either an array or a ResultSet object. If the elements of the SQL ARRAY are a user-defined type, they may be custom mapped. To create a custom mapping, follow these steps: