Versions Compared

Old Version 1

changes.mady.by.user Hugo

Saved on

compared with

New Version Current

changes.mady.by.user sjk

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColorgreen
borderWidth1
titleBGColor#ddffcc
borderStylesolid
titleDefinition定义

JDBC表单绑定器允许您定制如何通过用户定义的SQL语句从Joget或自定义数据库中存储和/或加载表单数据。

注意，作为一个加载绑定器，您只需要配置数据源和选择查询;作为存储绑定，您还需要为INSERT、UPDATE和DELETE编写SQL。

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.

Panel
borderColorpurple
borderWidth1
titleBGColor#ddccff
borderStylesolid
titleNew Feature新功能

这是Joget Workflow v6中的一个新功能。This is a new feature in Joget Workflow v6.

Figure 1: JDBC Form Load Binder Properties

图1:JDBC表单绑定器－属性。

名称描述
数据源
  • 自定义数据源
  • 默认数据源

通过选择默认数据源，您的Joget当前使用的数据库将被选中。

自定义的JDBC驱动程序

自定义JDBC驱动程序。当在上面的数据源中选择自定义数据源时，需要这个字段。

自定义的JDBC URL
定制的JDBC URL。当在上面的数据源中选择自定义数据源时，需要这个字段。
自定义JDBC的用户名 
自定义JDBC的用户名。当在上面的数据源中选择自定义数据源时，需要这个字段。
自定义JDBC密码

自定义JDBC密码。当在上面的数据源中选择自定义数据源时，需要这个字段。

Info
title测试连接参数

点击页面底部的“测试连接”按钮，快速测试你的配置。

SQL SELECT查询
NameDescription
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
titleTest 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
languagesql
linenumberstrue
SELECT * FROM app_fd_table WHERE  id = '#requestParam.id#'

...

Figure 2: JDBC Form Store Binder Properties

SELECT * FROM
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.
  • 默认数据源

通过选择默认数据源，您的Joget当前使用的数据库将被选中。

自定义的JDBC驱动程序

自定义JDBC驱动程序。当在上面的数据源中选择自定义数据源时，需要这个字段。

自定义的JDBC URL
定制的JDBC URL。当在上面的数据源中选择自定义数据源时，需要这个字段。
自定义JDBC的用户名 
自定义JDBC的用户名。当在上面的数据源中选择自定义数据源时，需要这个字段。
自定义JDBC密码

自定义JDBC密码。当在上面的数据源中选择自定义数据源时，需要这个字段。

Custom JDBC Password

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

Info
titleTest the connection parameters

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

测试连接参数

点击页面底部的“测试连接”按钮，快速测试你的配置。

SQL SELECT查询SQL SELECT Query
Code Block
languagesql
linenumberstrue
1
SELECT * FROM 
app_fd_
table
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
languagesql
linenumberstrue
INSERT app_fd_table 
       (id, 
        c_name, 
        c_emailaddress, 
        c_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

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

Code Block
languagesql
linenumberstrue
UPDATE app_fd_table 
SET    id = {id}, 
       c_name = {name}, 
       c_emailaddress = {emailAddress}, 
       c_contacttel = {contactTel} 
WHERE  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
languagesql
linenumberstrue
DELETE FROM app_fd_table 
WHERE  id = {id}