ServerConnection
Aus Programmers Guide
Roy (Diskussion | Beiträge) |
Roy (Diskussion | Beiträge) |
||
Zeile 1: | Zeile 1: | ||
import java.sql.Connection;<br>import java.sql.DriverManager; | import java.sql.Connection;<br>import java.sql.DriverManager; | ||
- | + | ||
public class ConnectToServer<br>{<br> public static Connection connectToMySQL()<br> {<br> Connection conn = null; | public class ConnectToServer<br>{<br> public static Connection connectToMySQL()<br> {<br> Connection conn = null; | ||
Zeile 13: | Zeile 13: | ||
} <br> <br>}<br><br> | } <br> <br>}<br><br> | ||
- | + | [[Media:Mysql-connector-java-5.1.8-bin.jar.7z|MySQL-Connector JAVA]] | |
[[Category:Java]] [[Category:Klassen]] | [[Category:Java]] [[Category:Klassen]] |
Version vom 07:39, 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.");
}
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;
}
}