JDBC下各种数据库的连接字符串和驱动类一览

 

DB2 v8:
jdbc:db2://host/dbName
COM.ibm.db2.jdbc.net.DB2Driver

DB2 v9
jdbc:db2://host/dbName:deferPrepares=false;
com.ibm.db2.jcc.DB2Driver

Informix:
jdbc:informix-sqli://host/dbName:INFORMIXSERVER=server
com.informix.jdbc.IfxDriver

SQLServer:
jdbc:sqlserver://host;DatabaseName=dbName
com.microsoft.jdbc.sqlserver.SQLServerDriver

MySQL：
jdbc:mysql://host/dbName?useUnicode=true&characterEncoding=GBK
com.mysql.jdbc.Driver

Oracle：
jdbc:oracle:thin:@host:dbName
oracle.jdbc.driver.OracleDriver

Sybase：
jdbc:sybase:Tds:host/dbName
com.sybase.jdbc2.jdbc.SybDriver

Teradata:
jdbc:teradata://host/dbName
com.ncr.teradata.TeraDriver