File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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!