DriverManager 类

方法/属性	描述
Connection getConnection(String connstr)	创建 Connection 对象

示例：连接 ACCESS

String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\www\\jspbook\\data\\guestbook.mdb"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = java.sql.DriverManager.getConnection(url);

示例：连接 ORACLE

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "scott"; String password = "tiger"; Connection conn = DriverManager.getConnection(url,user,password);

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql = "select * from test"; ResultSet rs = stmt.executeQuery(sql);

示例：连接 SQLServer

String url = "jdbc:sqlserver://localhost:1433;databasename=pubs"; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con = java.sql.DriverManager.getConnection(url);