JDBC SQL客户端工具的建议 [英] Recommendation for JDBC SQL client tool

问题描述

有人可以推荐一个好的，开源的，独立的开发人员工具，用于使用JDBC查询SQL数据库并将结果导出到文件中吗？我知道很多数据库供应商都提供自己的工具，但是我需要一个允许我插入自己的自定义JDBC驱动程序并对任何数据库工作的工具。 GUI是首选，但不是必需的。

Can someone recommend a good, open source, standalone developer tool for querying SQL databases using JDBC and exporting the results to a file? I know a lot of database vendors provide their own tools, but I need one that will allow me to plug in my own custom JDBC driver and work against any database. A GUI is preferable, but not required.

Oracle的SQL Developer被取消资格，因为它似乎只适用于预先设定的一组JDBC驱动程序。我还查看了Java-Source.net上的工具列表，但是我希望有人可以帮助我根据个人经验缩小列表范围。它需要是独立的，因此非开发人员也可以使用它，这会使Eclipse插件失去资格。谢谢！

Oracle's SQL Developer is disqualified because it seems to work only with a pre-canned set of JDBC drivers. I have also looked at the list of tools at Java-Source.net, but I'm hoping someone can help me narrow down the list based on personal experience. And it needs to be standalone so non-developers can use it, too, which disqualifies Eclipse plug-ins. Thanks!

推荐答案

我使用 SQuirreL SQL ，我很高兴。我正在粘贴下面的概述：

I use SQuirreL SQL and I'm pretty happy with it. I'm pasting the "Overview" below:

SQuirreL SQL Client是一个图形化的
Java程序，可以让你获得
查看符合JDBC的
数据库的结构，浏览表中的数据，
发出SQL命令等，参见
简介。从SQuirreL
3.0版起，支持的
Java的最低版本是1.6.x.有关SQuirreL的版本，请参阅旧版本页面

适用于旧版本的Java。

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Introduction. The minimum version of Java supported is 1.6.x as of SQuirreL version 3.0. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.

SQuirreL的功能可以通过使用 sql.sourceforge.net/index.php?page=plugins\"rel =noreferrer>插件。

SQuirreL's functionality can be extended through the use of plugins.

可以找到一个简短的介绍
此处。要查看更改历史记录
（包括尚未发布的更改）
请单击这里。

A short introduction can be found here. To see the change history (including changes not yet released) click here.

有关更详细的介绍，请参阅
英语或德语我们关于
SQuirreL的论文。

For a more detailed introduction see the English or German of our paper on SQuirreL.

Susan Cline慷慨地花时间
来记录步骤她跟随
从
scratch设置Apache Derby数据库并使用SQuirreL SQL
客户探索它。

Susan Cline graciously took the time to document the steps she followed to setup an Apache Derby database from scratch and use the SQuirreL SQL Client to explore it.

很久以前Kulvir Singh
Bhogal写了一篇很棒的上的.com / developerworks / db2 / library / techarticle / dm-0312bhogal / index.htmlrel =noreferrer>教程 SQuirreL并在IBM
developerWorks站点上发布。他慷慨地给我们b $ b允许我们在本地镜像它。
教程并不是真正的最新版本，但是b $ b特别是为了完成第一步
它仍然有帮助。

Quite some time ago Kulvir Singh Bhogal wrote a great tutorial on SQuirreL and published it at the IBM developerWorks site. He has kindly allowed us to mirror it locally. The tutorial is not really up to date but especially for doing the first steps it is still of help.

SQuirrel是最初以
的形式发布GNU通用公共许可证。由于
版本1.1beta2，它已根据GNU较小的通用公共
许可证发行
。

SQuirrel was originally released under the GNU General Public License. Since version 1.1beta2 it has been released under the GNU Lesser General Public License.

它可能不是最漂亮的应用程序，但它可以完成它的工作，而且速度非常快：添加或配置驱动程序，创建别名，然后就可以了。实际上，它是我最喜欢的通用SQL客户端。

It's maybe not the most nice looking application but it does its job, and pretty fast: add or configure your driver, create an alias, and there you go. Actually, it's my favorite Universal SQL Client.

这篇关于JDBC SQL客户端工具的建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！