package br.com.ConexaoBanco;

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

public class ConexaoMySQL {

    private static String usuario="root@localhost";
    private static String senha="naosei123";
    private static String banco="test";
    private static String ip="localhost:3306";
    private static String driver="com.mysql.cj.jdbc.Driver";
    private static Connection conexao = null;

    //padrao singleton

    public static Connection getConnection() {
        System.out.println(">>Conectando ao banco");
        try {
            Class.forName(driver);
          //  return DriverManager.getConnection ("jdbc:mysql//localhost:3306/test","root","naosei123"); } }


            if(conexao==null || conexao.isClosed()){
                conexao=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","naosei123");
            }



            return conexao;
        }catch (ClassNotFoundException e) {
            System.out.println("da");
            throw new RuntimeException(e);
        }catch (SQLException e) {

            closeConnection();
            throw new RuntimeException(e);
        }

    }

    public static void closeConnection(){
        try{
            if(conexao!=null && !conexao.isClosed()){
                conexao.close();
                System.out.println(">>Conexao encerrada com sucesso");
            }
        }catch (Exception e) {
            e.printStackTrace();
        }
    }



    public static void main(String[] args) {
        System.out.println("conexao: "+getConnection());
        System.out.println("conexao: "+getConnection());
        System.out.println("conexao: "+getConnection());
    }

}