#java.sql.Statement
Statement接口定义了向数据库发送SQL命令,以及从数据库获取结果集的方法与属性,通过Connection::createStatement方法创建。
YashanDB JDBC驱动对Statement接口已支持功能:
| 返回类型 | 方法 |
|---|---|
| ResultSet | executeQuery(String sql) |
| int | executeUpdate(String sql) |
| void | close() |
| void | setMaxFieldSize(int max) |
| int | getMaxFieldSize() |
| void | setMaxRows(int max) |
| int | getMaxRows() |
| boolean | execute(String sql) |
| void | addBatch( String sql ) |
| void | clearBatch() |
| int[] | executeBatch() |
| long[] | executeLargeBatch() |
| ResultSet | getResultSet() |
| ResultSet | getGeneratedKeys() |
| int | executeUpdate(String sql, int columnIndexes[]) |
| boolean | execute(String sql, int columnIndexes[]) |
| long | executeLargeUpdate(String sql, int columnIndexes[]); |
| int | executeUpdate(String sql, int autoGeneratedKeys) |
| boolean | execute(String sql, int autoGeneratedKeys) |
| long | executeLargeUpdate(String sql, int autoGeneratedKeys) |
| boolean | execute(String sql, String columnNames[]) |
| long | executeLargeUpdate(String sql, String columnNames[]) |
| int | executeUpdate(String sql, String columnNames[]) |
| int | getUpdateCount() |
| int | getResultSetConcurrency() |
| int | getResultSetType() |
| Connection | getConnection() |
| int | getResultSetHoldability() |
| boolean | isClosed() |
| void | setPoolable(boolean poolable) |
| boolean | isPoolable() |
| long | getLargeUpdateCount() throws SQLException |
| void | setLargeMaxRows(long max) throws SQLException |
| long | getLargeMaxRows() throws SQLException |
| long | executeLargeUpdate(String sql) throws SQLException |
| void | setFetchSize(int rows) |
| int | getFetchSize() |
| void | closeOnCompletion() |
| boolean | isCloseOnCompletion() |
| void | setQueryTimeout(int seconds) |
| int | getQueryTimeout() |
| void | cancel() |
| boolean | getMoreResults() |
| boolean | getMoreResults(int current) |
未支持功能:
| 返回类型 | 方法 |
|---|---|
| void | setFetchDirection(int direction) |
| int | getFetchDirection() |
| void | setCursorName(String name) |
| void | setEscapeProcessing(boolean enable) |
| SQLWarning | getWarnings() |
| void | clearWarnings() |

