Window Application that simplifies the select, insert, update, and delete query (using JavaFX, Velocity)

• Users can generate CRUD query easily without writing any SQL.
• You can also map Table to Java source codes (i.e., DAO, DTO)

Through Source Code Generator,

1. Users can access the database and load the table and data.
2. Users can select, insert, update, and delete the data without using query, just by choosing the information they want on the screen.
3. Users can map Table field and data (generated as a result of above) into Java DAO, generate default Controller & Service, and download the source code file.

[Insert query generation]

• First, choose a table in Table section (in the left), and fill in some fields (column) like below,

• Then, insert query will be generated.

[Update query generation]

• First, choose a table in Table section (in the left) and choose one row (in the bottom), and changes some field contents like below,

• Then, update query will be generated.

[SQL=>Java code generation]

• Using the table (and all data created from your queries above), you can generate Java source codes (Controller, Service, Dto, Dao, Xml)

You can see more sample images here: https://hongsangy.wixsite.com/portfolio

EXE file can be downloaded in: link

Note: Importing Soure Codes and running it on the local machine might not work currently becuase the jar dependencies are set locally.