Java database

[Justina]

I need to develop a database ( Microsoft Access )program with Java. How can I use JDBC to connect to the database ( what is the step )? How can I control the database ( like add record, delete record etc ) ?

Thanks.

JWFY

[unicman]

If u r going to use JDBC-ODBC bridge, then...

1. Create database using access
2. Create DSN in ODBC
3. In JAVA specify the DSN to the JDBC-ODBC bridge.
4. Then using the 'java.sql' package, u can execute queries get record-sets.

- UnicMan
http://members.tripod.com/unicman

[Masaaki]

Hi.

The latter answer is that you must write the whole sql code if you want to add or delete the record in Access database.
But VC++ has it own function like AddNew() and so on.

This means that if you write the code to the complecated sql statement, Java shared many lines with only sql code.
In this case, we create the new Java class to deal with this. But I did't do that.

HTH.
-Masaaki Onishi-

For some basic code samples using the JDBC, try this URL:

http://developer.java.sun.com/developer/codesamples/database/

You will need to register with Sun's Java Developer's Connection (free).

Good Luck,

Troy

VJ++ has this also, but I want to know how to make an applet using it (VJ 6.0)
If you can tell me Ill be forever in your debt

[Masaaki]

Hi.

Since I have never used VJ++ recently, I can't advise you to do this.

If we focus on applet to Access database, we use RMI or Servlets
on Sun Java. But I don't know how to do it by VJ++.

I used to use ASP (Active Server Page) before.

Regards.
-Masaaki Onishi-