开发自己的jdbc驱动——基本说明

jdbc目前支持4种类型的驱动模式
参考如下图，我们需要开发的是type4 100%纯java代码的，以下只是简单的原型，实现一个比较完整的jdbc驱动，后续会逐步完成

 

 

 

项目结构

当前没有依赖任何三方包，对于包含了依赖的，对于驱动的如果使用maven项目推荐使用maven-shade-plugin 插件，尽管这样开发的驱动
比较大，但是可靠性以及稳定性比较好（减少依赖包冲突）

  • maven 项目结构
 
├── pom.xml
└── src
    ├── main
    │   ├── java
    │   │   └── com
    │   │       └── dalong
    │   │           └── jdbc
    │   │               ├── MyConnection.java
    │   │               ├── MyDatabaseMetaData.java
    │   │               └── MyDriver.java
    │   └── resources
    │       └── META-INF
    │           └── services
    │               └── java.sql.Driver
    └── test
        └── java
  • 简单说明
    resources/META-INF/services/java.sql.Driver 这个文件是jdbc驱动开发的一个约定（spi），内容很简单(指定我们驱动的完整类名就可以了)
 
com.dalong.jdbc.MyDriver

pom.xml 这个很简单，没有什么特殊的，后期开发其他依赖的时候可能就需要扩展了

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
​
    <groupId>com.dalong</groupId>
    <artifactId>myjdbc</artifactId>
    <version>1.0-SNAPSHOT</version>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <encoding>UTF-8</encoding>
        <java.version>1.8</java.version>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
    </properties>
</project>
 
 

MyDriver.java driver 接口的实现，一个通用的模式

package com.dalong.jdbc;
​
import java.io.Closeable;
import java.io.IOException;
import java.sql.*;
import java.util.Properties;
import java.util.logging.Logger;
​
/**
 @author dalong
 mydemo jdbc driver for http tet
 */
