Recommended: Sing it, brah! 5 fabulous songs for developers
JW's Top 5
Please help me to solve this task. I would be very thankful to you.
You are required to develop a simple GUI based database driven application.
Core Tasks:-
1. Building database
2. Connect to database
3. Query the database
4. Display result in proper format
Tasks Details:
1. Use MS Access to create database with the name “DATESHEET” and add a
table to it with name “STUDENT”.
2. Your table should have following fields.
rollNo
studentName
city
degreeProgram
courseID
sessionID
date
time
3. Enter at least 20 records in the table.
4. Create a System DSN with the name “studentDSN”.
5. Build a simple GUI based program which will connect to this database
and query all the records in the “STUDENT” table and display them.
6. Use Grid Layout to display the records.
7. You should use Jlabel in every cell of the grid layout to display a field from
table.
8. Also add a header row in the layout which would contain the names of the
fields. (Use hard coded names of table fields, do not use meta data)
9. Marks will be deducted if any student does not use the same names
(database, table and System DSN) as told above. (2 Marks)
10. Exceptions Handling related to DB should be handled properly.
11 Code should be nicely aligned and well commented where required.
12 Also don’t forget to submit your database along with your code.