ServerConnection
Aus Programmers Guide
import java.sql.Connection;
import java.sql.DriverManager;
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;
}
}