package fr.destinycore.faction.manager;


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

public class SqlConnection {

	private Connection connection;
	private String urlbase,host,database,user,password;

	public SqlConnection(String urlbase, String host, String database, String user, String password) {
        this.urlbase = urlbase;
        this.host = host;
        this.database = database;
        this.user = user;
        this.password = password;
	}

    public void connection(){
        if(!isConnected()){
            try {
                connection = DriverManager.getConnection(urlbase + host + "/" + database, user, password);
                System.out.println("connected ok");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public void disconnect(){
        if(isConnected()){
            try {
                connection.close();
                System.out.println("connected off");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

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

    public int getAnimateur(){

    	 int animateur = 0;

    	        try{
    	            PreparedStatement q = connection.prepareStatement("SELECT animateur FROM staff");

    	             ResultSet resultat = q.executeQuery();
    	            animateur = resultat.getInt("animateur");
    	            System.out.println(resultat.getInt("animateur")+"");
    	            q.close();
    	        } catch (SQLException e){
    	            e.printStackTrace();
    	        }
    	    return animateur;

    	    }

}