|
Home
|
 Smart Master-Detail built with an
Application Wizard Let’s build a searchable master-detail over a sales table that also allows full update, insert and delete capability. We’ll use the Application Wizard which requires no coding. The finished product will show a form, grid, search panel, result tree all sortable by store ID and product sales. 1. We start by choosing a MasterDetail Wizard component in the Application Builder.
2. The DataWizard for the MasterDetail appears. We walk through table selection, and joining Sales and Stores tables.
3. We define search and query result settings.
4. Now
layout the form (master) visually. The grid (detail) will
be created automatically from the primary table. 5. JDesignerPro creates all the Java code, forms components, SQL, server messaging, JDBC calls and component interactions for us. It then draws the master-detail on the screen, complete with buttons. We can now customize this form if desired or keep it as is.
6. By
pressing the compile button we go to the preliminary view
of the finished screen. Notice that the compiled screen
is already live to the database and looks identical to
the screen on the right side Application Builder picture
above. JDesignerPro is truly WYSIWYG. That’s it! This screen is done in about 20 minutes and is ready to deploy. Notice that we did not enter any Java code or even look at things like interactions and object properties, etc. Although those things are readily accessible for advanced users. Notice also that unlike most of the competing products JDesignerPro allows you to navigate through resulting data using a smart tree structure. Most IDEs use VCR style controls which in the real world are virtually useless unless you have only 20 records in your database table. |
|
|
