aspose file tools*
The moose likes JDBC and the fly likes please help me Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "please help me" Watch "please help me" New topic
Author

please help me

nadeem akhtar
Greenhorn

Joined: Oct 17, 2009
Posts: 12
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.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61426
    
  67

Sounds like a homework project. What have you developed so far? What parts have you stuck?


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61426
    
  67

Also, please read this.
nadeem akhtar
Greenhorn

Joined: Oct 17, 2009
Posts: 12
Bear Bibeault wrote:Sounds like a homework project. What have you developed so far? What parts have you stuck?


i m just begner, please help me

Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61426
    
  67

In order to help you, we need to know what you are having problems with. You haven't said.

If you are just looking for someone to do your thinking for you, or to simply hand the work to you, you are in the wrong place.

So let us know what you've done so far, and what parts are giving you problems. Many will be glad to help -- but you've got to put in the effort.
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14269
    
  21

Nadeem, welcome to JavaRanch.

Please have a look at this: How to ask questions on JavaRanch.

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.


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39409
    
  28
Jesper Young wrote:Nadeem, welcome to JavaRanch.
Agree
You can find an excellent set of tutorials on Sun's website.
Jesper is correct; there is a very nice section in that tutorial about "JDBC" which will answer most of your questions.

Start small. Design your database, unless you have been given a ready-made database. Set up access and get that working correctly. Then draw a GUI around that funtionality.

I think you will start off this assignment with database access problems, so shall move this thread to our databases forum.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: please help me