JDBC Form Binder allows you to customize how form data is stored and/or loaded, either from Joget or custom database via user-defined SQL statements. Note that, as a load binder, you only need to configure the datasource and SELECT query ; as a store binder, you will also need to write SQL for INSERT, UPDATE, and DELETE. |
This is a new feature in Joget Workflow v6. |
Figure 1: JDBC Form Binder Properties
Name | Description | |
---|---|---|
Datasource |
By selecting Default Datasource, the database your Joget is currently using will be selected. | |
Custom JDBC Driver | Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above. | |
Custom JDBC URL | Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. | |
Custom JDBC Username | Custom JDBC Username. This field is required when Custom Datasource is selected in Datasource above. | |
Custom JDBC Password | Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.
| |
SQL SELECT Query |
| |
SQL INSERT Query | Use syntax like curly brackets {field_id} in query to inject submitted form data.
| |
SQL UPDATE Query | Use syntax like curly brackets {field_id} in query to inject submitted form data.
| |
SQL DELETE Query | Used in deleting form data records in Datalist/Grid element. Use syntax like curly brackets {id} in query to inject form data primary key
|
Below is a sample app to demonstrate the use of JDBC Load and Save Binder. All the above SQL statements are in this demo app:
Download APP_jdbc_example.jwa.