vuexpert@gmail.com

Instructions

Please read the following instructions carefully before submitting assignment:

It should be clear that your assignment will not get any credit if:

§ The assignment is submitted after due date.

§ The submitted assignment does not open or file is corrupt.

§ All types of plagiarism are strictly prohibited.

Note: You have to upload .java and .mdb files. Assignment in any other format (extension) will not be accepted. If you will submit code in .doc (Word document) or .txt file you will get zero marks. You have to upload zip file if there are more than one file.

Objective

The objective of this assignment is to provide hands on experience of

§ Developing GUI based database driven application

§ Creating database in MS Access

§ Creating system DSN

§ Connecting to database

§ Querying data from database using SQL statements

§ Exception handling

Guidelines

§ Code should be properly aligned and well commented.

§ Follow java naming conventions for writing class names, variables names, function names etc

Assignment

Problem Statement:

Develop a simple GUI based database driven application for Bank system.

Core Requirements:

• Developing a simple GUI based database driven application
• Creating a database in MS Access
• Creating a system DSN
• Connecting to database
• Querying data from database through SQL statements

Detailed Description:

You are required to use MS Access to create a database named Bank and add a table named Account into this database.

The Account table must have following fields:

1. Account Number
2. Account Holder Name
3. Account Type
4. Account Balance

You must enter 10 records within Account table of Bank database.

Create a system DSN (Data Source Name) named bankDSN and use this DSN in a program to connect to this database.

Write a program which will have following functionalities:

1) A method which will have the functionality to connect to database.

2) A method which will retrieve all the records of user from database and display on GUI window. The top header of GUI window must have columns name of table Account. The column names displayed on GUI must be same as columns name within table of database. You have to use ResultSetMetaData object for this purpose. You cannot use hard coded values to display columns name.

• The above method will connect to this database and query all the records from the “Account” table using SQL statement and display them on GUI application.
• You can use Grid Layout to display the records from database to GUI application.
• You must use ResultSetMetaData to display exact name of columns of database table on the top of GUI application. Marks will be deducted in case of not using ResultSetMetaData.

Note: You must also upload .mdb file. Marks will be deducted in case of not submitting .mdb file.

Deadline

Your assignment must be uploaded/submitted on or before 23^rd Nov, 2009