DataBrowser

2007年1月21日 (日) 17:03的版本

简介

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

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

• Browsing

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

• Editing

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

• Dynamic SQL Support

1. Execute any SQL statement
2. 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.

相关链接

• 官方网站 http://jmatrix.net/content/databrowser_home.jsp

精彩图集

A list of recent connections is maintained on the database menu for quick connections

Query results are displayed in tabular format

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.

The DataBrowser can also modify existing records.

The TableEditor functionality helps with the creation of new tables. The Table Editor is shown below.