Features - ThinkUI SQL Client

Features (Community Edition)

The following are the features in the latest version of the ThinkUI SQL Client. If you have a feature request or suggestion, please let us know.

Supported Platforms & Databases

Support for any Java™ 1.4 supported platform (tested on Windows® 2000/XP, Linux™ UBUNTU, and Mac OS® X)

Support for Oracle® Database, IBM® DB2®, Microsoft® SQL Server, PostgreSQL, IBM® Cloudscape™ / Apache Derby, MySQL®
(Using either JDBC 2.0 or JDBC 3.0)

Support for any database using JDBC 3.0 (except for SQL create table query generation)

Support for data import from flat file (Excel, CSV, and Tab delimited files supported)

Support for read only access to a database (to prevent accidental data modifications)

Support for logging output a file or console (with runtime control of logging levels for easier tracing & debugging)

Meta Data Browser, SQL Query, & Data Object Editor

Database meta data tree browser (schemas, tables, views, sequences, indices, constraints, triggers, procedures)

Table column meta data grid browser (column name, type, size, nullable, default etc.)

SQL query (auto generate SQL create, select, insert, update queries from table meta data)

Table data grid browser with multi column sort (any combination of ascending and descending)

Support for filtering schema and tables from various browsers (useful for databases like ORACLE where schemas are users)

Right-click menu support to zoom to related foreign key records and certain column values

Graphical user interface for data entry of all tables (object viewer with support for apply and copy as new)
(supports edit of table rows grid as well as selected row from arbitrary SQL query with a single table)

Object viewer automatically display parent-child data with picklist and zoom to related records support

Graphical user interface for executing stored procedures

Data model capture and customization (import from specified database or Java code into internal database)

List all related tables (performed recursively to find all dependent tables)

Support for saving SQL queries into a local repository for later reuse. The queries can be associated with a default DB connection to allow convenient execution using the SQL query viewer. The queries are grouped under a particular Project and is limited to 1024 characters.

Code Generation

Code generation of various artifacts using Velocity templates and database meta data

Meta data retrieved from database table, view, stored procedure, imported data model, and SQL query
(supports single table/view queries as well as multi table joins)

Code generation can be perform interactively via a graphical user interface or in batch using Apache Ant and custom tasks

Custom code generation commands can be developed (for batch code generation) - see developer tutorial for details.

Existing template files can be easily customized (Javadoc available for code generation API)

Generated code can be saved to file (with full package folder path) or copied to clipboard for easy copy & paste

Template parameter values are stored as user preferences for convenient and efficient code generation

Code Templates

SQL	Select Statement	Generates SELECT SQL query for all columns of the selected tables or views (with alias prefix)
	Insert Statement	Generates INSERT SQL query for all columns of the selected tables or views (with optional row data)
	Update Statement	Generates UPDATE SQL query for all columns of the selected tables or views (with optional row data and primary key where clause)
	Create Table Statement	Generates CREATE TABLE SQL query of the selected tables or views (for the targeted database)
Data Access (Data Object)	Data Object Class	Generates Java DataObject class(es) to encapsulates meta data of the selected tables or views (with optional get/set access methods)
	Composite Object Class	Generates Java CompositeObject class to encapsulates the related DataObject classes (e.g. from Foreign Key DB constraints) for the selected table or view
	Search Criteria Data Class	Generates Java SearchCriteriaData class to encapsulates the search parameters for the selected table or view
	Data Access Object Class	Generates Java DataAccessObject class for the selected table or view
Data Access (Java Bean)	Java Bean Class	Generates Java bean class for the selected table or view
	Java Bean Search Criteria Data Class	Generates Java bean SearchCriteriaData class to encapsulates the search parameters for the selected table or view
	Java Bean DAO Class	Generates Java bean DAO class for the selected table or view (for the targeted database). Generated code can be based on dynamically generated SQL queries or static SQL queries executed using JDBC PreparedStatements.
	Java Bean Copy Code	Generates Java bean copy code using the get/set access methods for the selected table or view
	Java Bean Stored Procedure	Generates Java bean code for executing a database stored procedure
