JDBC工具类

package com.cn.utils;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * JDBC工具类
 * 
 * @author15  */
public class JDBCUtils {
    static Properties prp = null;
    static {
        // 读取JDBC.properties属性文件
        // 创建Properties属性对象
        prp = new Properties();
        InputStream inStream = JDBCUtils.class.getResourceAsStream("/JDBC.properties");
        try {
            prp.load(inStream);
            // 驱动的class类对象 驱动的注册 driverClassName 驱动名称
            Class.forName(prp.getProperty("driverClassName"));
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    // 获取连接的方法
    public static Connection getConnection() throws SQLException {
        // 获取到Connection对象
        return DriverManager.getConnection(prp.getProperty("url"), prp.getProperty("user"),
                prp.getProperty("password"));
    }

    // 关闭资源 ：ResultSet Connection Statement
    public static void close(ResultSet rs, Connection conn, Statement st) {
        try {
            if (rs != null) {
                rs.close();
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        try {
            if (conn != null) {
                conn.close();
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        try {
            if (st != null) {
                st.close();
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}