Release Notes
Browse Database
You can connect to any database using a JDBC driver that has been installed. The following instructions will help you install your JDBC driver. Once your driver has been installed, simply edit the database connection to provide information to connect to the database. Use the Tree Viewer to browse the database model.
Issue SQL Queries
To issue SQL queries, simply double-click on a database connection or a table or view in the Tree Viewer. Use the "View" » "SQL Query..." menu item or the "SQL>" button on the Toolbar to open a separate SQL Query Viewer.
Perform Data Entry
To perform data entry, simply double-click on any database table or any row of a database table. Use the Menu or Tool bar to open a separate Data Object Viewer.
Generate Code
To generate code for the selected data object(s), use the mouse right-click to bring up the context popup menu, select the "Generate" menu, and select the desired artifact (e.g. Java Bean, SQL Query, Properties File, etc.). To customize the generated code, edit the appropriate template file found in the template folder.
Generate Data
To generate data, please download and install the ThinkUI Data Generator application. You can use the "Generate Data" » "Ant Build File..." feature to quickly create the Ant script to perform bulk data generation.
Batch Mode
The application can run in "batch" mode in order to perform bulk code generation via Apache Ant. Please refer to the various sample build.xml files in the batch folder for further details. All code generation commands are accessible via the thinkui.sqlclient.ant.GenerateTask (found in the thinkui_sqlclient_ant.jar file). In addition, the thinkui.sqlclient.ant.GenerateCodeGenBuildXMLCommand can be used to generate an appropriate build.xml file for a given target code generation command that will be invoked for all tables matching a given pattern.
Capture Data Model
To capture the data model for the selected tables or views, use the mouse right-click to bring up the context popup menu and select to the "Capture Data Model" menu item. The captured data model can be enhanced and used as input meta data for code generation. To use cached meta data instead of perform dynamic meta lookup, use the "Capture" » "Data Model (LATEST)" feature and enable the "Load Model Meta Data" preference.
Load Data File
To load data from a flat file (e.g. CSV, Tab-delimited, or Excel) into the selected table, use the "Import Table Data" menu item. Ensure that the columns of the file being imported corresponds to the columns of the selected table.
www.thinkui.com