Java通過JDBC操作ORACLE數據庫工具類

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

}  </pre>