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 }
