[MySQL 03] Jar packages, driver class names and URL formats corresponding to various databases

1. Jar packages corresponding to various databases

Database type	Corresponding Jar files
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

2. Driver class names and URL formats corresponding to various databases

##DB2 com.ibm.db2.jcc.DB2Driverjdbc:db2://hostip:50000/dbnameInformixcom.informix.jdbc .IfxDriverjdbc:informix-sqli://hostip:port/dbname:informixserver=

Database	Drive 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=GB
SQLServer 2000	com.microsoft.jdbc.sqlserver.SQLServerDriver	jdbc:microsoft:sqlserver://hostip:1433;Databas
SQLServer 2005	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:sqlserver://hostip:1433;DatabaseName=d
SQLServer 7.0	net.sourceforge.jtds.jdbc.Driver	jdbc:jtds:sqlserver://hostip:1433/dbname

The above is [MySQL 03] various The contents of the jar package, driver class name and URL format corresponding to the database. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!