# java.sql.Connection
java.sql.Connection是数据库连接接口。
表1对java.sql.Connection接口的支持情况 
| 方法名 | 返回值类型 | 支持JDBC 4 |
|:---|:---|:---|
| createStatement()                                  | Statement                                            | Yes                                                     |
| createStatement(int, int)                           | Statement                                             | Yes                                                        |
| createStatement(int, int, int)                       | Statement                                             | Yes                                                     |
| prepareStatement(String)                             | PreparedStatement                                      | Yes                                                        |
| prepareStatement(String, int, int)                  | PreparedStatement                                    | Yes                                                      |
| prepareStatement(String, int, int, int)             | PreparedStatement                                     | Yes                                                      |
| prepareStatement(String, int autoGeneratedKeys)     | PreparedStatement                                     | No                                                       |
| prepareStatement(String, int\[\])                   | PreparedStatement                                      | No                                                       |
| prepareStatement(String, String\[\])               | PreparedStatement                                    | No                                                       |
| prepareCall(String)                                   | CallableStatement                                    | Yes                                                      |
| prepareCall(String, int, int)                       | CallableStatement                                    | Yes                                                      |
| prepareCall(String, int, int, int)                  | CallableStatement                                      | Yes                                                     |
| nativeSQL(String)                                  | String                                                | Yes                                                     |
| setAutoCommit(boolean)                             | void                                                  | Yes                                                       |
| getAutoCommit()                                    | boolean                                               | Yes                                                     |
| commit()                                            | void                                                | Yes                                                       |
| rollback()                                          | void                                                 | Yes                                                      |
| rollback(Savepoint)                                | void                                                  | Yes                                                     |
| close()                                              | void                                                | Yes                                                       |
| isClosed()                                          | boolean                                              | Yes                                                       |
| getMetaData()                                        | DatabaseMetaData                                     | Yes                                                      |
| setReadOnly(boolean)                                 | void                                                   | Yes                                                      |
| isReadOnly()                                         | boolean                                              | Yes                                                      |
| setCatalog(String)                                 | void                                                  | Yes                                                      |
| getCatalog()                                       | String                                                | Yes                                                      |
| setTransactionIsolation(int)                         | void                                                 | Yes                                                     |
| getTransactionIsolation()                            | int                                                    | Yes                                                      |
| getWarnings()                                       | SQLWarning                                             | Yes                                                    |
| clearWarnings()                                     | void                                                   | Yes                                                       |
| setSavepoint()                                      | Savepoint                                              | Yes                                                      |
| setSavepoint(String)                                | Savepoint                                              | Yes                                                      |
| releaseSavepoint(Savepoint)                          | void                                                  | Yes                                                     |
| createClob()                                       | Clob                                                 | Yes                                                     |
| createBlob()                                          | Blob                                                  | Yes                                                       |
| createNClob()                                       | NClob                                                  | No                                                      |
| createSQLXML()                                     | SQLXML                                              | No                                                        |
| createArrayOf(String, Object\[\])                   | Array                                                | No                                                      |
| createStruct(String, Object\[\])                      | Struct                                              | No                                                      |
| isValid(int)                                        | boolean                                                | Yes                                                       |
| setClientInfo(String, String)                      | void                                                | Yes                                                      |
| setClientInfo(Properties)                           | void                                                   | Yes                                                     |
| getClientInfo(String)                                | String                                                 | Yes                                                     |
| getClientInfo()                                    | Properties                                             | No                                                        |
| setSchema(String)                                   | void                                                   | Yes                                                      |
| getSchema()                                         | String                                                 | Yes                                                        |
| abort(Executor)                                    | void                                                    | Yes                                                      |
| setNetworkTimeout(Executor, int)                    | void                                                 | No                                                       |
| getNetworkTimeout()                                | int                                                  | Yes                                                     |
| setHoldability(int)                                  | void                                                   | Yes                                                      |
| getHoldability()                                  | int                                                   | Yes                                                       |
| getTypeMap()                                       | Map\<String, Class\>                                 | Yes                                                       |
| setTypeMap(Map)                                     | void                                                  | Yes                                                     |
   
