DataBrowser

2010年9月26日 (日) 10:21的最后版本

[编辑] 简介

DataBrowser是基于Java的工具，可以浏览任何数据库,可以执行SQL 语句，输入输出数据以及在表单中查看查询结果。

The DataBrowser is a cross-database, cross-platform data access tool written entirely in Java. It is stable, feature rich, and mature (initially released in 1999).

[编辑] 功能特性

100% Java, compatible with Java 2 versions 1.4 and 1.5.
Connectivity

Connect to ANY database with a JDBC driver. (user must supply JDBC compliant drivers)
Connectors included for ODBC, Oracle, DB2, PostgreSQL, MS SQL Server, MySQL, InstantDB,
Generic connector will work with literally any driver
Maintains a list of recent connections, so you don't have to constantly re-type connection information.

Browsing

Browse a database's tables and view schemas in an intuitive treeview
Limit your browsing to a particular catalog, schema, or type
Right click to view typical data in a given table
Open multiple browser windows connected to various different databases. You can browse Oracle, Access, SQLServer and DB2 all at the same time.

Editing

Syntax-highlighting sql editor.
Add data to tables with a GUI interface.
Update data in tables.

Dynamic SQL Support

Execute any SQL statement
Save complex SQL with a "SQL Bookmark" for later use.

Easy to use interface allows less technical users to browse enterprise databases. Much easier to use than SQL Plus, DB Access, while at the same time more lightweight than MS Access.
Use in the course of software development to develop queries, then simply copy and paste your query into your code.

[编辑] 相关链接

官方网站

[编辑] 精彩图集

@@ 第1行： / 第1行： @@
+{{top news}}
 ==简介==
 DataBrowser是基于Java的工具，可以浏览任何数据库,可以执行SQL 语句，输入输出数据以及在表单中查看查询结果。
 The DataBrowser is a cross-database, cross-platform data access tool written entirely in Java. It is stable, feature rich, and mature (initially released in 1999).
 ==功能特性==
@@ 第32行： / 第33行： @@
 ==相关链接==
-*官方网站 http://jmatrix.net/content/databrowser_home.jsp
+*[http://jmatrix.net/content/databrowser_home.jsp 官方网站]
 ==精彩图集==
-[[image:databrowser.png|thumb|left|A list of recent connections is maintained on the database menu for quick connections]]
+<gallery perrow=5>
+image:databrowser.png
-[[image:databrowser_results.png|thumb|left|Query results are displayed in tabular format]]
+image:databrowser_results.png
+image:databrowser_insert.png
-[[image:databrowser_insert.png|thumb|left|For most databases, the DataBrowser is able to insert data into table... Right clicking on a table item in the treeview, or on data in a result set will bring up the add data dialog shown at the right.]]
+image:databrowser_edit.png
+image:databrowser_table.png
-[[image:databrowser_edit.png|thumb|left|The DataBrowser can also modify existing records.]]
+</gallery>
-[[image:databrowser_table.png|thumb|left|The TableEditor functionality helps with the creation of new tables. The Table Editor is shown below.]]
 [[Category:Database]]
 [[Category:Java]]