Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a project that interacts with the user and displays database records. 1 . Create Java project Week 0 5 Test 1 . This project

Create a project that interacts with the user and displays database records.
1. Create Java project Week05Test1. This project will include development of the ViewStudentsMajors.java, DisplayStudentInfo.java, DisplayMajorInfo.java and MainViewer.java. (20 points-be sure to name the objects as required)
2. Prompt the user with the following options and display the contents of the tables using LoadListFromDatabase: (30 points)
Enter option 1 view Student records
Enter option 2 view Major records
Enter option 3 view both Student records and Major records
a. When the user selects option 1, you will pass in the parameters to display the Student table. (Create your own data in the database and table with at least 5 records. Be sure to provide the SQL script in your project folder.)
b. When the user selects option 2, you will pass in the parameters to display the Major table. (Create your own data in the database with at least 5 records.)
c. When the user selects option 3, you will pass in the parameters for each option and run them back-to-back.
3. You must use the ReadVALUEFromUser methods provided in Java 1 to obtain user input. (10 points)
4. If there is a connection issue with the database, the program must issue this error message Database connection issue in method MethodName. Please contact Support for Project CS.(10 points)
5. Demonstrate that you know how to use a finally block. This finally block of code needs to print a message stating Processing Complete by Program Name.(10 points)
6. The program needs to catch the following exceptions and provide this error message: (10 points)
a. IndexOutOfBoundsException You have an issue with your index. Please contact level 1 Support for Project CS.
b. NullPointerException The value pass is NULL data needs to be fixed. Please contact level 1 Support for Project CS.
7. You must provide a copy of your database SQL script in the Database folder. If you choose to use access instead of SQL, the database must be in the JDBC-to-MSAccess folder. (10 points)
8. Be sure the program checks for other error processing, validation, etc. as necessary. (20 points)
9. The program must follow proper naming conventions of this course. (20 points)
10. Test the program and provide a print-screen of the test results. (20 points)
11. Be sure to have the proper program documentation/comments. All methods must have the proper JavaDoc comments. (20 points)
12. Generate a JavaDoc for your Project. You do this by selecting your project folder, select Project, Generate JavaDoc. You can refresh your project to see the doc folder that contains your index.html. Select Open With, Web Browser, navigate to annotations and provide a print-screen with your submission. (20 points)
13. Refer to the homework assignments for tips on how to create this application.

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Database Theory Icdt 97 6th International Conference Delphi Greece January 8 10 1997 Proceedings Lncs 1186

Authors: Foto N. Afrati ,Phokion G. Kolaitis

1st Edition

3540622225, 978-3540622222

More Books

Students also viewed these Databases questions

Question

RP-2 What is the best way to predict a persons future behavior?

Answered: 1 week ago