Data Access (Hibernate)	Hibernate 2.0 Java Bean Class	Generates Java bean class(es) (for use with Hibernate 2.0) for the selected tables or views (with optional lifecycle stub methods)
	Hibernate 2.0 Mapping XML file	Generates Hibernate 2.0 Mapping XML file with support for relationships
	Hibernate 3.0 Java Bean Class	Generates Java bean class(es) (for use with Hibernate 3.0) for the selected tables or views (with optional lifecycle stub methods)
	Hibernate 3.0 Mapping XML file	Generates Hibernate 3.0 Mapping XML file with support for relationships
Business Logic	Business Object Class	Generates BusinessObject class for the specified project
	Business Proxy Class	Generates BusinessObject proxy class (Interface, Local, or EJB) for the specified project with various business methods for the selected tables or views
	Command Class	Generates Command class (Code Generator, Swing, Web, or Batch command) with parameters the same as the columns of the selected table or view
Web (Controller)	JSPScreen Class	Generates JSPScreen class (Search, View, or Select screen) for the selected table or view
	Session Manager Class	Generates WebSessionManager class for the specified project with various get/set access methods for the selected tables or views
	Permissions Class	Generates Permissions class for the specified project
	Show Search Screen Command Class	Generates ShowSearchScreenCommand class for the selected table or view
	Multi Selection Handler Class	Generates MultiSelectionHandler class for the selected table or view
	Search Command Class	Generates SearchCommand class for the selected table or view
	Show View Screen Command Class	Generates ShowViewScreenCommand class for the selected table or view
	New Command Class	Generates Command class to create a new object for the selected table or view
	Save Command Class	Generates SaveCommand class for the selected table or view
	Delete Command Class	Generates DeleteCommand class for the selected table or view
Web (View)	Search JSP File	Generates JSP file for searching for the selected table or view
	View JSP File	Generates JSP file for viewing an object for the selected table or view
	Select JSP File	Generates JSP file for selecting an object for the selected table or view
	CSS File	Generates CSS template file for the project
	HTML File	Generates HTML template file for the project
Desktop	Data Object Viewer Class	Generates Desktop Viewer class for the selected table or view
Resource	Attribute Properties	Generates a messages.properties file for all columns of the selected tables or views
	Command Properties	Generates a command.properties file for mapping the standard web commands for the selected tables or views
	XML File	Generates an XML file for all selected data
Framework (Data Object)	Audit Trail Data Class	Generates Java class to encapsulate meta data for tables/views with audit trail columns
	Audit Trail Data Object	Generates Java base class for all DataObject classes with audit trail columns
	Abstract DAO	Generates Java base class for DAO classes
Framework (Java Bean)	Java Bean Abstract DAO	Generates Java base class for Java Bean DAO classes
	Java Bean Abstract Search Criteria Data	Generates Java base class for Java Bean SearchCriteriaData classes
	Java Bean Search Criteria Data	Generates Java interface implemented by all Java Bean SearchCriteriaData classes
	Java Bean Data Not Found Exception	Generates DataNotFoundException class required by generated Java Bean DAO classes
	Java Bean Result Set Helper	Generates ResultSetHelper class required by generated Java Bean DAO classes
	Java Bean SQL Command	Generates SQLCommand class required by generated Java Bean DAO classes
	Java Bean SQL Statement Helper	Generates SQLStatementHelper interface required by generated Java Bean DAO classes
	Java Bean SQL Utilities	Generates SQLUtils class required by generated Java Bean DAO classes
	Java Bean Abstract Stored Procedure	Generates Java base class for Java Bean Stored Procedure classes

Copyright © 2007-2008 ThinkUI Software Inc. All rights reserved.
Java is a registered trademark of Sun Microsystems. Other trademarks or registered trademarks are the property of their respective owners.