各种数据库对应的jar包:
数据库类型 | 对应jar包 |
---|---|
Oracle8i | classes12.zip或ojdbc14.jar |
Sybase | jconn2.jar 或 jconn3.jar |
Mysql | mysql-connector-java-3.1.1-alpha-bin.jar 或mysql-connector-java-5.0.2-beta-bin.jar |
SQLServer2000 | msbase.jar、msutil.jar、mssqlserver.jar |
SQLServer2005 | sqljdbc.jar |
SQLServer7.0 | jtds-1.2.2.jar |
Infomix | ifxjdbc.jar |
DB2 | db2jcc.jar、db2jcc_license_cu.jar |
Postgresql | postgresql-9.4-1201.jdbc41.jar |
各种数据库对应的驱动类名和URL格式:
数据库 | 驱动类名 | URL格式 |
---|---|---|
Oracle | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@hostip:1521:dbname |
Sybase | com.sybase.jdbc2.jdbc.SybDriver | jdbc:sybase:Tds:hostip:4100/dbname |
Mysql | com.mysql.jdbc.Driver | jdbc:mysql://hostip:3306/dbname?useUnicode=true&characterEncoding=GBK |
SQLServer 2000 | com.microsoft.jdbc.sqlserver.SQLServerDriver | jdbc:microsoft:sqlserver://hostip:1433;DatabaseName=dbname |
SQLServer 2005 | com.microsoft.sqlserver.jdbc.SQLServerDriver | jdbc:sqlserver://hostip:1433;DatabaseName=dbname |
SQLServer 7.0 | net.sourceforge.jtds.jdbc.Driver | jdbc:jtds:sqlserver://hostip:1433/dbname |
DB2 | com.ibm.db2.jcc.DB2Driver | jdbc:db2://hostip:50000/dbname |
Informix | com.informix.jdbc.IfxDriver | jdbc:informix-sqli://hostip:port/dbname:informixserver=<dbservername> |
PostgreSQL | org.postgresql.Driver | jdbc:postgresql://hostip:5432/dbname |
其它的就不搬了,有上面两个就够了,转自:
http://www.360doc.com/content/14/0310/15/15774578_359302225.shtml