java操作ORACLE数据库工具类（JDBC）

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

何愁没有快乐的泉溪在歌唱，何愁没有快乐的鲜花绽放！