JDBC下各种数据库的连接字符串和驱动类一览
Author:lyore Date:2007-03-30 11:41
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
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
Tags:
jdbc