ServerConnection
Aus Programmers Guide
(Unterschied zwischen Versionen)
Roy (Diskussion | Beiträge) |
Roy (Diskussion | Beiträge) |
||
(Der Versionsvergleich bezieht 2 dazwischenliegende Versionen mit ein.) | |||
Zeile 1: | Zeile 1: | ||
- | import java.sql.Connection; | + | <source lang="java"> |
+ | import java.sql.Connection; | ||
+ | import java.sql.DriverManager; | ||
- | |||
- | public class ConnectToServer | + | 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; | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </source> | ||
<br> | <br> | ||
+ | |||
+ | == JDBC-Treiber == | ||
+ | |||
+ | [[Media:Mysql-connector-java-5.1.8-bin.jar.7z|MySQL-Connector JAVA]] | ||
[[Category:Java]] [[Category:Klassen]] | [[Category:Java]] [[Category:Klassen]] |
Aktuelle Version vom 09:55, 30. Mär. 2010
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; } } }