sap mysql jdbc_各种数据库的jdbc驱动下载及连接方式

各种数据库驱动

数据库名称

下载地址

说明

Mysql

Shipped. But need to download the latest for MySQL 4.1 or higher.

SQL Server by jTDS

Included. Support Microsoft SQL Server (6.5, 7, 2000 and 2005)

SyBase by jTDS

Included. Support Sybase (10, 11, 12)

各种驱动的连接方法：

1. MySQL(http://www.mysql.com) mysql-connector-java-2.0.14-bin.jar ;

Class.forName( "org.gjt.mm.mysql.Driver" );

cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );

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(