java.sql.Statement
java.sql.Statement is an SQL statement API. For details, see Table 1.
|
Method Name |
Return Type |
JDBC4 Supported or Not |
|---|---|---|
|
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot