Orcal的JDBC数据连接方式

 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 }