getting started with databases

From: Agata Staniak (agaace_at_usenet.vitryna.pl)
Date: 03/27/04 

Date: Sat, 27 Mar 2004 14:48:08 +0100

Hey!
I need to write a simple applet that will use a simple database (actually, a
Microsoft Access file - db1.mdb).
I don't know much about databases, I only know how to write simple SQL
queries (I only used PHP + MySQL so far).
And as I read in Sun's JDBC tutorial, before establishing a connection I
have to load some driver.

So I have some questions:
1) What is the name of the driver for mdb files?
2) Where can I get it (or maybe it is automatically installed with JDK 1.4)?
3) Do I need anything more to establish a connection with the database?

If anyone could send me a simple snippet that connects to an mdb file, makes
a query (something like "SELECT * FROM table;") and disconnects - it would
be great - I totally lost my way :-(

Thanks in advance 

-- 
Agata Staniak

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)
  • Re: ESQL/C documentation nightmare
    ... documentation about explicit and implicit connections. ... CONNECTION connection statements for new applications of Version 6.0 ... the SQL database statements (such as ...
    (comp.databases.informix)