Download List

Project Description

Admin is entirely written in Java. It uses Swing GUI Components and JDBC to connect to databases. It has been succesfully tested with MySQL, Derby, InstantDB, Oracle, Empress, MS SQL Server, and PostgreSQL. You can have a tree view of the RDBMS or pick a single instance to have a look at its metadata. It allows you to create, modify, and drop tables and to create indices on a table. The dynamic form makes it easy to enter data into a certain table, and the guided query makes it easy to retrieve data from a table and to export it. Java developers will probably enjoy the code generator doing an OO relational wrapper and a swing GUI for them. There is a tool with which SQL statements can be enriched with a few commands, generating a GUI to easily select data from a DB. You can also export and import data and transport it from one DBMS to another.
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.

2010-12-06 02:06
2.4.3 2010-12-05

This version has a new utility to import XML data files into an RDBMS table. The checkbox panels from data drilling now have a toggle button to select or unselect everything with one click. Some tests were done with Apache Derby and support was added for Derby for table creation.
Tags: Minor feature enhancements

2007-11-11 15:30
2.4.2

This version has a new tool, called Data
Selection. This tool was initially developed to
allow complex data selections for users not
knowing much about RDBMS and Joins and other such
complicated things in the world of databases. This
tool has been in production for three years.
SQLAdmin can now also be launched via Java
Webstart.
Tags: Major feature enhancements

2004-10-08 17:11
2.4.0

This release adds a new CreateTable-GUI which allows you to create the
table within a grid. It supports additional parameters not available in
the "old" Version; you can set default values, check-constraints, and
foreign-key-relationships. There is an editor that allows you to select
the referencing column by simply clicking it. SQL-Monitor now allows the
use of "desc". Bugs have been fixed.
Tags: Major feature enhancements

2003-08-17 11:55
2.3.1

This version features a better data export utility, it is
faster, and supports CSV, XLS, and XML format. If the
underlying RDBMS is MySQL there is an additional menu
to display a dashboard.
Tags: Minor feature enhancements

2003-05-18 10:36
2.3

The generated code now has an additional constructor
to save connections to the DBMS. This new constructor
allows giving an existing connection over. Getting the
next() row also now reuses the existing connection. The
code generator has two additional buttons that allows
developers to compile and run the generated code.
Tags: Minor feature enhancements

Project Resources