【MySQL 03】各种数据库对应的jar包、驱动类名和URL格式

最新推荐文章于 2024-06-29 14:33:08 发布

小松悦读会 | kevinelstri

最新推荐文章于 2024-06-29 14:33:08 发布

阅读量3.3k

点赞数 2

分类专栏： MySQL MySQL路线文章标签：数据库

本文链接：https://blog.csdn.net/kevinelstri/article/details/52373653

版权

MySQL 同时被 2 个专栏收录

16 篇文章 0 订阅

订阅专栏

MySQL路线

15 篇文章 7 订阅

订阅专栏

                    
                        
                    
                    1、各种数据库对应的jar包 
数据库类型对应的Jar文件
Oracle 8iclasses12.zip 或 ojdbc14.jar
Sybasejconn2.jar 或 jconn3.jar
Mysqlmysql-connector-java-3.1.1-alpha-bin.jar 或 mysql-connector-java-5.0.2-beta-bin.jar
SQLServer 2000msbase.jar、msutil.jar、mssqlserver.jar
SQLServer 2005sqljdbc.jar
SQLServer 7.0jtds-1.2.2.jar
Informixifxjdbc.jar
DB2db2jcc.jar、db2jcc_license_cu.jar
 
2、各种数据库对应的驱动类名和URL格式 
数据库驱动类名URL格式
Oracleoracle.jdbc.driver.OracleDriverjdbc:oracle:thin:@hostip:1521:dbname
Sybasecom.sybase.jdbc2.jdbc.SybDriverjdbc:sybase:Tds:hostip:4100/dbname
Mysqlcom.mysql.jdbc.Driverjdbc:mysql://hostip:3306/dbname?useUnicode=true&amp;characterEncoding=GBK
SQLServer 2000com.microsoft.jdbc.sqlserver.SQLServerDriverjdbc:microsoft:sqlserver://hostip:1433;DatabaseName=dbname
SQLServer 2005com.microsoft.sqlserver.jdbc.SQLServerDriverjdbc:sqlserver://hostip:1433;DatabaseName=dbname
SQLServer 7.0net.sourceforge.jtds.jdbc.Driverjdbc:jtds:sqlserver://hostip:1433/dbname
DB2com.ibm.db2.jcc.DB2Driverjdbc:db2://hostip:50000/dbname
Informixcom.informix.jdbc.IfxDriverjdbc:informix-sqli://hostip:port/dbname:informixserver=<dbservername>

                

数据库类型	对应的Jar文件
Oracle 8i	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
SQLServer 2000	msbase.jar、msutil.jar、mssqlserver.jar
SQLServer 2005	sqljdbc.jar
SQLServer 7.0	jtds-1.2.2.jar
Informix	ifxjdbc.jar
DB2	db2jcc.jar、db2jcc_license_cu.jar

数据库	驱动类名	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>`