JDBC工具类：JDBCUtils和配置文件

配置文件：jdbc.properties

url=jdbc:mysql:///jdbc_demo
username=root
password=root
driver=com.mysql.jdbc.Driver

工具类：JDBCUtils

/**
 * JDBC的工具类
 */
public class JDBCUtils {
    private static String url;
    private static String username;
    private static String password;

    /*
     * 创建静态代码块
     * 类被调用时自动执行一次静态代码块，加载配置文件中的数据，并注册驱动
     */
    static {
    	//创建properties对象
        Properties pro = new Properties();
        //使用类加载器获取jdbc.properties文件的路径
        String path = JDBCUtils.class.getClassLoader().getResource("jdbc.properties").getPath();
        try {
        	//加载jdbc.properties文件
            pro.load(new FileReader(path));
            //根据键获取值
            url = pro.getProperty("url");
            username = pro.getProperty("username");
            password = pro.getProperty("password");
            String driver = pro.getProperty("driver");
            //注册驱动
            Class.forName(driver);
        } catch (IOException | ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    /**
     * 把从静态代码块拿到的数据传入DriverManager的getConnection方法并返回
     *
     * @return Connection接口对象
     * @throws SQLException sql异常
     */
    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url, username, password);
    }

    /**
     * 释放资源方法
     *
     * @param stmt Statement
     * @param conn Connection
     */
    public static void close(Statement stmt, Connection conn) {

        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * 释放资源方法
     *
     * @param rs   ResultSet
     * @param stmt Statement
     * @param conn Connection
     */
    public static void close(ResultSet rs, Statement stmt, Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}