前言:备忘
1. MySQL(mysql-connector-java-5.0.3.jar)
代码
- Class.forName("com.mysql.jdbc.Driver");
- Connection cn = DriverManager.getConnection("jdbc:mysql://MyDbComputerNameOrIP:3306/DatabaseName",user,password);
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
代码
- Class.forName( "org.postgresql.Driver" );
- cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
代码
- Class.forName( "oracle.jdbc.driver.OracleDriver" );
- cn = DriverManager.getConnection( "JdbcOracle:thin:@MyDbComputerNameOrIP:1521:DatabaseName", sUsr, sPwd );
4 Microsoft SQLServer(http://www.microsoft.com)
代码
- Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
- cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
5. ODBC
java 代码
代码
- Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
- Connection cn = DriverManager.getConnection( "jdbcdbc:" + sDsn, sUsr, sPwd );