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 existing version of the JDBC Driver using grammar and use grammar JDBC DRIVER.
