Methods

The methods of Java.Sql.IPreparedStatement are listed below. For a list of all members, see the IPreparedStatement Members list.

Public Methods

	AddBatch() Add a set of parameters to the `PreparedStatement`'s command batch.
	ClearParameters() Clear the current parameter values.
	Execute() : bool Executes the SQL statement in this `PreparedStatement`.
	ExecuteQuery() : IResultSet Executes the SQL query in the `PreparedStatement` and returns the `ResultSet` generated by the query.
	ExecuteUpdate() : int Invokes the SQL command contained within the prepared statement.
	SetArray(int, IArray) Sets the value of a specified parameter to the supplied `Array`.
	SetAsciiStream(int, System.IO.Stream) Sets the value of the specified parameter to the bytes from `inputStream`.
	SetAsciiStream(int, System.IO.Stream, int) Sets the value of a specified parameter to the content of a supplied `InputStream`, which has a specified number of bytes.
	SetAsciiStream(int, System.IO.Stream, long) Sets the value of the specified parameter to the next `length` bytes from `inputStream`.
	SetBigDecimal(int, Java.Math.BigDecimal) Sets the value of a specified parameter to a supplied `java.math.BigDecimal` value.
	SetBinaryStream(int, System.IO.Stream) Sets the value of the specified parameter to the bytes from `inputStream`.
	SetBinaryStream(int, System.IO.Stream, int) Sets the value of a specified parameter to the content of a supplied binary `InputStream`, which has a specified number of bytes.
	SetBinaryStream(int, System.IO.Stream, long) Sets the value of the specified parameter to the next `length` bytes from `inputStream`.
	SetBlob(int, IBlob) Sets the value of a specified parameter to the given `Blob` object.
	SetBlob(int, System.IO.Stream) Sets the value of the specified parameter to the bytes from `inputStream`.
	SetBlob(int, System.IO.Stream, long) Sets the value of the specified parameter to the next `length` bytes from `inputStream`.
	SetBoolean(int, bool) Sets the value of a specified parameter to a supplied `boolean` value.
	SetByte(int, sbyte) Sets the value of a specified parameter to a supplied `byte` value.
	SetBytes(int, byte[]) Sets the value of a specified parameter to a supplied array of bytes.
	SetCharacterStream(int, Java.IO.Reader) Sets the value of the specified parameter to the characters from `reader`.
	SetCharacterStream(int, Java.IO.Reader, int) Sets the value of a specified parameter to the character content of a `Reader` object, with the specified length of character data.
	SetCharacterStream(int, Java.IO.Reader, long) Sets the value of the specified parameter to the next `length` characters from `reader`.
	SetClob(int, Java.IO.Reader) Sets the value of the specified parameter to the characters from `reader`.
	SetClob(int, IClob) Sets the value of a specified parameter to the given `Clob` object.
	SetClob(int, Java.IO.Reader, long) Sets the value of the specified parameter to the next `length` characters from `reader`.
	SetDate(int, Date) Sets the value of a specified parameter to a supplied `java.sql.Date` value.
	SetDate(int, Date, Java.Util.Calendar) Sets the value of a specified parameter to a supplied `java.sql.Date` value, using a supplied `Calendar` to map the Date.
	SetDouble(int, double) Sets the value of a specified parameter to a supplied `double` value.
	SetFloat(int, float) Sets the value of a specified parameter to to a supplied `float` value.
	SetInt(int, int) Sets the value of a specified parameter to a supplied `int` value.
	SetLong(int, long) Sets the value of a specified parameter to a supplied `long` value.
	SetNCharacterStream(int, Java.IO.Reader) Sets the value of the specified parameter to the characters from `reader`.
	SetNCharacterStream(int, Java.IO.Reader, long) Sets the value of the specified parameter to the next `length` characters from `reader`.
	SetNClob(int, Java.IO.Reader) Sets the value of the specified parameter to the characters from `reader`.
	SetNClob(int, INClob) Sets the value of the specified parameter to `value`.
	SetNClob(int, Java.IO.Reader, long) Sets the value of the specified parameter to the next `length` characters from `reader`.
	SetNString(int, string) Sets the value of a specified parameter to a supplied string.
	SetNull(int, int) Sets the value of a specified parameter to SQL `NULL`.
	SetNull(int, int, string) Sets the value of a specified parameter to SQL `NULL`.
	SetObject(int, Java.Lang.Object) Sets the value of a specified parameter using a supplied object.
	SetObject(int, Java.Lang.Object, int) Sets the value of a specified parameter using a supplied object.
	SetObject(int, Java.Lang.Object, int, int) Sets the value of a specified parameter using a supplied object.
	SetRef(int, IRef) Sets the value of a specified parameter to a supplied `REF()` value.
	SetRowId(int, IRowId) Sets the value of a specified parameter to a supplied `java.sql.RowId`.
	SetShort(int, short) Sets the value of a specified parameter to a supplied `short` value.
	SetSQLXML(int, ISQLXML) Sets the value of the specified parameter to the value of `xmlObject`.
	SetString(int, string) Sets the value of a specified parameter to a supplied string.
	SetTime(int, Time) Sets the value of a specified parameter to a supplied `java.sql.Time` value.
	SetTime(int, Time, Java.Util.Calendar) Sets the value of a specified parameter to a supplied `java.sql.Time` value, using a supplied `Calendar`.
	SetTimestamp(int, Timestamp) Sets the value of a specified parameter to a supplied java.sql.
	SetTimestamp(int, Timestamp, Java.Util.Calendar) Sets the value of a specified parameter to a supplied `java.sql.Timestamp` value, using the supplied `Calendar`.
	SetUnicodeStream(int, System.IO.Stream, int) Sets the value of a specified parameter to the characters from a supplied `InputStream`, with a specified number of bytes.
	SetURL(int, Java.Net.URL) Sets the value of a specified parameter to a supplied `java.net.URL`.