blocks|key|3120857|text|要获得更好的演练，请访问this+Java+World+tutorial。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3120858|基本上你需要创建4个类：|3120859|3120860|Driver|unordered-list-item|3120861|Connection|3120862|Statement|3120863|ResultSet|3120864|3120865|但正如您将在该教程中看到的，事情并没有那么简单。|3120866|entityMap|0|LINK|mutability|MUTABLE|url|https://www.javaworld.com/article/2074249/data-storage/create-your-own-type-3-jdbc-driver--part-1.html^0|C|O|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|15|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|16|8|@]|9|@]|C|$]]|$1|J|3|K|5|I|7|17|8|@]|9|@]|C|$]]|$1|L|3|M|5|I|7|18|8|@]|9|@]|C|$]]|$1|N|3|O|5|I|7|19|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1C|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]]]

For a good walk-through, please see <a href="https://www.javaworld.com/article/2074249/data-storage/create-your-own-type-3-jdbc-driver--part-1.html" rel="noreferrer">this Java World tutorial</a>.

Basically you need to create 4 classes:

<ul>
<li>Driver</li>
<li>Connection</li>
<li>Statement</li>
<li>ResultSet</li>
</ul>

But as you will see in that tutorial, it's not that simple.

blocks|key|2175079|text|我也遇到过类似的情况。如果能看到一个极简主义的例子就好了，但我也没有找到。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2175080|我的经验是，考虑到任何API，研究现有的“类引用”实现都是非常有用的。以JDBC为例，H2就是一个很好的例子。|offset|length|2175081|要实现的主要接口是java.sql.Driver。这就是H2实现它的方式：|style|CODE|2175082|https://github.com/h2database/h2database/+.+.+.+/Driver.java|2175083|在这个包中还有其他类：|2175084|https://github.com/h2database/h2database/+.+.+.+/jdbc|2175085|H2是一个成熟而复杂的软件，但其代码仍然是可读和可学习的。|2175086|entityMap|0|LINK|mutability|MUTABLE|url|http://h2database.com/html/main.html|1|https://github.com/h2database/h2database/blob/master/h2/src/main/org/h2/Driver.java|2|https://github.com/h2database/h2database/tree/master/h2/src/main/org/h2/jdbc^0|0|17|2|0|0|9|F|0|0|1O|1|0|0|0|1H|2|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@$D|15|E|16|1|17]]|A|$]]|$1|F|3|G|5|6|7|18|8|@$D|19|E|1A|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1B|8|@]|9|@$D|1C|E|1D|1|1E]]|A|$]]|$1|L|3|M|5|6|7|1F|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1G|8|@]|9|@$D|1H|E|1I|1|1J]]|A|$]]|$1|P|3|Q|5|6|7|1K|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]|Z|$5|U|V|W|A|$X|10]]|11|$5|U|V|W|A|$X|12]]]]

I was in a similar situation. It would be nice to see a minimalistic example, but I didn't find one either.

My experience is, that, thinking of any API, it's extremely useful to study existing "reference-like" implementations. In the case of JDBC, <a href="http://h2database.com/html/main.html" rel="noreferrer">H2</a> is a good example to study.

The main interface to implement is <code>java.sql.Driver</code>. That's how H2 implements it:

<a href="https://github.com/h2database/h2database/blob/master/h2/src/main/org/h2/Driver.java" rel="noreferrer">https://github.com/h2database/h2database/ . . . /Driver.java</a>

And in this package are the other classes:

<a href="https://github.com/h2database/h2database/tree/master/h2/src/main/org/h2/jdbc" rel="noreferrer">https://github.com/h2database/h2database/ . . . /jdbc</a>

H2 is a mature and complex piece of software, but the code is still readable and studyable.

blocks|key|5233575|text|是的，我已经编写了自定义驱动程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5233576|您的想法是正确的，但是在java.sql包中实现interfaces。研究API文档以了解每种方法的用途，以便以有意义的方式实现它。|offset|length|style|CODE|5233577|从您的简单驱动程序不支持的任何方法抛出UnsupportedOperationException。|5233578|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javase/7/docs/api/java/sql/package-summary.html|1|http://docs.oracle.com/javase/7/docs/api/java/lang/UnsupportedOperationException.html^0|0|C|8|O|A|C|8|0|0|J|T|J|T|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]|$D|X|E|Y|F|G]]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|H|3|I|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@$D|15|E|16|1|17]]|A|$]]|$1|J|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]]]

