1 package cn.com.db; 2 3 import java.sql.Connection; 4 import java.sql.DriverManager; 5 import java.sql.PreparedStatement; 6 import java.sql.ResultSet; 7 import java.sql.SQLException; 8 import java.util.Properties; 9 10 public class DBUtil { 11 12 13 //获得连接方法 14 public Connection getConn() { 15 Connection conn = null; 16 try { 17 18 Class.forName("oracle.jdbc.driver.OracleDriver"); 19 conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger"); 20 } catch (ClassNotFoundException e) { 21 // TODO Auto-generated catch block 22 e.printStackTrace(); 23 }catch (SQLException e) { 24 // TODO Auto-generated catch block 25 e.printStackTrace(); 26 } 27 28 return conn; 29 } 30 31 //释放资源 32 public void free(ResultSet rs,PreparedStatement pstm,Connection conn) { 33 if(rs != null) { 34 try { 35 rs.close(); 36 } catch (SQLException e) { 37 // TODO Auto-generated catch block 38 e.printStackTrace(); 39 } 40 } 41 if(pstm != null) { 42 try { 43 pstm.close(); 44 } catch (SQLException e) { 45 // TODO Auto-generated catch block 46 e.printStackTrace(); 47 } 48 } 49 if(conn != null) { 50 try { 51 conn.close(); 52 } catch (SQLException e) { 53 // TODO Auto-generated catch block 54 e.printStackTrace(); 55 } 56 } 57 } 58 59 public void free(PreparedStatement pstm,Connection conn) { 60 if(pstm != null) { 61 try { 62 pstm.close(); 63 } catch (SQLException e) { 64 // TODO Auto-generated catch block 65 e.printStackTrace(); 66 } 67 } 68 if(conn != null) { 69 try { 70 conn.close(); 71 } catch (SQLException e) { 72 // TODO Auto-generated catch block 73 e.printStackTrace(); 74 } 75 } 76 } 77 }