Assignment Name: ContactApp Assignment Specifications: Write a basic Contact Management Application using JavaFX that allows your user to perform the following operations: 1. Display all of the contacts in the database in a JavaFX table view. 2. Add a new contact. 3. Update an existing contact. 4. Delete contact selected from the table view (prompt the user if they are sure they want to delete the selected record). 5. 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: 1. Usage of regular expressions for data input validation in all input text fields (your instructor will try to crash your program) 2. Ensure user input values are within the constraints of the database table field constraints (ie. If you have a field that is a yarchar(30), do not let your program attempt to insert/update a string to the field in excess of 30 characters). 3. 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): a. Create a database specific user account that is only allowed to select records, insert records, update records, and delete records (no other database privileges). b. Use a secure cryptographic hash digest method (SHA256, RIPEMD160, etc) c. Singleton Pattern (https://www.journaldev.com/1377/java-singleton- design-pattern-best-practices-examples) that holds the user credentials in a secure manner. Assignment Name: ContactApp Assignment Specifications: Write a basic Contact Management Application using JavaFX that allows your user to perform the following operations: 1. Display all of the contacts in the database in a JavaFX table view. 2. Add a new contact. 3. Update an existing contact. 4. Delete contact selected from the table view (prompt the user if they are sure they want to delete the selected record). 5. 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: 1. Usage of regular expressions for data input validation in all input text fields (your instructor will try to crash your program) 2. Ensure user input values are within the constraints of the database table field constraints (ie. If you have a field that is a yarchar(30), do not let your program attempt to insert/update a string to the field in excess of 30 characters). 3. 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): a. Create a database specific user account that is only allowed to select records, insert records, update records, and delete records (no other database privileges). b. Use a secure cryptographic hash digest method (SHA256, RIPEMD160, etc) c. Singleton Pattern (https://www.journaldev.com/1377/java-singleton- design-pattern-best-practices-examples) that holds the user credentials in a secure manner
