package com;

import java.util.logging.Level;
import java.util.logging.Logger;

public class Singleton {

    private static Singleton ourInstance;

    protected static final String BASE = "jdbc:mysql://localhost:3306/tan?characterEncoding=UTF8&useUnicode=true";
    protected static final String BASE_PASSWORD = "1234";
    protected static final String BASE_LOGIN = "root";
    protected static final String CLASS_FORNAME = "com.mysql.jdbc.Driver";

    public static Singleton getOurInstance() {
        if (ourInstance == null) {
            try {
                Class.forName(CLASS_FORNAME).newInstance();
                ourInstance = new Singleton();
            } catch (ClassNotFoundException | InstantiationException | IllegalAccessException ex) {
                Logger.getLogger(Singleton.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
        return ourInstance;
    }

    public static String getBASE() {
        return BASE;
    }

    public static String getBASE_PASSWORD() {
        return BASE_PASSWORD;
    }

    public static String getBASE_LOGIN() {
        return BASE_LOGIN;
    }

}

 try (Connection con = DriverManager.getConnection(Singleton.getBASE(), Singleton.getBASE_LOGIN(), Singleton.getBase_password());
                CallableStatement proc = con.prepareCall(".........");) {
            rs = proc.executeQuery();
            while (rs.next()) {
                
            }
        } catch (SQLException ex) {
            
        }