java.sql.Statement
java.sql.Statement是SQL语句接口，具体信息如表1所示。
| 方法名 | 返回值类型 | 支持JDBC4 |
|---|---|---|
| addBatch(String sql) | VOID | Yes |
| clearBatch() | VOID | Yes |
| clearWarnings() | VOID | Yes |
| close() | VOID | Yes |
| closeOnCompletion() | VOID | Yes |
| execute(String sql) | BOOLEAN | Yes |
| execute(String sql, int autoGeneratedKeys) | BOOLEAN | Yes |
| execute(String sql, int[] columnIndexes) | BOOLEAN | Yes |
| execute(String sql, String[] columnNames) | BOOLEAN | Yes |
| executeBatch() | BOOLEAN | Yes |
| executeQuery(String sql) | RESULTSET | Yes |
| executeUpdate(String sql) | INT | Yes |
| executeUpdate(String sql, int autoGeneratedKeys) | INT | Yes |
| executeUpdate(String sql, int[] columnIndexes) | INT | Yes |
| executeUpdate(String sql, String[] columnNames) | INT | Yes |
| getConnection() | CONNECTION | Yes |
| getFetchDirection() | INT | Yes |
| getFetchSize() | INT | Yes |
| getGeneratedKeys() | RESULTSET | No |
| getMaxFieldSize() | INT | Yes |
| getMaxRows() | INT | Yes |
| getMoreResults() | BOOLEAN | No |
| getMoreResults(int current) | BOOLEAN | No |
| getResultSet() | RESULTSET | Yes |
| getResultSetConcurrency() | INT | Yes |
| getResultSetHoldability() | INT | Yes |
| getResultSetType() | INT | Yes |
| getQueryTimeout() | INT | Yes |
| getUpdateCount() | INT | Yes |
| getWarnings() | SQLWARNING | No |
| isClosed() | BOOLEAN | Yes |
| isCloseOnCompletion() | BOOLEAN | Yes |
| isPoolable() | BOOLEAN | Yes |
| setCursorName(String name) | VOID | Yes |
| setEscapeProcessing(boolean enable) | VOID | Yes |
| setFetchDirection(int direction) | VOID | Yes |
| setMaxFieldSize(int max) | VOID | No |
| setMaxRows(int max) | VOID | No |
| setPoolable(boolean poolable) | VOID | Yes |
| setQueryTimeout(int seconds) | VOID | Yes |
| setFetchSize(int rows) | VOID | Yes |
| cancel() | VOID | No |
| executeLargeUpdate(String sql) | LONG | Yes |
| getLargeUpdateCount() | LONG | Yes |
| executeLargeBatch() | LONG | Yes |
| executeLargeUpdate(String sql, int autoGeneratedKeys) | LONG | Yes |
| executeLargeUpdate(String sql, int[] columnIndexes) | LONG | Yes |
| executeLargeUpdate(String sql, String[] columnNames) | LONG | Yes |
