In view of many editions to find JDBC Driver or how to use Driver often ask, I will simply organize representative Driver and use ways. Microsoft SQL Server Series (6.5, 7.x and 2000) and Sybase 10JDBC Name: JTDSURL: http://jtds.sourceforge.net/Version:
0.5.1
Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291 Syntax:
Class.Forname ("Net.SourceForge.jtds.jdbc.driver"); connection con = drivermanager.getConnection ("JDBC: JTDS: SQLServer: // Host: Port / Database", "User", "Password"); Orconnection Con = DriverManager.getConnection ("JDBC: JTDS: Sybase: // Host: Port / Database", "User", "Password");
MySQLJDBC Name: Connector / J 3.0URL: http://www.mysql.com/Version:
3.0.8
-stabledownload URL: http://www.mysql.com/downloads/api-jdbc-stable.html Syntax:
Class.Forname ("com.mysql.jdbc.driver); Connection Con = DriverManager.getConnection (" JDBC: MySQL: // Host: Port / Database "," User "," Password ");
OracleJDBC Name: Connector / J 3.0URL: http://otn.roacle.com/Version:
3.0.8
-stabledownload URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html Syntax:
Class.Forname ("Oracle.jdbc.driver.OracleDriver"); Connection Con = DriverManager.getConnection ("JDBC: Oracle: Thin: @Host: Port: Database", "User", "password");
SybaseDriver: JConnect 4.5 / 5.5 (JDBC 2.0 Please use 5.5) syntax:
Class.Forname ("com.sybase.jdbc2.jdbc.sybdriver"). NewInstance (); DriverManager.getConnection ("JDBC: Sybase: TDS: IP Address: 2638? Services =" Database Name, "Account", "Password ");
Postgresqljdbc name: postgreSQL JDBCURL: http://jdbc.postgreSQL.org/Version:
7.3.3
Build 110Download URL: http://jdbc.postgreSQL.org/download.html Syntax:
Class.Forname ("org.postgreSql.driver); connection con = drivermanager.getConnection (" JDBC: PostgreSQL: // Host: Port / Database "," User "," password "); IBM AS400 host is in JDBC The syntax has a V4R4 or more version of the client access express can find the Driver file JT400.zip in C: / Program Files / IBM / Client Access / JT400 / lib, and change the extension to become JT400.jar syntax
Java.sql.drivermanager.registerdriver (new com.ibm.as400.access.as400jdbcdriver ()); class.forname ("com.ibm.as400.access.as400jdbcconnection"); con = DriverManager.getConnection ("JDBC: AS400: // ip "," user "," password ");
The current version of each JDBC Driver and the existing version of JDBC Driver using grammar and the existing version of JDBC Driver, using grammar, and existing version of JDBC Driver, using grammatical, existing JDBC Driver, and use syntax Current versions and syntax of JDBC Driver
