Java 获取mysql连接工具类

Spark还是平时经常会使用到mysql去读取一些配置信息，所以整理一个工具类获取或者关闭mysql的连接。

1、首先编写配置文件

db.properties：

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

2、编写工具类：

package utils;

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

//连接mysql工具类
public class JdbcUtils {
    public static String DRIVERNAME = null;
    public static String URL = null;
    public static String USER = null;
    public static String PASSWORD = null;

    public static Connection conn = null;

    static {
        try {
            Properties props = new Properties();
            InputStream in = JdbcUtils.class.getClassLoader().getResourceAsStream("db.properties");
            props.load(in);

            DRIVERNAME = props.getProperty("driver");
            URL = props.getProperty("url");
            USER = props.getProperty("username");
            PASSWORD = props.getProperty("password");
        }catch (Exception e){
            throw  new RuntimeException(e);
        }
    }

    //获取连接
    public static Connection getConnection() throws Exception{
        if (conn != null){
            return conn;
        }
        //注册驱动
        Class.forName(DRIVERNAME);
        conn = DriverManager.getConnection(URL, USER, PASSWORD);
        return conn;
    }

    //关闭连接
    public static void closeResource(Connection conn, PreparedStatement st) throws SQLException {
        st.close();
        conn.close();
    }

    public static void closeResource(Connection conn, ResultSet rs, PreparedStatement st) throws SQLException{
        st.close();
        rs.close();
        conn.close();
    }
}