SQL Builder¶
Summary¶
- This section describes the setting contents of [SQL Builder] in im-JavaEE Framework Editor.
Operation Steps¶
Select the method for which you want to set SQL on the DAO tab.
Design the SQL on SQL Builder [Selection Mode].
In the SQL Builder you can design SQL in GUI mode and text mode.
In the GUI mode you can set the existing table from the Data Source Explorer.
On the Input Mapping Screen, argument defined in the method and SQL parameter are mapped.
On the Output Mapping Screen, return value defined in the method and the column of SQL execution result are mapped.
Save the Editor to complete the SQL setting for DAO method.
SQL Builder [Selection Mode] GUI Screen Menu¶
Available menu in GUI mode of SQL Builder is as follows.On this screen each screen is named and explained as follows.
- Tool Bar
Item Description Add Column Add OR item which is a condition phrase to the Column Setting Table. Change SQL Type Change CRUD type of SQL to be edited on GUI. Add DAO Model Insert model class to the screen. CSV Import Insert data created by CSV. SQL Import Import SQL statement.
- Palette
Item Description Table Place table on GUI screen. Column Place column in the table on GUI screen. Connection Connect tables in different tables.
- Column Setting Table
Item Description Column Name Another Name Specify alias of column. Table Output Specify if this column is obtained as SQL execution result. Sort Type If this column was selected for Output, set the sort sequence. Sequence Set the sorting priority for sorting this column. Function Set the function which is an output result of this column. Group Specify this column by the GROUP BY phrase. Condition Set the condition of WHERE phrase. OR Add condition phrase of WHERE by OR.