newbie DB question

[centrino]

Hi all.
I have some problems here hope some of you can help me out here.

I am suppose to do a project of a company warehouse for inventory tracking. It is a project that I have to submit for my college.

The database server is suppose to be in the head office.
Clients have to access the database from the warehouse via the Internet.
I would like to build a desktop application in Java for this project instead of using a web interface such as servlets/asp/php etc.

My question is, what is the method used by most such Java applications for handling a database?
Do they use a relational database such as MySQL?.What is the most efficient way for handling data in such a situation?.

Since MySQL is relational and Java is OO, how do they implement the design using MySQL/JDBC?
Is java used here only as an interface?...

Thanks

 

[sedj]

The standard way to connect to db's from Java is via JDBC. This tutorial should give you all the info you need :

http://java.sun.com/developer/onlineTraining/Database/JDBC20Intro/

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk