Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

DEFINE human resources planning (HRP) and

Answered: 1 week ago

Question

How do we organise for international logistics?

Answered: 1 week ago