1、Oracle
Class.forName("oracle.jdbc.driver.OracleDriver");
String vurl = "jdbc:oracle:thin:@localhost:1521:dbName";
2、SQL Server2000
第一种方式:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String vurl = "jdbc:microsoft:sqlserver://localhost:1433;databaseName=walker";
DriverManager.getConnection(vurl,"sa","");
第二种方式: 通过数据源
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String vurl = "jdbc:odbc:dbSourceName";
SQL Server2005直连
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String vurl = "jdbc:sqlserver://数据库实例名:1433;databaseName=数据库";
DriverManager.getConnection(vurl,"sa","");
3、MySQL
Class.forName("com.mysql.jdbc.Driver");//
String vurl = "jdbc:mysql://localhost/dbName";
4、 Access
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String vurl = "jdbc:odbc:datasourceName";
// con = DriverManager.getConnection("jdbc:mysql://localhost/test");//"jdbc:odbc:dsn"
//Connection conn = DriverManager.getConnection(vurl,"","");
//Connection conn =
5、数据源DataSource
Context ctx = new InitialContext();
ds = (javax.sql.DataSource) ctx.lookup("MyDataSource");
con = ds.getConnection();