package eu.fantasiacraftmaintenance.sql;

import java.sql.*;

public class SQL {

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

    public SQL(String urlbase, String host, String database, String user, String pass) {
        this.urlbase = urlbase;
        this.host = host;
        this.database = database;
        this.user = user;
        this.pass = pass;
    }

    public void connect(){
        if(!isConnected()){
            try{
                connection = DriverManager.getConnection(urlbase+host+"/"+database,user,pass);
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
    }

    public void disconnect(){
        if(isConnected()){
            try{
                connection.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
    }

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

    public String Login01Statut(){
        String var = "";
        try{
            PreparedStatement q = connection.prepareStatement("SELECT login01 FROM serveurs_status WHERE id = 1");
            ResultSet resultSet = q.executeQuery();
            while(resultSet.next()){
                var = resultSet.getString("login01");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return var;
    }

    public String Login02Statut(){
        String var = "";
        try{
            PreparedStatement q = connection.prepareStatement("SELECT login02 FROM serveurs_status WHERE id = 1");
            ResultSet resultSet = q.executeQuery();
            while(resultSet.next()){
                var = resultSet.getString("login02");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return var;
    }

    public String Login03Statut(){
        String var = "";
        try{
            PreparedStatement q = connection.prepareStatement("SELECT login03 FROM serveurs_status WHERE id = 1");
            ResultSet resultSet = q.executeQuery();
            while(resultSet.next()){
                var = resultSet.getString("login03");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return var;
    }

    public String Login04Statut(){
        String var = "";
        try{
            PreparedStatement q = connection.prepareStatement("SELECT login04 FROM serveurs_status WHERE id = 1");
            ResultSet resultSet = q.executeQuery();
            while(resultSet.next()){
                var = resultSet.getString("login41");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return var;
    }

    public String Login05Statut(){
        String var = "";
        try{
            PreparedStatement q = connection.prepareStatement("SELECT login05 FROM serveurs_status WHERE id = 1");
            ResultSet resultSet = q.executeQuery();
            while(resultSet.next()){
                var = resultSet.getString("login05");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return var;
    }

    public String Login06Statut(){
        String var = "";
        try{
            PreparedStatement q = connection.prepareStatement("SELECT login06 FROM serveurs_status WHERE id = 1");
            ResultSet resultSet = q.executeQuery();
            while(resultSet.next()){
                var = resultSet.getString("login06");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return var;
    }
}