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,
- Users can access the database and load the table and data.
- Users can select, insert, update, and delete the data without using query, just by choosing the information they want on the screen.
- 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.