Java通过JDBC操作ORACLE数据库工具类，jdbcoracle, package

Java通过JDBC操作ORACLE数据库工具类，jdbcoracle, package

    package com.util;      import java.sql.Connection;      import java.sql.DriverManager;      import java.sql.PreparedStatement;      import java.sql.ResultSet;      import java.sql.SQLException;      /**      *        * 2015-3-5下午2:45:56      *      *MusicWeb.util.DBUtil      *连接数据库 类      */      public class DBUtil {              private static String driver = "oracle.jdbc.driver.OracleDriver";              private String url = "jdbc:oracle:thin:@localhost:1521:orcl";              private String user = "XXX";//oracle数据库的用户名              private String pwd = "XXXXXX";//oracle数据库的用户密码              private PreparedStatement sta = null;              private ResultSet rs = null;              private Connection conn = null;              /**              * 加载驱动程序              */              static {                  try {                      Class.forName(driver);                  } catch (ClassNotFoundException e) {                      e.printStackTrace();                  }              }              /**              * @return 连接对象              */              public Connection getConn() {                  try {                      conn = DriverManager.getConnection(url, user, pwd);                  } catch (SQLException e) {                      e.printStackTrace();                  }                  return conn;              }              /**              * @param sql              *            sql语句  增加，删除，修改              * @param obj              *            参数              * @return              */              public int update(String sql, Object... obj) {                  int count = 0;                  conn = getConn();                  try {                      sta = conn.prepareStatement(sql);                      if (obj != null) {                          for (int i = 0; i < obj.length; i++) {                              sta.setObject(i + 1, obj[i]);                          }                      }                      count = sta.executeUpdate();                  } catch (SQLException e) {                      e.printStackTrace();                  } finally{                      close();                  }                  return count;              }              /**              * @param sql sql语句              * @param obj 参数              * @return 数据集合              */              public ResultSet Query(String sql,Object...obj){                  conn=getConn();                  try {                      sta=conn.prepareStatement(sql);                      if(obj!=null){                          for(int i=0;i<obj.length;i++){                              sta.setObject(i+1, obj[i]);                          }                      }                      rs=sta.executeQuery();                  } catch (SQLException e) {                      e.printStackTrace();                  }                  return rs;              }              /**              * 关闭资源              */              public void close() {                  try {                      if (rs != null) {                          rs.close();                      }                  } catch (SQLException e) {                      e.printStackTrace();                  } finally {                      try {                          if (sta != null) {                              sta.close();                          }                      } catch (SQLException e2) {                          e2.printStackTrace();                      } finally {                          if (conn != null) {                              try {                                  conn.close();                              } catch (SQLException e) {                                  e.printStackTrace();                              }                          }                      }                  }              }      }