This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes Beginning Java and the fly likes And So It Begins Again Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "And So It Begins Again" Watch "And So It Begins Again" New topic

And So It Begins Again

Sue Hunt
Ranch Hand

Joined: Jan 26, 2004
Posts: 50
Hi All. Just wanted to say a big thanks for all the help you gave me during my last assignment. I happy to say, that with your help, I made an 86% on it.
Was wondering if you could point me in the right direction for the following, before I start attempting the coding.
1. Able to query 3 different questions to a MS Access relational database, containing 2 tables. Using a single class and the main method continually looping. (have a feeling that I will be loopy by the end of this *grin*).
2.Implementing business objects in a three-tier architecture (three-layer architecture) to access a database.
Thanks in advance for your help.
Antoine Waugh
Ranch Hand

Joined: Jan 24, 2004
Posts: 66
this question is probably more suited to the jdbc forum:
but just in case you are new to the concept of jdbc, ill give you a quick run down.
basically on a windows system you can create what is called an ODBC
Control Panel >> Administrative tools >> Data Sorces (ODBC)
from there, you can add a file (in your instance a MS Access file) and once there, using third party components (such as java) we may view and manipulate such files.
a small example is reading from an excel file, although trivial, it shows you the basics of quiering a specific table, from a specific odbc..

from the code sample obviously 'ShowCodes' is the name of the odbc.. and once result set 'rs' is defined, we may call queries like:

which returns the column values under the heading/title 'state'
a helpful tutorial on MS ACCESS access with jdbc is
that should get you started
hope this helps somewhat
[ April 22, 2004: Message edited by: Antoine Waugh ]

B.C.S.T, SCJP, Hero
Dirk Schreckmann

Joined: Dec 10, 2001
Posts: 7023
As suggested, for JDBC-related questions, the JDBC forum is a good place to ask them.
For asking about system design concepts, the OO, Patterns, UML and Refactoring forum is a good place to go.
For an easy introduction to JDBC, I suggest following the JDBC section of assignments in the JavaRanch Cattle Drive. Just click on "Assignment JDBC-1", and follow along. That's how I learned it.

[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
Sue Hunt
Ranch Hand

Joined: Jan 26, 2004
Posts: 50
Thanks guys, shall take your hints, clues and comments on board.
Once I'm ready to start firing questions about my coding, I shall go to the JDBC forum.
ps (see I'm trying not to leave it till the last minute again *grin*)
I agree. Here's the link:
subject: And So It Begins Again
It's not a secret anymore!