Yes, I've written custom drivers.

You have the right idea, but implement the <code>interfaces</code> in the <a href="http://docs.oracle.com/javase/7/docs/api/java/sql/package-summary.html" rel="nofollow"><code>java.sql</code></a> package. Study the API documentation to learn the purpose for each method so you can implement it in a meaningful way.

Throw <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/UnsupportedOperationException.html" rel="nofollow"><code>UnsupportedOperationException</code></a> from any methods your simple driver doesn't support.

blocks|key|2175103|text|我写了一个"csv-jdbc-driver“只是为了好玩。它远不是产品质量代码，我的目标只是演示(我自己)如何编写jdbc驱动程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2175104|以下是我的经验：|2175105|2175106|正如其他人所写的，它足以从java.sql实现4个接口:+Driver，Statement，Connection，ResultSet。|unordered-list-item|2175107|2175108|2175109|要知道，哪个方法应该用“真正的代码”来实现，我必须知道，我想如何使用csv驱动程序。这是我的示例代码：|2175110|2175111|try+(+Connection+conn+=+DriverManager.getConnection("jdbc:csv:/home/peter/csvdir")；语句stmt+=+conn.createStatement()；ResultSet+rs+=+stmt.executeQuery("SELECT+*+FROM+test.csv")+){+while+(rs.next())+System.out.println(rs.getString(1)+%2B“-”%2B+rs.getString(2))；}|2175112|我给DriverManager.getConnection提供了一个jdbc+url。在url中，我必须指定不同的csv文件所在的目录。DriverManager+getConnection方法调用Driver.connect(url，info)。这个connect方法应该检查jdbc+url，并决定它是否可以处理这个url。如果是，则返回一个Connection对象；如果不是，则返回null。|2175113|在stms.executeQuery中，我必须提供一个SQL+select，其中“表名”是csv文件的名称。我不想实现sql解析器，所以这个jdbc驱动程序只考虑表名。|2175114|我还必须至少使用ResultSet.next()和ResultSet.getString(int)方法。|2175115|所以我要实现的是：|2175116|2175117|Driver.connect(String，属性)。因为此方法返回一个Connection+class|2175118|Connection+constructor|2175119|Connection.createStatement方法。因为这将返回一条语句class|2175120|Statement+constructor|2175121|Statement.executeQuery.因为这将返回一个ResultSet+class|2175122|ResultSet+constructor|2175123|ResultSet.getString(int)|2175124|ResultSet.next()|2175125|2175126|我还使用org.example.CsvDriver+(我的驱动程序实现类名)的内容在src/main/resources/MET-INF/services/java.sql.Driver中创建了一个服务提供者文件。|2175127|我想，这些就足够了，但还不够。我的驱动程序加载了，但DriverManager找不到它。|2175128|我还必须从驱动程序实现的静态初始化器调用DriverManager.registerDriver(+INSTANCE+)，其中INSTANCE是驱动程序实现的对象。在我看来，这似乎是多余的(因为我写了一个java服务来避免这种情况)。|2175129|以下是源码：|2175130|2175131|https://github.com/peterborkuti/csv-jdbc-driver|offset|length|2175132|https://github.com/peterborkuti/csv-jdbc-driver-example|2175133|2175134|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1B|0|0|0|1J|1|0|0^^$0|@$1|2|3|4|5|6|7|22|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|23|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|24|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|25|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|28|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|29|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|2A|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|2B|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|2C|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|2D|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|2E|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|2F|8|@]|9|@]|A|$]]|$1|X|3|Y|5|G|7|2G|8|@]|9|@]|A|$]]|$1|Z|3|10|5|G|7|2H|8|@]|9|@]|A|$]]|$1|11|3|12|5|G|7|2I|8|@]|9|@]|A|$]]|$1|13|3|14|5|G|7|2J|8|@]|9|@]|A|$]]|$1|15|3|16|5|G|7|2K|8|@]|9|@]|A|$]]|$1|17|3|18|5|G|7|2L|8|@]|9|@]|A|$]]|$1|19|3|1A|5|G|7|2M|8|@]|9|@]|A|$]]|$1|1B|3|1C|5|G|7|2N|8|@]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|2O|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|6|7|2P|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|6|7|2R|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|6|7|2S|8|@]|9|@]|A|$]]|$1|1M|3|-4|5|6|7|2T|8|@]|9|@]|A|$]]|$1|1N|3|1O|5|G|7|2U|8|@]|9|@$1P|2V|1Q|2W|1|2X]]|A|$]]|$1|1R|3|1S|5|G|7|2Y|8|@]|9|@$1P|2Z|1Q|30|1|31]]|A|$]]|$1|1T|3|-4|5|6|7|32|8|@]|9|@]|A|$]]|$1|1U|3|-4|5|6|7|33|8|@]|9|@]|A|$]]]|1V|$1W|$5|1X|1Y|1Z|A|$20|1O]]|21|$5|1X|1Y|1Z|A|$20|1S]]]]

