Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
...
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 INSERT data.
(id, c_name, c_emailaddress, c_contacttel) VALUES ({id}, {name}, {emailAddress}, {contactTel})
| ||||||||||||||||||||
SQL UPDATE Query | Use syntax like curly brackets {field_id} in query to inject submitted form data .
SET id =
WHERE id =
| ||||||||||||||||||||
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
WHERE id =
|
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:
...