java.sql.PreparedStatement
java.sql.PreparedStatement是预处理语句接口。
| 方法名 | 返回值类型 | 支持JDBC 4 |
|---|---|---|
| executeQuery() | ResultSet | Yes |
| executeUpdate() | int | Yes |
| executeLargeUpdate() | long | Yes |
| execute() | boolean | Yes |
| addBatch() | void | Yes |
| clearParameters() | void | Yes |
| setNull(int, int) | void | Yes |
| setNull(int, int, String) | void | Yes |
| setBoolean(int, boolean) | void | Yes |
| setByte(int, byte) | void | Yes |
| setShort(int, short) | void | Yes |
| setInt(int, int) | void | Yes |
| setLong(int, long) | void | Yes |
| setFloat(int, float) | void | Yes |
| setDouble(int, double) | void | Yes |
| setBigDecimal(int, BigDecimal) | void | Yes |
| setString(int, String) | void | Yes |
| setDate(int, Date) | void | Yes |
| setTime(int, Time) | void | Yes |
| setTimestamp(int, Timestamp) | void | Yes |
| setAsciiStream(int, InputStream, int) | void | Yes |
| setUnicodeStream(int, InputStream, int) | void | Yes |
| setBytes(int, byte[]) | void | No |
| setBinaryStream(int, InputStream, int) | void | No |
| setObject(int, Object) | void | Yes |
| setObject(int, Object, int) | void | No |
| setObject(int, Object, int, int) | void | No |
| setCharacterStream(int, Reader, int) | void | Yes |
| setRef(int, Ref) | void | No |
| setBlob(int, Blob) | void | No |
| setClob(int, Clob) | void | Yes |
| setClob(int, Reader, long) | void | Yes |
| setClob(int, Reader) | void | Yes |
| setArray(int, Array) | void | Yes |
| getMetaData() | ResultSetMetaData | Yes |
| setDate(int, Date, Calendar) | void | Yes |
| setTime(int, Time, Calendar) | void | Yes |
| setTimestamp(int, Timestamp, Calendar) | void | Yes |
| setURL(int, URL) | void | No |
| getParameterMetaData() | ParameterMetaData | No |
| setRowId(int, RowId) | void | No |
| setNString(int, String) | void | No |
| setNCharacterStream(int, Reader, long) | void | No |
| setNCharacterStream(int, Reader) | void | No |
| setNClob(int, NClob) | void | No |
| setNClob(int, Reader, long) | void | No |
| setNClob(int, Reader) | void | No |
| setSQLXML(int, SQLXML) | void | Yes |
| setAsciiStream(int, InputStream, long) | void | No |
| setAsciiStream(int, InputStream) | void | No |
| setBinaryStream(int, InputStream, long) | void | No |
| setBinaryStream(int, InputStream) | void | No |
| setCharacterStream(int, Reader, long) | void | No |
| setCharacterStream(int, Reader) | void | No |
| setBlob(int, InputStream, long) | void | No |
| setBlob(int, InputStream) | void | No |
- addBatch()、execute()必须在clearBatch()之后才能执行。
- 调用executeBatch()方法并不会清除batch。用户必须显式使用clearBatch()清除 。
- 在添加了一个batch的绑定变量后,用户如果想重用这些值(再次添加一个batch),无需再次使用set*()方法 。
- 以下方法是从java.sql.Statement继承而来:close,execute,executeQuery,executeUpdate,getConnection,getResultSet,getUpdateCount,isClosed,setMaxRows, setFetchSize。