Develop a simple GUI based database driven application for Bank system.
• 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
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.
Please note that we are here to help you learn Java, but you can't learn Java by not putting in any effort yourself. You must show some effort and do your own homework. Just dumping your homework problem here, without showing what you have done yourself and without any information about what you don't understand, doesn't work. Don't expect people here to do your homework for you and provide you with a ready-made solution.
So, tell us what you tried yourself, and where exactly you got stuck. We're glad to give you a little push in the right direction. We are not going to do the entire exercise for you.
nadeem akhtar wrote:i m just begner, please help me
Are you doing a Java course for school? Surely you must have gotten a book for the course that explains the basics of Java? You can find an excellent set of tutorials on Sun's website.