IT-162 Java 2

Test 1

Apply your knowledge of Java 2 programming techniques. Submit the project.zip via Blackboard.

Create a project that interacts with the user and displays database records.

Create Java project Week05Test1. This project will include development of the ViewStudentsMajors.java, DisplayStudentInfo.java, and DisplayMajorInfo.java. (20 points-be sure to name the objects as required)

Prompt the user with the following options and display the contents of the tables: (30 points)

Enter option 1 view Student records

Enter option 2 view Major records

Enter option 3 view both Student records and Major records

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

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

When the user selects option 3, run will pass in the parameters for each option and run them back-to-back.

You must use the ReadVALUEFromUser methods provided in Java 1 to obtain user input. (10 points)

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)

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)

The program needs to catch the following exceptions and provide this error message: (10 points)

IndexOutOfBoundsException You have an issue with your index. Please contact level 1 Support for Project CS.

NullPointerException The value pass is NULL data needs to be fixed. Please contact level 1 Support for Project CS.

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)

Be sure the program checks for other error processing, validation, etc. as necessary. (20 points)

The program must follow proper naming conventions of this course. (20 points)

Test the program and provide a print-screen of the test results. (20 points)

Be sure to have the proper program documentation/comments. All methods must have the proper JavaDoc comments. (20 points)

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)

Refer to the homework assignments for tips on how to create this application.