Connecting to MySQL databases

[fenris]

Does anyone know or have a simple example of how to connect java to a MySQL database that lives on a network computer as well as a local computer? I am starting to learn about databases and I figure that MySql would be the best place to start.

Any Comments would be greatly appreciated

Troy Williams B.Eng.
fenris@hotmail.com

 

[palbano]

// if you have a JDBC driver for your database
DriverManager.registerDriver (new Oracle.jdbc.driver.OracleDriver ());
// if you are using the JdbcOdbc Bridge
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"

Connection con = null;
con = DriverManager.getConnection( "jdbcracle:ftisnet:1521rcl1","rnduser", "rndclass"

Hope this helps
-pete

 

[globos]

Hi.

You can use the JDBC(Java DataBase Connectivty) API which corresponds to the java.sql package. But you will need a JDBC driver to dial with your a MySQL database, you can download the mm.mysql driver which is free of use (I think).

There is many tutorials, just search about JDBC and MySQL.

http://www.worldserver.com/mm.mysql/

for the JDBC driver

I hope this will be helpful.

Bye.