MS-acces-database and Java

[Andre Flemming]

Hello Ranchers,
I'm new in Java. I have already written some little applets. Now I would like to write an applet that uses an MS-Access database. Is that possible? Are the necessary JDBC-drivers included in the JDK? Are there some examples found online?
Many thanks,

[Brett Knapik]

it is possible, you DO need to have a jdbc driver they can be found at sun i believe. I don't know any online tutorials you can try findtutorials.com for some but a jdbc book would be the best.
------------------
I wish there was a button on my monitor to turn up the intellegince.
Theres a button called 'brightness' but it doesn't work

[Anonymous]

There is a driver at the java.sun.com web site, but it is really only good for development / testing. I wouldn't deploy anything with it because it is too slow. It's called the jdbc-odbc Bridge driver. There is a pretty good tutorial on its use at the sun site as well.
The situation is something like this:
1) install the driver and set up a DSN for your database
2) import java.sql.* into your class
3) load the driver
4) make a connection with your loaded driver
5) do something with your connection
6) close the connection

     import java.sql.*;
     public class mySQLTest{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");   
     Connection con = Driver Manager.getConnection
         ("jdbc :odbc:myDSN", "UserID", "Password"); 
     Statement st = con.createStatement();
     ResultSet rs = st.executeQuery("SELECT * FROM MYTABLE");
     // do something with your result set in here...
     rs.close();
     st.close();
     con.close();
}

That should get you started.
Nick
[This message has been edited by Nick Riviera (edited November 10, 2000).]

[Anonymous]

oops. All of that code inside the class def should have been inside main(). Sorry about that.
Nick

[Andre Flemming]

Thank you, Nick, it helps me already a lot.