Sqlserver2000
*msbase.jar
*mssqlserver.jar
*msutil.jar
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=mydb","sa","");
sqlserver2005
*sqljdbc.jar
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=mydb","sa","****");
MySQL
*mysql-connector-java-3.1.13-bin.jar
Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mydb","root","****");
Oracle
*classes12.jar
Class.forName("oracle.jdbc.driver.OracleDriver");
注:一般用第一种
1.DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORACLE9I","scott","tiger");
2.DriverManager.getConnection("jdbc:oracle:oci8:@ORACLE9I","scott","tiger");
DB2
*db2java.zip
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
DriverManager.getConnection(url,"db2admin","db2admin");