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;
 }
}