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. Cheers Sue
heyas, this question is probably more suited to the jdbc forum: http://www.coderanch.com/forums/f-3/JDBC 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 http://home-1.worldonline.nl/~bmc88/java/jdbc/ that should get you started hope this helps somewhat -twans [ April 22, 2004: Message edited by: Antoine Waugh ]
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. Cheers Sue ps (see I'm trying not to leave it till the last minute again *grin*)