Image Added

Figure 1 :

JDBC Action Menu

Image Added

Figure 2 : JDBC Datalist Action

Properties

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.

Insert your SQL statement here. Use syntax like {id} in query to inject the selected row key.Use {uuid} to generate a unique id.

INSERT INTO app_fd_sample (id, c_clicked) VALUES ( {uuid}, {id} );

UPDATE app_fd_sample SET c_clicked = CONCAT(c_clicked, ',', {id}) WHERE id = '123';

DELETE FROM app_fd_myTable WHERE id = {id}