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:
- Account Number
- Account Holder Name
- Account Type
- 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.