Page History

Figure 1: Advance - Load & Save Binder

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

com.mysql.jdbc.Driver

Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. Example:

jdbc:mysql://localhost/jwdb?characterEncoding=UTF8&useSSL=false

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

The SQL query specific to your database type (MySQL, MSSQL, Oracle, etc.). Use question mark (?) in your query to represent the primary key or foreign key.

SELECT * FROM app_fd_table 
WHERE id = ?

Figure 3: Configure Store JDBC Binder

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

com.mysql.jdbc.Driver

Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. Example:

jdbc:mysql://localhost/jwdb?characterEncoding=UTF8&useSSL=false

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

The SQL query specific to your database type (MySQL, MSSQL, Oracle, etc.). Use syntax like {field_id} in query to inject submitted form data.

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

Note: If you use JDBC in a form grid or spreadsheet for load or save binder, be advised the SQL syntax is different from form load or save binder. Kindly download and view the sample app for JDBC in a form grid or spreadsheet.

Use syntax like curly brackets {field_id} in query to inject submitted form data. 

INSERT app_fd_table 
       (id, 
        c_name, 
        c_emailaddress) 
VALUES ({id}, 
        {name}, 
        {emailAddress}) 

You can use {uuid} to tell Joget to create a random unique id or a "Universally unique identifier". Example:

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

Note: Be advised JDBC load/save binders cannot be used if your form or form grid has file or image attachment field elements. You will need to use the default Multirow Form Binder in this circumstance.

Use syntax like curly brackets {field_id} in query to inject submitted form data.

UPDATE app_fd_table 
SET    id = {id}, 
       c_name = {name}, 
       c_emailaddress = {emailAddress}, 
       c_contacttel = {contactTel} 
WHERE  id = {id} 

SQL statement to delete form data records in Datalist/Grid element. Use syntax like curly brackets {id} in query to inject form data primary key value.

DELETE FROM app_fd_table 
WHERE id = {id}