2.Jdbc工具

JdbcUtil.java
1.package com.billows.util;   
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.  
9./**  
10. * @author Billows.Van haidii@126.com  
11. * @version 创建时间：2008-4-30 上午10:53:09 类说明  
12. */  
13.public class JdbcUtil {   
14.    static {   
15.        try {   
16.            EnvironmentConfig ec=EnvironmentConfig.getInstance();   
17.            String driverClassName=ec.getPropertyValue("/config/jdbc.properties", "jdbc.driverClassName");   
18.            Class.forName(driverClassName);   
19.        } catch (ClassNotFoundException e) {   
20.            e.printStackTrace();   
21.        }   
22.    }   
23.  
24.    public static Connection getConnection() throws SQLException {   
25.        Connection conn = null;   
26.        EnvironmentConfig ec=EnvironmentConfig.getInstance();   
27.        String url=ec.getPropertyValue("/config/jdbc.properties", "jdbc.url");   
28.        String name=ec.getPropertyValue("/config/jdbc.properties", "jdbc.username");   
29.        String pwd=ec.getPropertyValue("/config/jdbc.properties", "jdbc.password");   
30.        conn = DriverManager.getConnection(url, name, pwd);   
31.        return conn;   
32.    }   
33.  
34.    public static void release(Connection conn, PreparedStatement ps,ResultSet rs) {   
35.        if (rs != null)try {rs.close();} catch (SQLException e) {e.printStackTrace();}   
36.        if (ps != null) try {ps.close();} catch (SQLException e) {e.printStackTrace();}   
37.        if (conn!= null)try {conn.close();} catch (SQLException e) {e.printStackTrace();}   
38.    }   
39.  
40.    public static void release(Object obj) {   
41.        if (obj instanceof Connection) {   
42.            Connection conn = (Connection) obj;   
43.            if (conn != null)   
44.                try {   
45.                    conn.close();   
46.                } catch (SQLException e) {   
47.                    e.printStackTrace();   
48.                }   
49.        }   
50.        if (obj instanceof PreparedStatement) {   
51.            PreparedStatement ps = (PreparedStatement) obj;   
52.            if (ps != null)   
53.                try {   
54.                    ps.close();   
55.                } catch (SQLException e) {   
56.                    e.printStackTrace();   
57.                }   
58.        }   
59.        if (obj instanceof ResultSet) {   
60.            ResultSet rs = (ResultSet) obj;   
61.            if (rs != null)   
62.                try {   
63.                    rs.close();   
64.                } catch (SQLException e) {   
65.                    e.printStackTrace();   
66.                }   
67.        }   
68.    }   
69.}