DBUtils（通用的数据库工具类）

package com.fsh.struts; import java.sql.*; import com.sun.org.apache.commons.collections.StaticBucketMap; public class DBUtils { public static Connection getConn() { //参数定义 String url ="jdbc:oracle:thin:@localhost:1521:fsh"; // 数据库地址 String user ="fsh"; // 数据库用户名 String password ="fsh"; // 数据库密码 Connection conn = null; //加载驱动 try { Class.forName("oracle.jdbc.driver.OracleDriver"); // 获得连接 conn = DriverManager.getConnection(url,user,password); } catch (ClassNotFoundException e) { e.printStackTrace(); System.out.println("驱动加载出错!"); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static void closeConn(Connection conn) { try { if(conn != null) { conn.close(); conn = null; } } catch (SQLException e) { e.printStackTrace(); } } public static void closeStmt(Statement stmt) { try { if(stmt != null) { stmt.close(); stmt = null; } } catch (SQLException e) { e.printStackTrace(); } } public static void closeRs(ResultSet rs) { try { if(rs != null) { rs.close(); rs = null; } } catch (SQLException e) { e.printStackTrace(); } } // 释放连接 public static void free(ResultSet rs, Statement st, Connection conn) { try { if (rs != null) { rs.close(); // 关闭结果集 } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (st != null) { st.close(); // 关闭Statement } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (conn != null) { conn.close(); // 关闭连接 } } catch (SQLException e) { e.printStackTrace(); } } } } }