类名 | java.sql.DriverManager
| |
说明 | 此类是实现JDBC连接数据的连结之一,在JDBC2.0开始推荐用DataSource来进行连接,此类都是静态方法,通过getConnection等方法获取对数据库的连接。此类还实现的功能有:设定连接日志,设定边接超时。在jdbc4中。不需要通过Class.for(“驱动路径”)来加载驱动了。但是驱动包的META-INF/services/java.sql.Driver file would contain the entry。在这个文档中包含如下指令内容:数据库驱动路径名。建议用数据源对象来接数据库 | |
序号 | 常用方法 | 使用说明 |
1. | public static Connection getConnection(String url, String user, String password) throws SQLException | 输入URL、用户名、密码等信息得到数据库连接 Connection conn = DriverManager.getConnection(URL, user, password); |
2. | public static void setLoginTimeout(int seconds) | 设定登录超时 |
3. | DriverManager.println("读取结果集"); | 打印连结日志 |
4. | DriverManager.setLogWriter(printwriter) | 设定输出日志目的地PrintWriter printwriter = new PrintWriter(new FileOutputStream( "./www.txt",true)); DriverManager.setLogWriter(printwriter); |
示例:
public class JDBCLogDemo {
/**
* {方法的功能/动作描述}
*
* @param {引入参数名} {引入参数说明}
* @return {返回参数名} {返回参数说明}
* @throws FileNotFoundException
* @exception {说明在某情况下,将发生什么异常}
*/
public static void main(String[] args) throws FileNotFoundException {
String driverPath = "oracle.jdbc.driver.OracleDriver";
String URL = "jdbc:oracle:thin:@localhost:1521:maximo";
String password = "java";
String user = "java";
try {
PrintWriter printwriter = new PrintWriter(new FileOutputStream(
"./www.txt",true));
DriverManager.setLogWriter(printwriter);
Class.forName(driverPath);
Connection conn = DriverManager.getConnection(URL, user, password);
Statement statement = conn.createStatement();
ResultSet resultSet = statement
.executeQuery("select * from person");
while (resultSet.next()) {
DriverManager.println("读取结果集");
System.out.println(resultSet.getString(1));
}
printwriter.close();
statement.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
}
}
}
评论