|
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
|