ServerConnection

Aus Programmers Guide

Version vom 07:39, 30. Mär. 2010

import java.sql.Connection;
import java.sql.DriverManager;

MySQL-Connector JAVA

public class ConnectToServer
{
public static Connection connectToMySQL()
{
Connection conn = null;

try
{
String userName = ;
String password = ;
String url = ;
Class.forName ("com.mysql.jdbc.Driver").newInstance ();

conn = DriverManager.getConnection (url, userName, password);
System.out.println("Verbindung zum Mysql Server hergestellt.");
}
catch (Exception e)
{
System.err.println("Kann mich nicht zum MySQL-Server verbinden.");
System.err.println(e.getMessage());
}
return conn;
}

public static Connection connectToMDB(String mdbFilePath) {

Connection con = null;

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(
"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="
+ mdbFilePath, "", "");
//String myDB = "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:/test.xls;"
// + "DriverID=22;READONLY=false";
System.out.println("Verbindung zur MDB "+mdbFilePath+" hergestellt.");
} catch (Exception e) {
System.err.println("Fehler beim öffnen der MDB Datei.");
System.err.println(e.getMessage());
}
return con;

}

}