PreparedStatement Members

PreparedStatement Members

Interface Overview | This Package | All Packages

Methods
Name Description
clearParameters()

In general, parameter values remain in force for repeated use of a Statement.

execute() Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.
executeQuery() A prepared SQL query is executed and its ResultSet is returned.
executeUpdate() Execute a SQL INSERT, UPDATE or DELETE statement.
setAsciiStream(int, InputStream, int) When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream.
setBigDecimal(int, BigDecimal) Set a parameter to a java.lang.BigDecimal value.
setBinaryStream(int, InputStream, int) When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream.
setBoolean(int, boolean) Set a parameter to a Java boolean value.
setByte(int, byte) Set a parameter to a Java byte value.
setBytes(int, byte[]) Set a parameter to a Java array of bytes.
setDate(int, Date) Set a parameter to a java.sql.Date value.
setDouble(int, double) Set a parameter to a Java double value.
setFloat(int, float) Set a parameter to a Java float value.
setInt(int, int) Set a parameter to a Java int value.
setLong(int, long) Set a parameter to a Java long value.
setNull(int, int) Set a parameter to SQL NULL.
setObject(int, Object)

Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.

setObject(int, Object, int) This method is like setObject above, but assumes a scale of zero.
setObject(int, Object, int, int)

Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.

setShort(int, short) Set a parameter to a Java short value.
setString(int, String) Set a parameter to a Java String value.
setTime(int, Time) Set a parameter to a java.sql.Time value.
setTimestamp(int, Timestamp) Set a parameter to a java.sql.Timestamp value.
setUnicodeStream(int, InputStream, int) When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream.