java.sql.PreparedStatement
java.sql.PreparedStatement是预处理语句接口,具体信息如表1所示。
| 方法名 | 返回值类型 | 支持JDBC4 |
|---|---|---|
| addBatch() | VOID | Yes |
| executeBatch() | INT[] | Yes |
| clearParameters() | VOID | Yes |
| execute() | BOOLEAN | Yes |
| executeQuery() | RESULTSET | Yes |
| executeUpdate() | INT | Yes |
| executeLargeUpdate() | LONG | Yes |
| getMetaData() | RESULTSETMETADATA | No |
| getParameterMetaData() | PARAMETERMETADATA | Yes |
| setArray(int parameterIndex, Array x) | VOID | Yes |
| setAsciiStream(int parameterIndex, InputStream x, int length) | VOID | Yes |
| setBinaryStream(int parameterIndex, InputStream x) | VOID | Yes |
| setBinaryStream(int parameterIndex, InputStream x, int length) | VOID | Yes |
| setBinaryStream(int parameterIndex, InputStream x, long length) | VOID | Yes |
| setBlob(int parameterIndex, InputStream inputStream) | VOID | Yes |
| setBlob(int parameterIndex, InputStream inputStream, long length) | VOID | Yes |
| setBlob(int parameterIndex, Blob x) | VOID | Yes |
| setCharacterStream(int parameterIndex, Reader reader) | VOID | Yes |
| setCharacterStream(int parameterIndex, Reader reader, int length) | VOID | Yes |
| setClob(int parameterIndex, Reader reader) | VOID | Yes |
| setClob(int parameterIndex, Reader reader, long length) | VOID | Yes |
| setClob(int parameterIndex, Clob x) | VOID | Yes |
| setDate(int parameterIndex, Date x, Calendar cal) | VOID | Yes |
| setNull(int parameterIndex, int sqlType) | VOID | Yes |
| setNull(int parameterIndex, int sqlType, String typeName) | VOID | Yes |
| setObject(int parameterIndex, Object x) | VOID | Yes |
| setObject(int parameterIndex, Object x, int targetSqlType) | VOID | Yes |
| setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) | VOID | Yes |
| setSQLXML(int parameterIndex, SQLXML xmlObject) | VOID | Yes |
| setTime(int parameterIndex, Time x) | VOID | Yes |
| setTime(int parameterIndex, Time x, Calendar cal) | VOID | Yes |
| setTimestamp(int parameterIndex, Timestamp x) | VOID | Yes |
| setTimestamp(int parameterIndex, Timestamp x, Calendar cal) | VOID | Yes |
| setUnicodeStream(int parameterIndex, InputStream x, int length) | VOID | Yes |
| setURL(int parameterIndex, URL x) | VOID | Yes |
| setBoolean(int parameterIndex, boolean x) | VOID | Yes |
| setBigDecimal(int parameterIndex, BigDecimal x) | VOID | Yes |
| setByte(int parameterIndex, byte x) | VOID | Yes |
| setBytes(int parameterIndex, byte[] x) | VOID | Yes |
| setDate(int parameterIndex, Date x) | VOID | Yes |
| setDouble(int parameterIndex, double x) | VOID | Yes |
| setFloat(int parameterIndex, float x) | VOID | Yes |
| setInt(int parameterIndex, int x) | VOID | Yes |
| setLong(int parameterIndex, long x) | VOID | Yes |
| setShort(int parameterIndex, short x) | VOID | Yes |
| setString(int parameterIndex, String x) | VOID | Yes |
| setNString(int parameterIndex, String x) | VOID | Yes |
| addBatch() | VOID | Yes |
| executeBatch() | INT[] | Yes |
setBinaryStream()方法需要为GUC参数m_format_behavior_compat_options设置enable_escape_string选项,避免因无法识别转义字符而出现异常。