Page History

• Custom Datasource
• Default Datasource

By selecting Default Datasource, the database your Joget is currently using will be selected.

Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above.

Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.

Example of a MySQL statement for Load Binder& Save Binders

SELECT * FROM app_fd_table WHERE id = '#requestParam.id#'

INSERT
app_fd_table
(id, c_name, c_emailAddress, c_contactTel)
VALUES
({id}, {name}, {emailAddress}, {contactTel})

UPDATE
app_fd_table
SET
id={id},
c_name={name},
c_emailAddress={emailAddress},
c_contactTel={contactTel}
WHERE
id = '#requestParam.id#'