ServerConnection
Aus Programmers Guide
Roy (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „import java.sql.Connection;<br>import java.sql.DriverManager; public class ConnectToServer<br>{<br> public static Connection connectToMySQL()<br> {<br> Connectio…“) |
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; |
- | + | [[Media:Mysql-connector-java-5.1.8-bin.jar.7z|MySQL-Connector JAVA]] | |
- | + | public class ConnectToServer<br>{<br> public static Connection connectToMySQL()<br> {<br> Connection conn = null; | |
- | + | try<br> {<br> String userName = ;<br> String password = ;<br> String url = ;<br> Class.forName ("com.mysql.jdbc.Driver").newInstance ();<br> <br> conn = DriverManager.getConnection (url, userName, password);<br> System.out.println("Verbindung zum Mysql Server hergestellt.");<br> }<br> catch (Exception e)<br> {<br> System.err.println("Kann mich nicht zum MySQL-Server verbinden.");<br> System.err.println(e.getMessage());<br> }<br> return conn;<br> }<br> <br> public static Connection connectToMDB(String mdbFilePath) { | |
- | + | Connection con = null; | |
- | } <br> <br>}<br><br> | + | try {<br> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br> con = DriverManager.getConnection(<br> "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="<br> + mdbFilePath, "", "");<br> //String myDB = "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:/test.xls;"<br> // + "DriverID=22;READONLY=false";<br> System.out.println("Verbindung zur MDB "+mdbFilePath+" hergestellt.");<br> } catch (Exception e) {<br> System.err.println("Fehler beim öffnen der MDB Datei.");<br> System.err.println(e.getMessage());<br> }<br> return con; |
- | + | } <br> <br>}<br><br> | |
- | <br> | + | <br> |
+ | |||
+ | [[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;
}
}