針對各資料庫的JDBC下載與使用

Microsoft SQL Server series (6.5, 7.x, 2000, 2005)
JDBC Name: jTDS
Version: 0.5.1
Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291

JDBC語法：
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password");






MS官方
JDBC Name: JDBC
Download URL:Microsoft SQL Server 2005 JDBC Driver 1.2SQL Server 2000 Driver for JDBC Service Pack 3

MS SQL 2000 的JDBC語法：
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://hostNameOrIP:1433;user=UserName;password=*****;database=databaseName");

MS SQL 2005 的JDBC語法：
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://hostNameOrIP:1433;user=UserName;password=*****;database=databaseName");





MySQL
JDBC Name: Connector/J 3.0
Version: 3.0.8-stable
Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html
JDBC語法：
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://host:port/database","user","password");





Oracle
JDBC Name: Connector/J 3.0
Version: 3.0.8-stable
Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html

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



[本文參考] http://www.javaworld.com.tw/jute/post/print?bid=21&id=366