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 |
Yes |
|
getMaxFieldSize() |
INT |
Yes |
|
getMaxRows() |
INT |
Yes |
|
getMoreResults() |
BOOLEAN |
Yes |
|
getMoreResults(int current) |
BOOLEAN |
Yes |
|
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 |
