Project : Persistence in java
In an information system, employee data must be saved. The data you need to save are: first name, age, address, and salary. This problem must be modelled so that you can use the Java object system and achieve persistence using the MySQL database. You need to ensure that employee data is saved, read, modified, and deleted.
The application must have the following functionalities:
- entering a new employee in the database;
- changing employee data based on ID;
- deleting an employee based on ID;
- displaying all employees in the database;
- only display certain employees in the database according to criteria other than ID (e.g., by name, age, address, or revenue).
The application must have a GUI interface from where the user of the application can choose what operation he wants to perform on employees. It is a good idea to separate the database connection into a specific method or class and call it only at the beginning of each operation, due to the possible need to change some of the parameters of the connection string when examining your project.
The project must be submitted as an IntelliJ IDEA project archived in a RAR or ZIP archive. Also, in addition to the Java project folder, when you submit the project for review, you must enter in that archive both the SQL query file with which you create the table in the database, and all the .jar libraries that you use.