Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Panel | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||
JDBC 数据库绑定器 使用您自己的自定义SQL查询和连接为您提供了设计列表的灵活性。JDBC Datalist Database Binder gives you the flexibility of designing a list by using your own custom SQL query and connection. |
Panel | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||
这个特性在Joget Workflow v6中得到了增强。This feature has been enhanced in Joget Workflow v6. |
Figure 图 1: JDBC Datalist Database Binder PropertiesJDBC数据库绑定器属性
名称 | 描述 | |||||
---|---|---|---|---|---|---|
数据库 |
通过选择默认数据源,Joget当前正在使用的数据库将被选中 | |||||
JDBC驱动 | 自定义JDBC驱动程序。当在上面的数据源中选择自定义数据源时需要这个字段。 | |||||
客户化JDBC URL | 自定义JDBC URL。当在上面的数据源中选择自定义数据源时需要这个字段。 | |||||
JDBC(数据库)用户名 | 自定义JDBC的用户名。当在上面的数据源中选择自定义数据源时需要这个字段。 | |||||
JDBC(数据库)密码 | 自定义JDBC密码。当在上面的数据源中选择自定义数据源时需要这个字段
| |||||
SQL查询语句 | SQL选择查询。(例如,select * from dir_user) | |||||
主键 | 定义主键列。默认情况下,它应该是“id”。 | |||||
优化分页查询语句 | 当选中时,绑定器只提取所选页面的项目,而不是返回整个数据集以提高加载速度。 注意:只适用于MYSQL和MSSQL目标数据库。
| |||||
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 Select Query. (e.g. Select * from dir_user) | |||||
Primary Key | Define the primary key column. By default, it should be "id". | |||||
Optimize query for paging | When checked, the binder only fetches selected page's items rather than the returning the whole data set for improved loading speed. Note: Only applicable to MYSQL and MSSQL target database.
|