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