Page History

...

Panel

borderColor	purple
borderWidth	1
titleBGColor	#ddccff
borderStyle	solid
title	New Feature

This is a new feature in Joget Workflow v6.

Image Added

Figure 1: JDBC Form Load Binder Properties

Name

Description

Datasource

Custom Datasource
Default 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.

Info

title	Test the connection parameters

Click on the "Test Connection" button at the bottom of the page to quickly test out your configurations.

SQL SELECT Query

Code Block

language	sql
linenumbers	true

SELECT * FROM app_fd_table WHERE id = ?

Figure 12: JDBC Form Store Binder Properties

Name

Description

Datasource

Custom Datasource
Default 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.

Info

title	Test the connection parameters

Click on the "Test Connection" button at the bottom of the page to quickly test out your configurations.

SQL SELECT Query

Example of a MySQL statement for Load & Save Binders

Code Block

language	sql
linenumbers	true

SELECT * FROM app_fd_table WHERE  id = '

#requestParam

#requestParam.id#'

Note: If you use JDBC in a form grid for load/save, be advised the SQL syntax is different from the above. Kindly download and view the sample app for JDBC in a form grid at the bottom of this page.

SQL INSERT Query

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

Code Block

language	sql
linenumbers	true

INSERT

app_fd_table

 
       (id, 
        c_name, 
        c_

emailAddress

emailaddress, 
        c_

contactTel

contacttel)


VALUES

 ({id}, 
        {name}, 
        {emailAddress}, 
        {contactTel})

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.

SQL UPDATE Query

UPDATE

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

Code Block

language	sql
linenumbers	true

UPDATE app_fd_table

SET

 
SET    id = {id},

 
       c_name = {name},

c_

emailAddress

emailaddress = {emailAddress},

c_

contactTel

contacttel = {contactTel}

 
WHERE

  id =

'#requestParam.id#'

{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

Code Block

language	sql
linenumbers	true

DELETE FROM app_fd_table 
WHERE  id = {id}

Below are sample apps to demonstrate the use of JDBC Load and Save Binders:

Example app using JDBC binders on Form APP_form_load_save_using_jdbc.jwa.
Example app using JDBC binders on Form Grid APP_form_grid_with_jdbc_binder.jwa.
Example app using JDBC binders for Oracle databases APP_example_form_jdbc_on_oracle_v6.jwa

Space shortcuts

Page tree

Versions Compared

Old Version 9

New Version Current

Key