I wrote a &quot;csv-jdbc-driver&quot; just for fun. It is far from production quality code, my goal was only to demonstrate (for myself) how to write a jdbc driver.
Here are my experiences:
<ul>
<li>As others wrote, it is enough for implementing 4 interfaces from java.sql: Driver, Statement, Connection, ResultSet.
</li>
<li>To know, which method should be implemented with &quot;real code&quot;, I have to know, how I want to use the csv driver. This is my example code:
<pre><code> try (
 Connection conn = DriverManager.getConnection(&quot;jdbc:csv:/home/peter/csvdir&quot;);
 Statement stmt = conn.createStatement();
 ResultSet rs = stmt.executeQuery(&quot;SELECT * FROM test.csv&quot;)
 ){
 while (rs.next()) System.out.println(rs.getString(1) + &quot; - &quot; + rs.getString(2));
 }
</code></pre>
</li>
</ul>
I give a jdbc url to DriverManager.getConnection. In the url I have to specify a directory, where different csv files are. The DriverManager getConnection method calls Driver.connect(url, info). This connect method should check the jdbc url and decides if it can deal with the url or not. If yes, it returns with a Connection object, if not, returns with null.
In the stms.executeQuery I have to give an SQL select, where the &quot;table name&quot; is the name of the csv file.
I do not want to implement an sql parser, so this jdbc driver takes into account only the table name.
I also have to use the ResultSet.next() and ResultSet.getString(int) methodes as a bare minimum.
So what I have to implement:
<ul>
<li>Driver.connect(String, Properties). Because this method returns with a Connection class</li>
<li>Connection constructor</li>
<li>Connection.createStatement method. Because this returns with a Statement class</li>
<li>Statement constructor</li>
<li>Statement.executeQuery. Because this returns with a ResultSet class</li>
<li>ResultSet constructor</li>
<li>ResultSet.getString(int)</li>
<li>ResultSet.next()</li>
</ul>
I also created a service provider file in src/main/resources/MET-INF/services/java.sql.Driver with the contents of org.example.CsvDriver (my Driver implementation class name)
I thought, that these would be enough, but not. My driver loaded, but the DriverManager did not find it.
I also had to call DriverManager.registerDriver(INSTANCE) from my Driver implementation's static initializer, where INSTANCE is an object from my Driver implementation. It seems to me superfluous (because I wrote a java service for avoiding this).
Here are the sources:
<ul>
<li><a href="https://github.com/peterborkuti/csv-jdbc-driver" rel="nofollow noreferrer">https://github.com/peterborkuti/csv-jdbc-driver</a></li>
<li><a href="https://github.com/peterborkuti/csv-jdbc-driver-example" rel="nofollow noreferrer">https://github.com/peterborkuti/csv-jdbc-driver-example</a></li>
</ul>

I have web service which I need to expose through JDBC due some BI tools software restrictions. 
Very limited support required few defined select queries. 
What I understand that I need to implement all the classes under the interface java.sql to achieve that. Has anyone done similar things? Do we have some custom implementations where we need to implement the bare minimum code.

Writing a custom jdbc driver in java a very basic one

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有web服务，我需要通过JDBC暴露由于一些BI工具软件的限制。非常有限的支持只需要很少的已定义select查询。我所理解的是，我需要实现接口java.sql下的所有类来实现这一点。有没有人做过类似的事情？我们有没有一些自定义的实现，我们需要实现最少的代码。

问用java编写自定义jdbc驱动程序非常简单。
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用java编写自定义jdbc驱动程序非常简单。EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用java编写自定义jdbc驱动程序非常简单。
EN