java oracle dao_java中连接oracle的baseDao

package com.org.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.*;

public class BaseDao {

static final String DRIVER = "oracle.jdbc.driver.OracleDriver";

static final String URL = "jdbc:oracle:thin:@localhost:1521:SJBITDB";

static final String USER = "pet";

static final String PASSWORD = "pet";

/**

* 返回connection 连接

*

* @return

*/

private Connection getConnection() {

try {

Class.forName(DRIVER);

return DriverManager.getConnection(URL, USER, PASSWORD);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return null;

}

/**  * 执行增，删，改  *   * @return  */   protected  int ExecuteUpdate(String sql, Object... pramas) {   Connection connection=null;   PreparedStatement statement=null;      try {    connection=getConnection();    statement=connection.prepareStatement(sql);    if(pramas!=null && pramas.length>0){     for (int i = 0; i < pramas.length; i++) {      statement.setObject(i+1, pramas[i]);      }    }    return statement.executeUpdate();   } catch (SQLException e) {    // TODO Auto-generated catch block    e.printStackTrace();   }finally{    closeSource(null, statement, connection);   }  return 0; }   /**    *  关闭连接 释放资源    * @param resultSet    * @param statement    * @param connection    */   public void closeSource(ResultSet resultSet,Statement statement,Connection connection){   try {   if(resultSet!=null){resultSet.close();}     if(statement!=null){statement.close();}    if(connection!=null){connection.close();}  } catch (SQLException e) {   // TODO Auto-generated catch block   e.printStackTrace();  }   }    /**  *   * 执行 查询  *   * @return  */ public ResultSet ExecuteQuery(String sql, Object... pramas) {  ResultSet resultSet=null;  PreparedStatement statement=null;  Connection connection=null;    try {   connection=getConnection();   statement=connection.prepareStatement(sql);   if(pramas!=null && pramas.length>0){    for (int i = 0; i < pramas.length; i++) {     statement.setObject(i+1, pramas[i]);    }   }   return statement.executeQuery();  } catch (SQLException e) {   // TODO Auto-generated catch block   e.printStackTrace();  }  return null; }}