# java.sql.PreparedStatement
java.sql.PreparedStatement是预处理语句接口。
表1对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                                                         |
   
![](https://support.huaweicloud.com/usermanual-aidatalake/public_sys-resources/note_3.0-zh-cn.png)
- addBatch()、execute()必须在clearBatch()之后才能执行。
- 调用executeBatch()方法并不会清除batch。用户必须显式使用clearBatch()清除 。
- 在添加了一个batch的绑定变量后，用户如果想重用这些值(再次添加一个batch)，无需再次使用set\*()方法 。
- 以下方法是从java.sql.Statement继承而来：close，execute，executeQuery，executeUpdate，getConnection，getResultSet，getUpdateCount，isClosed，setMaxRows, setFetchSize。
 
