多种数据库的JDBC驱动及URL

驱动程序文件的位置

1， ORACLE:
[ORACLE_HOME]/jdbc/lib/classes12.zip
[ORACLE_HOME]/jdbc/lib/nls_charset12.zip

2,Ms SQLServer:

[SQL JDBC 驱动安装目录]/lib/msbase.jar
[SQL JDBC 驱动安装目录]/lib/msutil.jar
[SQL JDBC 驱动安装目录]/lib/mssqlserver.jar

3, IBM DB2 
[DB2_HOME]/sqllib/java/db2java.zip

4, SYBASE ASA
SYBASE安装目录/shared/jConnect-5_5/classes/jconn2.jar

---

驱动名和URL

1,Oracle:

Driver = oracle.jdbc.OracleDriver

          oracle.jdbc.driver.OracleDriver

URL = jdbc:oracle:thin:@hostname:1521:sid

       jdbc:oracle:oci8:sid

2,Microsoft SQLServer(http://www.microsoft.com/) :

Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

URL= jdbc:microsoft:sqlserver://hostname:1433;DatabaseName=database

Microsoft SQLServer(http://jtds.sourceforge.net):

Driver = net.sourceforge.jtds.jdbc.Driver

URL = jdbc:jtds:sqlserver://localhost:1433/DatabaseName

3,MySQL:

Driver = org.gjt.mm.mysql.Driver

URL= jdbc:mysql://hostname:3306/DatabaseName

4,IBM DB2:

Driver = com.ibm.db2.jdbc.app.DB2Driver.class

Driver  = Com.ibm.db2.jdbc.net.DB2Driver

URL = jdbc:db2://hostname:6789/DatabaseName

5,SYBASE ASA:

Driver = com.sybase.jdbc2.jdbc.SybDriver

URL= jdbc:sybase:Tds:hostname:2638

6,ODBC:

Driver = sun.jdbc.odbc.JdbcOdbcDriver

URL = jdbc:odbc:数据源名称

URL = jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db1.mdb (不使用ODBC数据源)

7,PostgreSQL:

Driver = org.postgresql.Driver

URL = jdbc:postgresql://localhost/DatabaseName