public class MyDriver  implements Driver, Closeable {
​
    static final String DRIVER_NAME = "my JDBC Driver";
    static final String DRIVER_VERSION;
    static final int DRIVER_VERSION_MAJOR;
    static final int DRIVER_VERSION_MINOR;
    private static final String DRIVER_URL_START = "jdbc:myapp:";
    static   {
        // 我们通过静态构造函数注册我们的驱动，如果了解golang 的sql 驱动的话，也是一样的，支持golang 基于了 init 函数进行驱动的注册
        try {
            DRIVER_VERSION_MAJOR= 3;
            DRIVER_VERSION_MINOR =1;
            DRIVER_VERSION = "1.0.0";
            MyDriver driver = new MyDriver();
            DriverManager.registerDriver(driver);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
    @Override
    public void close() throws IOException {
        // http connect demo
    }
​
    // implements connect   manage connect
    @Override
    public Connection connect(String url, Properties info) throws SQLException {
        // first check url is validate
        if (acceptsURL(url)){
            return  new MyConnection(url,info);
        }
        return null;
    }
​
    @Override
    public boolean acceptsURL(String url) throws SQLException {
       return url.startsWith(DRIVER_URL_START);
    }
​
    @Override
    public DriverPropertyInfo[] getPropertyInfo(String url, Properties info) throws SQLException {
        return new DriverPropertyInfo[0];
    }
​
    @Override
    public int getMajorVersion() {
        return DRIVER_VERSION_MAJOR;
    }
​
    @Override
    public int getMinorVersion() {
        return DRIVER_VERSION_MINOR;
    }
​
    @Override
    public boolean jdbcCompliant() {
        return false;
    }
​
    @Override
    public Logger getParentLogger() throws SQLFeatureNotSupportedException {
        return null;
    }
}

MyConnection.java 我们所有的操作都是基于connection 的,此代码比较简单，没有添加特殊的东西，主要是关于
DatabaseMetaData的返回（方便尝试的，后边继续完整）

 
package com.dalong.jdbc;
​
import java.sql.*;
import java.util.Map;
import java.util.Properties;
import java.util.concurrent.Executor;
​
/**
 @author dalong
 实现一个jdbc connection 包装 http 请求
*/
public class MyConnection implements Connection {
​
​
​
    // atomic operators
    MyConnection(String url,Properties properties) {
​
    }
    @Override
    public Statement createStatement() throws SQLException {
        return null;
    }
​
    @Override
    public PreparedStatement prepareStatement(String sql) throws SQLException {
        return null;
    }
​
    @Override
    public CallableStatement prepareCall(String sql) throws SQLException {
        return null;
    }
​
    @Override
    public String nativeSQL(String sql) throws SQLException {
        // 输出原始sql
        return sql;
    }
​
    //  事务支持
    @Override
    public void setAutoCommit(boolean autoCommit) throws SQLException {
​
    }
​
    @Override
    public boolean getAutoCommit() throws SQLException {
        return false;
    }
​
    @Override
    public void commit() throws SQLException {
​
    }
​
    @Override
    public void rollback() throws SQLException {
​
    }
​
    @Override
    public void close() throws SQLException {
​
    }
​
    @Override
    public boolean isClosed() throws SQLException {
        return false;
    }
​
  // 返回元数据信息，通过自己实现的MyDatabaseMetaData 完成部分
    @Override
    public DatabaseMetaData getMetaData() throws SQLException {
        // 可以通过约定获取
        return new MyDatabaseMetaData();
    }
​
    @Override
    public void setReadOnly(boolean readOnly) throws SQLException {
​
    }
​
    @Override
    public boolean isReadOnly() throws SQLException {
        return true;
    }
​
    @Override
    public void setCatalog(String catalog) throws SQLException {
​
    }
​
    @Override
    public String getCatalog() throws SQLException {
        return null;
    }
​
    @Override
    public void setTransactionIsolation(int level) throws SQLException {
​
    }
​
    @Override
    public int getTransactionIsolation() throws SQLException {
        return 0;
    }
​
    @Override
    public SQLWarning getWarnings() throws SQLException {
        return null;
    }
​
    @Override
    public void clearWarnings() throws SQLException {
​
    }
​
    @Override
    public Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException {
        return null;
    }
​
    @Override
    public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException {
        return null;
    }
​
    @Override
    public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException {
        return null;
    }
​
    @Override
    public Map<String, Class<?>> getTypeMap() throws SQLException {
        return null;
    }
​
    @Override
    public void setTypeMap(Map<String, Class<?>> map) throws SQLException {
​
    }
​
    @Override
    public void setHoldability(int holdability) throws SQLException {
​
    }
​
    @Override
    public int getHoldability() throws SQLException {
        return 0;
    }
​
    @Override
    public Savepoint setSavepoint() throws SQLException {
        return null;
    }
​
    @Override
    public Savepoint setSavepoint(String name) throws SQLException {
        return null;
    }
​
    @Override
    public void rollback(Savepoint savepoint) throws SQLException {
​
    }
​
    @Override
    public void releaseSavepoint(Savepoint savepoint) throws SQLException {
​
    }
​
    @Override
    public Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException {
        return null;
    }
​
    @Override
    public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException {
        return null;
    }
​
    @Override
    public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException {
        return null;
    }
​
    @Override
    public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException {
        return null;
    }
​
    @Override
    public PreparedStatement prepareStatement(String sql, int[] columnIndexes) throws SQLException {
        return null;
    }
​
    @Override
    public PreparedStatement prepareStatement(String sql, String[] columnNames) throws SQLException {
        return null;
    }
​
    @Override
    public Clob createClob() throws SQLException {
        return null;
    }
​
    @Override
    public Blob createBlob() throws SQLException {
        return null;
    }
​
    @Override
    public NClob createNClob() throws SQLException {
        return null;
    }
​
    @Override
    public SQLXML createSQLXML() throws SQLException {
        return null;
    }
​
    @Override
    public boolean isValid(int timeout) throws SQLException {
        return false;
    }
​
    @Override
    public void setClientInfo(String name, String value) throws SQLClientInfoException {
​
    }
​
    @Override
    public void setClientInfo(Properties properties) throws SQLClientInfoException {
​
    }
​
    @Override
    public String getClientInfo(String name) throws SQLException {
        return null;
    }
​
    @Override
    public Properties getClientInfo() throws SQLException {
        return null;
    }
​
    @Override
    public Array createArrayOf(String typeName, Object[] elements) throws SQLException {
        return null;
    }
​
    @Override
    public Struct createStruct(String typeName, Object[] attributes) throws SQLException {
        return null;
    }
​
    @Override
    public void setSchema(String schema) throws SQLException {
        throw new SQLFeatureNotSupportedException();
    }
​
    @Override
    public String getSchema() throws SQLException {
        throw new SQLFeatureNotSupportedException();
    }
​
    @Override
    public void abort(Executor executor) throws SQLException {
        throw new SQLFeatureNotSupportedException();
    }
​
    @Override
    public void setNetworkTimeout(Executor executor, int milliseconds) throws SQLException {
​
    }
​
    @Override
    public int getNetworkTimeout() throws SQLException {
        return 0;
    }
​
    @Override
    public <T> T unwrap(Class<T> iface) throws SQLException {
        return null;
    }
​
    @Override
    public boolean isWrapperFor(Class<?> iface) throws SQLException {
        return false;
    }
}

MyDatabaseMetaData.java 元数据暴露的,代码很简单，主要是提供了用户在连接的时候提示信息

package com.dalong.jdbc;
import java.sql.*;
​
/**
 * @author dalong
 */
public class MyDatabaseMetaData implements DatabaseMetaData {
    @Override
    public boolean allProceduresAreCallable() throws SQLException {
        return false;
    }
​
    @Override
    public boolean allTablesAreSelectable() throws SQLException {
        return false;
    }
​
    @Override
    public String getURL() throws SQLException {
        return null;
    }
​
    @Override
    public String getUserName() throws SQLException {
        return null;
    }
​
    @Override
    public boolean isReadOnly() throws SQLException {
        return false;
    }
​
    @Override
    public boolean nullsAreSortedHigh() throws SQLException {
        return false;
    }
​
    @Override
    public boolean nullsAreSortedLow() throws SQLException {
        return false;
    }
​
    @Override
    public boolean nullsAreSortedAtStart() throws SQLException {
        return false;
    }
​
    @Override
    public boolean nullsAreSortedAtEnd() throws SQLException {
        return false;
    }
​
    @Override
    public String getDatabaseProductName() throws SQLException {
        return "my server 1.0.0";
    }
​
    @Override
    public String getDatabaseProductVersion() throws SQLException {
        return "my server 1.0.0";
    }
​
    @Override
    public String getDriverName() throws SQLException {
        return "myjdbc for my server";
    }
​
    @Override
    public String getDriverVersion() throws SQLException {
        return "1.0.0";
    }
​
    @Override
    public int getDriverMajorVersion() {
        return MyDriver.DRIVER_VERSION_MAJOR;
    }
​
    @Override
    public int getDriverMinorVersion() {
        return MyDriver.DRIVER_VERSION_MINOR;
    }
​
    @Override
    public boolean usesLocalFiles() throws SQLException {
        return false;
    }
​
    @Override
    public boolean usesLocalFilePerTable() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsMixedCaseIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public boolean storesUpperCaseIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public boolean storesLowerCaseIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public boolean storesMixedCaseIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public boolean storesUpperCaseQuotedIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public boolean storesLowerCaseQuotedIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public boolean storesMixedCaseQuotedIdentifiers() throws SQLException {
        return false;
    }
​
    @Override
    public String getIdentifierQuoteString() throws SQLException {
        return null;
    }
​
    @Override
    public String getSQLKeywords() throws SQLException {
        return null;
    }
​
    @Override
    public String getNumericFunctions() throws SQLException {
        return null;
    }
​
    @Override
    public String getStringFunctions() throws SQLException {
        return null;
    }
​
    @Override
    public String getSystemFunctions() throws SQLException {
        return null;
    }
​
    @Override
    public String getTimeDateFunctions() throws SQLException {
        return null;
    }
​
    @Override
    public String getSearchStringEscape() throws SQLException {
        return null;
    }
​
    @Override
    public String getExtraNameCharacters() throws SQLException {
        return null;
    }
​
    @Override
    public boolean supportsAlterTableWithAddColumn() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsAlterTableWithDropColumn() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsColumnAliasing() throws SQLException {
        return false;
    }
​
    @Override
    public boolean nullPlusNonNullIsNull() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsConvert() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsConvert(int fromType, int toType) throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsTableCorrelationNames() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsDifferentTableCorrelationNames() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsExpressionsInOrderBy() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsOrderByUnrelated() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsGroupBy() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsGroupByUnrelated() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsGroupByBeyondSelect() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsLikeEscapeClause() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsMultipleResultSets() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsMultipleTransactions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsNonNullableColumns() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsMinimumSQLGrammar() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsCoreSQLGrammar() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsExtendedSQLGrammar() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsANSI92EntryLevelSQL() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsANSI92IntermediateSQL() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsANSI92FullSQL() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsIntegrityEnhancementFacility() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsOuterJoins() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsFullOuterJoins() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsLimitedOuterJoins() throws SQLException {
        return false;
    }
​
    @Override
    public String getSchemaTerm() throws SQLException {
        return null;
    }
​
    @Override
    public String getProcedureTerm() throws SQLException {
        return null;
    }
​
    @Override
    public String getCatalogTerm() throws SQLException {
        return null;
    }
​
    @Override
    public boolean isCatalogAtStart() throws SQLException {
        return false;
    }
​
    @Override
    public String getCatalogSeparator() throws SQLException {
        return null;
    }
​
    @Override
    public boolean supportsSchemasInDataManipulation() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSchemasInProcedureCalls() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSchemasInTableDefinitions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSchemasInIndexDefinitions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsCatalogsInDataManipulation() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsCatalogsInProcedureCalls() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsCatalogsInTableDefinitions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsCatalogsInIndexDefinitions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsPositionedDelete() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsPositionedUpdate() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSelectForUpdate() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsStoredProcedures() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSubqueriesInComparisons() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSubqueriesInExists() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSubqueriesInIns() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsSubqueriesInQuantifieds() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsCorrelatedSubqueries() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsUnion() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsUnionAll() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsOpenCursorsAcrossCommit() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsOpenCursorsAcrossRollback() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsOpenStatementsAcrossCommit() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsOpenStatementsAcrossRollback() throws SQLException {
        return false;
    }
​
    @Override
    public int getMaxBinaryLiteralLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxCharLiteralLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxColumnNameLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxColumnsInGroupBy() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxColumnsInIndex() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxColumnsInOrderBy() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxColumnsInSelect() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxColumnsInTable() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxConnections() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxCursorNameLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxIndexLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxSchemaNameLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxProcedureNameLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxCatalogNameLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxRowSize() throws SQLException {
        return 0;
    }
​
    @Override
    public boolean doesMaxRowSizeIncludeBlobs() throws SQLException {
        return false;
    }
​
    @Override
    public int getMaxStatementLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxStatements() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxTableNameLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxTablesInSelect() throws SQLException {
        return 0;
    }
​
    @Override
    public int getMaxUserNameLength() throws SQLException {
        return 0;
    }
​
    @Override
    public int getDefaultTransactionIsolation() throws SQLException {
        return 0;
    }
​
    @Override
    public boolean supportsTransactions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsTransactionIsolationLevel(int level) throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsDataManipulationTransactionsOnly() throws SQLException {
        return false;
    }
​
    @Override
    public boolean dataDefinitionCausesTransactionCommit() throws SQLException {
        return false;
    }
​
    @Override
    public boolean dataDefinitionIgnoredInTransactions() throws SQLException {
        return false;
    }
​
    @Override
    public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getSchemas() throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getCatalogs() throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getTableTypes() throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getTypeInfo() throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException {
        return null;
    }
​
    @Override
    public boolean supportsResultSetType(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException {
        return false;
    }
​
    @Override
    public boolean ownUpdatesAreVisible(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean ownDeletesAreVisible(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean ownInsertsAreVisible(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean othersUpdatesAreVisible(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean othersDeletesAreVisible(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean othersInsertsAreVisible(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean updatesAreDetected(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean deletesAreDetected(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean insertsAreDetected(int type) throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsBatchUpdates() throws SQLException {
        return false;
    }
​
    @Override
    public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException {
        return null;
    }
​
    @Override
    public Connection getConnection() throws SQLException {
        return null;
    }
​
    @Override
    public boolean supportsSavepoints() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsNamedParameters() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsMultipleOpenResults() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsGetGeneratedKeys() throws SQLException {
        return false;
    }
​
    @Override
    public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public boolean supportsResultSetHoldability(int holdability) throws SQLException {
        return false;
    }
​
    @Override
    public int getResultSetHoldability() throws SQLException {
        return 0;
    }
​
    @Override
    public int getDatabaseMajorVersion() throws SQLException {
        return 0;
    }
​
    @Override
    public int getDatabaseMinorVersion() throws SQLException {
        return 0;
    }
​
    @Override
    public int getJDBCMajorVersion() throws SQLException {
        return 0;
    }
​
    @Override
    public int getJDBCMinorVersion() throws SQLException {
        return 0;
    }
​
    @Override
    public int getSQLStateType() throws SQLException {
        return 0;
    }
​
    @Override
    public boolean locatorsUpdateCopy() throws SQLException {
        return false;
    }
​
    @Override
    public boolean supportsStatementPooling() throws SQLException {
        return false;
    }
​
    @Override
    public RowIdLifetime getRowIdLifetime() throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException {
        return null;
    }
​
    @Override
    public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException {
        return false;
    }
​
    @Override
    public boolean autoCommitFailureClosesAllResultSets() throws SQLException {
        return false;
    }
​
    @Override
    public ResultSet getClientInfoProperties() throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException {
        return null;
    }
​
    @Override
    public boolean generatedKeyAlwaysReturned() throws SQLException {
        return false;
    }
​
    @Override
    public <T> T unwrap(Class<T> iface) throws SQLException {
        return null;
    }
​
    @Override
    public boolean isWrapperFor(Class<?> iface) throws SQLException {
        return false;
    }
}

连接试用

很简单，我们基于dbeaver 配置我们自己开发的驱动进行连接

  • 构建jar包
mvn clean package
  • 添加新的dbeaver驱动配置

 

 


 

 

  • 使用自己的驱动进行连接测试

 

 

说明

以上代码很简单，主要是关于jdbc驱动开发的基本原型的说明，后边我们基于此开发一个http请求处理的jdbc驱动,如果经常看一些
开源项目的话，应该会发现开源项目的额jdbc驱动开发的模式也是按照这个套路的，有些是封装的底层协议，有些封装的是http协议

参考资料

https://github.com/prestodb/presto/tree/master/presto-jdbc
https://github.com/h2database/h2database/blob/master/h2/src/main/org/h2/Driver.java

posted on 2020-10-09 20:44  荣锋亮  阅读(2324)  评论(0)  编辑  收藏  举报

导航