反射应用场景DBUtils

Driver=com.mysql.jdbc.Driver
URL=jdbc:mysql://127.0.0.1:3306/数据库名
USER=root
PWD=

package com.sw.zy.utils;

import com.sun.scenario.effect.impl.sw.sse.SSEBlend_SRC_OUTPeer;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DBUtils {
    static Properties properties = new Properties();
    private static String DRIVER;
    private static String URL;
    private static String USER;
    private static String PWD;

    static {//配置 并且 加载驱动

        String path="jdbc.properties";
        InputStream is=DBUtils.class.getClassLoader().getResourceAsStream(path);
        try {
            properties.load(is);

            //将jdbc.properties的值赋给本类中的对应属性
            DRIVER = properties.getProperty("DRIVER");
            URL = properties.getProperty("URL");
            USER = properties.getProperty("USER");
            PWD = properties.getProperty("PWD");

            Class.forName(DRIVER);//加载驱动

        } catch (IOException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        System.out.println("DRIVER:"+DRIVER+"\tURL:"+URL+"\tUSER:"+USER+"\tPWD:"+PWD);
        getConnection();
    }

    public static Connection getConnection() {

        try {
            return DriverManager.getConnection(URL,USER,PWD);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;

    }
}