JDBC Driver写法!

Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10

JDBC Name: jTDS
URL:
Version: office:smarttags" />

语法:office:" />or
Connection con = DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");

MySQL

JDBC Name: Connector/J 3.0
URL: .com/" target=_blank>
Version: 3.0.8-stable
Download URL: .com/downloads/api-jdbc-stable.html" target=_blank>downloads/api-jdbc-stable.html

语法:

Class.forName("com.my.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:my://host:port/database","user","password");

Oracle

JDBC Name: Connector/J 3.0
URL:
Version: 3.0.8-stable
Download URL: /j_jdbc/content.html" target=_blank>

语法:

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");

Sybase

Driver: (JDBC 2.0 请使用5.5)

语法:

Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
DriverManager.getConnection("jdbc:sybase:Tds:IP地址:2638?ServiceName="+名称,"账号","密码");

Postgre

JDBC Name: PostgreSQL JDBC
URL: .org/" target=_blank>
Version: 7.3.3 build 110
Download URL: .org/download.html" target=_blank>download.html

语法:

Class.forName("org.postgre.Driver");
Connection con=DriverManager.getConnection("jdbc:postgre://host:port/database","user","password");

AS400主机在用的JDBC语法

有装V4R4以上版本的Client Access Express
可以在C:\Program Files\\Client Access\jt400\lib
找到 driver 档案 jt400.zip，并更改扩展名成为 jt400.jar

语法

..DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ());
Class.forName("com.ibm.as400.access.AS400JDBCConnection");
con = DriverManager.getConnection("jdbc:as400://IP","user","password");