package fr.minefus.snyker.common.sql;

import fr.minefus.snyker.common.sql.table.MPlayer;

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

/**
 * Created by Arkas on 31/08/2016.
 * @author Snyker
 */
public class SQL {

    private Connection connection;
    public MPlayer mPlayer;
    private String urlbase, host, database, user, pass;

    public SQL(){
        this.urlbase = "jdbc:mysql://";
        this.host = "localhost";
        this.database = "minefus";
        this.user = "root";
        this.pass = "";
    }

    public void sqlConnection(){
        if(!isConnected())
            try {
                connection = DriverManager.getConnection(urlbase + host + "/" + database, user, pass);
                System.out.println("Connexion a la base de donne etabli");
            } catch (SQLException e) {
                e.printStackTrace();
            }
    }

    public void sqlDeconnection(){
        if(isConnected())
            try {
                connection.close();
            } catch (SQLException e) {
                System.err.println("Erreur dans la base de donnee");
                e.printStackTrace();
            }
    }

    public boolean isConnected(){
        return connection != null;
    }

    public Connection getConnection(){
        return connection;
    }

}