ServerConnection

Aus Programmers Guide

Wechseln zu: Navigation, Suche
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.");
      return conn;
    }catch (Exception e){
      System.err.println("Kann mich nicht zum MySQL-Server verbinden.");
      System.err.println(e.getMessage());
      return false;
    }
  }
 
  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.");
      return con;
    }catch (Exception e) {
      System.err.println("Fehler beim öffnen der MDB Datei.");
      System.err.println(e.getMessage());
      return false;
    }
  }
}


JDBC-Treiber

MySQL-Connector JAVA

Persönliche Werkzeuge