Java JDBC SQL 客户端工具推荐
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1644893/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Recommendation for JDBC SQL client tool
提问by Rob H
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.
有人可以推荐一个好的、开源的、独立的开发工具来使用 JDBC 查询 SQL 数据库并将结果导出到文件吗？我知道很多数据库供应商都提供了他们自己的工具，但我需要一个允许我插入我自己的自定义 JDBC 驱动程序并针对任何数据库工作的工具。GUI 是可取的，但不是必需的。
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 toolsat 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!
Oracle 的 SQL Developer 被取消资格，因为它似乎只适用于预装的 JDBC 驱动程序集。我还查看了Java-Source.net 上的工具列表，但我希望有人可以根据个人经验帮助我缩小列表的范围。而且它需要是独立的，这样非开发人员也可以使用它，这使 Eclipse 插件失去资格。谢谢！
采纳答案by Pascal Thivent
I use SQuirreL SQLand I'm pretty happy with it. I'm pasting the "Overview" below:
我使用SQuirreL SQL，我对它非常满意。我正在粘贴下面的“概述”：
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 Versionspage for versions of SQuirreL that will work with older versions of Java.
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.
For a more detailed introduction see the Englishor Germanof our paper on SQuirreL.
Susan Cline graciously took the time to document the stepsshe followed to setup an Apache Derby database from scratch and use the SQuirreL SQL Client to explore it.
Quite some time ago Kulvir Singh Bhogal wrote a great tutorialon 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 was originally released under the GNU General Public License. Since version 1.1beta2 it has been released under the GNU Lesser General Public License.
SQuirreL SQL Client 是一个图形 Java 程序，它允许您查看符合 JDBC 的数据库的结构、浏览表中的数据、发出 SQL 命令等，请参阅 简介。自 SQuirreL 3.0 版起，所支持的 Java 最低版本为 1.6.x。请参阅旧版本页面，了解适用于旧版 Java 的 SQuirreL 版本。
SQuirreL 的功能可以通过使用插件进行扩展。
可以在此处找到简短介绍 。要查看更改历史记录（包括尚未发布的更改），请单击此处。
有关更详细的介绍，请参阅我们关于 SQuirreL 的论文的英文或德文。
Susan Cline 慷慨地花时间记录了她从头开始设置 Apache Derby 数据库并使用 SQuirreL SQL Client 探索它所遵循的步骤。
很久以前，Kulvir Singh Bhogal 写了一篇关于 SQuirreL的很棒的教程，并将其发布在 IBM developerWorks 站点上。他好心地允许我们在本地镜像它。该教程并不是真正最新的，但特别是对于第一步，它仍然有帮助。
SQuirrel 最初是在 GNU 通用公共许可证下发布的。从 1.1beta2 版本开始，它已在 GNU 宽松通用公共许可证下发布。
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.
它可能不是最漂亮的应用程序，但它可以完成它的工作，而且速度非常快：添加或配置您的驱动程序，创建一个别名，然后就可以了。实际上，它是我最喜欢的通用 SQL 客户端。
回答by matt b
I'd like to throw in a vote for DbVisualizer.
我想投给DbVisualizer一票。
回答by mecsco
I'd agree with Pascal about SQuirrel SQL, that does the job for almost everything.
我同意 Pascal 关于SQuirrel SQL 的观点，它几乎可以完成所有工作。
However if I remember rightly, its support for SQL triggers is lacking - it couldn't display the source code of the trigger, at least in the version I was using (3.0.2)
但是，如果我没记错的话，它缺乏对 SQL 触发器的支持 - 它无法显示触发器的源代码，至少在我使用的版本 (3.0.2) 中
For this scenario, I found the free (but not open-source) SQL Workbenchdoes the job, which in itself is a more than decent tool.
对于这种情况，我发现免费（但不是开源）SQL Workbench 可以完成这项工作，它本身就是一个不错的工具。
If I'm not working with triggers though, I'd recommend using SQuirrel SQL
如果我不使用触发器，我建议使用 SQuirrel SQL
