package td3.exercice4.bdd;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.*;
import java.util.Properties;

public class ConnexionMySQL {

    //-----------------------------------------------------------------------------[SINGLETON]
    private static ConnexionMySQL instance;
    private Connection connexion;

    private ConnexionMySQL(){
        setConnexion(this.creeConnexion());
    }

    public static ConnexionMySQL getInstance(){

        if( instance == null){
            instance = new ConnexionMySQL();
        }
        return instance;

    }

    public Connection creeConnexion(){

        /*String url = "jdbc:mysql://localhost:8000/moniez1u_bddJava";

        String login = "moniez1u_appli";
        String pwd = "31016843";
        Connection maConnexion = null;

        try {
            maConnexion = DriverManager.getConnection(url, login, pwd);
        } catch (SQLException sqle) {
            System.out.println("Erreur connexion" + sqle.getMessage());
        }

        return maConnexion;*/

        Connection maConnexion = null;
        Properties accesBdd = new Properties();
        File fichierBdd = new File("src/td3/exercice4/bdd/infoConnexionMySQL.xml");

        try{
            FileInputStream source = new FileInputStream(fichierBdd);
            accesBdd.loadFromXML(source);
        }catch (IOException ioe){
            ioe.printStackTrace();
        }

        try {
            String url = accesBdd.getProperty("api")+":"+accesBdd.getProperty("type")+"://"+ accesBdd.getProperty("adresse_ip")+":"+accesBdd.getProperty("port")+"/"+accesBdd.getProperty("bdd");
            maConnexion = DriverManager.getConnection(url, accesBdd.getProperty("login"), accesBdd.getProperty("pass"));
            return maConnexion;

        } catch (SQLException sqle) {
            System.out.println("Erreur connexion" + sqle.getMessage());
        }

        return null;
    }

    //-----------------------------------------------------------------------------[GET/SET]
    public Connection getConnexion() {
        return connexion;
    }

    public void setConnexion(Connection connexion) {

        if(connexion != null){
            this.connexion = connexion;
        }

    }
}