I need help with this java project. The table is the data that you use to build

Question

I need help with this java project. The table is the data that you use to build the table you will be creating in your database. If you run the program as is, and use that table which is an excel sheet, the program will read the data in that sheet. The project needs to create the database and a table and load records into this table, then change the program to read this table instead if reading it from the excel sheet
Here is the Source code link for (TestScoreReader): http://www.jade-cheng.com/hpu/2012-spring/csci-2912/text-processing-and-wrapper-classes-ii/TestScoreReader.java.
And (TestAverages) source code: http://www.jade-cheng.com/hpu/2012-spring/csci-2912/text-processing-and-wrapper-classes-ii/TestAverages.java? Dr. Harrison keeps student scores in an Excel file. This can be exported as a comma separated text file. Each student's data will be on one line. We want to write a Java program that will find the average for each student. (The number of students changes each year.) Modify the source code included to do the TestAverages java TestScoreReader.java following: Instead of reading the data from the Excel spreadsheet, Create a database called Classes and a table called Grades with the fields and data as specified in the Excel attached. 87 72 94 79 79 92 56 82 91 81 81 67 85 82 74 89 81 81 94 96 79 90 79 Analysis (Describe the problem including input and output in your own words.) Design: (Describe the major steps for solving the problem.)

Explanation / Answer

1) in micorsoft acess database goes to new db and give the name as classes name to database.

2)then on going to control panel crate driver for database.

3)use this database for connectivity

4)and then us sql query for apply command on database.

5) to find average and result.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---