Assignment Name: InventoryApp

Assignment Specifications: Write a basic Inventory Management Application using JavaFX that allows your user to perform the following database operations:

Display all of the inventory in the database in a JavaFX table view.

Add a new inventory item.

Update an existing inventory item.

Delete inventory item selected from the table view (prompt the user if they are sure they want to delete the selected record). An Export button that exports the selected row in the table view to a text file (extra credit if your program exports to HTML, and/or XML format 1 point extra credit for each format).

Other functionalities your instructor will be looking for:

Usage of regular expressions for data input validation in all input text fields (your instructor will try to crash your program).

Ensure user input values are within the constraints of the database table field constraints (ie. If you have a field that is a varchar(30), do not let your program attempt to insert/update a string to the field in excess of 30 characters).

Come up with an approach for securing log in credentials into the database.

Some ideas (you can implement all of these ideas or any combination of them):

Create a database specific user account that is only allowed to select records, insert records, update records, and delete records (no other database privileges).

Use a secure cryptographic hash digest method (SHA256, RIPEMD160, etc) Singleton Pattern (https://www.journaldev.com/1377/java-singleton-design-pattern-best-practices-examples) that holds the user credentials in a secure manner.

Log in window in your application that utilizes the JavaFX Password field control (the password is still in a member variable of the Password field control in plaintext, so itll still need to be secured in some manner).