当前位置:网站首页>Jar package, driver class name and URL format corresponding to various databases

Jar package, driver class name and URL format corresponding to various databases

2021-07-24 07:25:56 JavaPub

maven rely on jar Package download address :https://mvnrepository.com/

Reprint please indicate the source :https://blog.csdn.net/qq_40374604

Various jar Package download :http://www.java2s.com/Code/Jar/c/Downloadc3p0jar.htm

It can only be used for learning (:

mysql_jar link :https://pan.baidu.com/s/161Oc3gd9uBSMjND3hYcxCA password :w2f2(mysql-jar)

1.1.       Corresponding to various databases jar package

As follows :

Database type

Corresponding Jar file

Oracle 8i

classes12.zip or ojdbc14.jar

Sybase

jconn2.jar or jconn3.jar

Mysql

mysql-connector-java-3.1.1-alpha-bin.jar or

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

 

1.2.       Driver class names and corresponding to various databases URL Format

The following are the driver class names and... For various databases URL Summary in format . As shown in the table 3 Shown . among hostip representative ip Address ,dbname Representative database name .

database

Driver class name

URL Format

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>

版权声明
本文为[JavaPub]所创,转载请带上原文链接,感谢
https://chowdera.com/2021/06/20210621173622293y.html