cs506 assignment no 2 solution fall 2021

 cs506 assignment no 2 solution fall 2021 

Problem Statement:

You are required to write a Java program for a university portal named University Student Search Portal (USSP).The USSP will help the university to add relevant data about student as well as to search the data about a specific student by using his/her student id. The USSP will add and retrieve the information from MS Access like Student Name, Student ID, Student Password and Campus Code.

ucanacces driver and ms access dataBase

Details Description:

You have to create a database in MS Access and add a table in the database. The name of database should be “Record” and the name of table should be “Student”. Student table will have four attributes i.e. ID, Name, Password and Code.

 

DataBase File:

Note: Need to put database file in assets folder in NetBeans project directory as shown below.

Ø    You will have to use ucanaccess driver to connect to MS Access database. In this case, you are suggested to view the video tutorial having title “A video tutorial for installation of UCanAccess Driver.” by downloading it from downloads section of CS506 course.

Ø    For storing/fetching data to/from database, you will need to use proper SQL queries.

Ø    Need to make sure that exceptions are managed properly throughout the program; especially NullPointerException, ClassNotFoundException and SQLException.

Ø    All images, tables and sample data, given in this document, are just for reference purpose only. You have to provide your own implementations. It is not required to be exactly the same.

d