java连接oracle数据库的方法

来源：互联网发布：淘宝怎么开直播间编辑：程序博客网时间：2024/06/07 05:35

package com.dragon.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
* 数据库访问类
* @author Administrator
*
*/
public class BaseDao {
/**
* 创建驱动加载字符串
*/
private String className="oracle.jdbc.driver.OracleDriver";
/**
* 创建连接地址
*/
private String url = "jdbc:oracle:thin:@localhost:1521:orcl";
/**
* 创建用户
*/
private String user = "system";
/**
* 创建密码
*/
private String password = "orcl";
/**
* 创建连接对象
*/
protected Connection connection =null;
/**
* 创建执行sql语句命令对象
*/
protected PreparedStatement preparedStatement = null;
/**
* 创建结果集
*/
protected ResultSet resultSet = null;
/**
* 获得连接的方法
* @return 返回连接对象
*/
protected Connection openConnection(){
  try {
   //加载驱动
   Class.forName(className);
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  //获得连接
  try {
   this.connection = DriverManager.getConnection(url, user, password);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return this.connection;
}
/**
* 关闭连接的方法
*/
protected void closeConnection(){
  //关闭结果集
  if(this.resultSet != null){
   try {
    this.resultSet.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  //关闭执行sql语句命令对象
  if(this.preparedStatement!= null){
   try {
    this.preparedStatement.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  //关闭连接对象
  if(this.connection != null){
   try {
    this.connection.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
}
}

http://blog.163.com/xiao_long/blog/static/217651174201321441346395