DBConnection

package com.socialka.db;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {
    private final Connection connection;
    private static DBConnection instance;

    private static final String DB_HOST = "localhost";
    private static final String DB_USER = "root";
    private static final String DB_PASS = "MySqlRoot123";
    private static final String DB_PORT = "3306";
    private static final String DB_SCHEMA = "mysocialka";
    private static final String DB_OPTIONS = "autoReconnect=true&useSSL=false";

    private DBConnection() throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        this.connection = DriverManager.getConnection(
                String.format("jdbc:mysql://%s:%s/%s?%s", DB_HOST, DB_PORT, DB_SCHEMA, DB_OPTIONS), DB_USER, DB_PASS);

    }

    public static DBConnection getInstance() throws Exception {
        if (instance == null) {
            instance = new DBConnection();
        }
        return instance;
    }

    public Connection getConnection() {
        return connection;
    }

}