数据库包
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");
页:
[1]