JDBCutil

package com.usc.utils;

import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

public class JdbcUtils {
    private static String driver;
    private static String url;
    private static String username;
    private static String password;
    private static String sql;
    static {
        try {
            // 配置文件
             InputStream resourceAsStream = JdbcUtils.class.getClassLoader().getResourceAsStream("db.properties");
             Properties properties = new Properties();
             properties.load(resourceAsStream);

             // 获取数据
             username = properties.getProperty("username");
             url = properties.getProperty("url");
             password = properties.getProperty("password");
             driver = properties.getProperty("driver");

            try {
                Class.forName(driver);
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }


        }
        catch (IOException e){
            System.out.println(e);

        }
    }
    // 获取连接
    public static Connection getConnection() throws SQLException {

        Connection connection = DriverManager.getConnection(url,username,password);
        return connection;
    }
    // 释放资源
    public static void release(Connection connection, Statement statement, ResultSet resultSet) throws SQLException {
        if(resultSet != null){
            resultSet.close();
        }
        if(statement != null){
            statement.close();
        }
        if(connection != null){
            connection.close();
        }

    }
    public static int information(){
        System.out.println("hello world");
    }
}