Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Then, let upload the plugin jar to Manage Plugins. After upload, the jar file, double-check the plugin is uploaded and activated correctly.

Image Modified

Let create a form to create and update user to dir_user table.

Image Modified

Then, configure the store binder of the section to Default Form Binder and JDBC Binder.

Image Modified

Code Block
languagesql
titleCheck Select Query
select username from dir_user where username = {id}
Code Block
languagesql
titleInsert Query
insert into dir_user
(id, username, firstName, lastName, email, active)
values
({id}, {id}, {firstName}, {lastName}, {email}, 1)

...

Info
titleNote

{uuid} can be used to generate a unique id

Code Block
languagesql
titleUpdate Query
update dir_user set firstName = {firstName}, lastName = {lastName},
email = {email}
where username = {id}

...

Code Block
languagesql
titleDelete Query
delete from TABLE_NAME where id = {id}


Image Modified

Now, let test to add a user.

Image Modified

Check the user is created in dir_user table.

Image Modified

It works! Please remember to test the other features of the plugin as well. (big grin)

...