GradeInGame

package fr.bhugues.unicorn.gradeingame;

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

import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.player.PlayerJoinEvent;

public class Listerners implements Listener {

    @EventHandler
    public void active_join(PlayerJoinEvent e) {

        Player p = e.getPlayer();
        String name = p.getName();

        String url = "jdbc:mysql://151.80.181.8:3306/unicorn_altis";
        String utilisateur = "*******";
        String motDePasse = "*****";
        Connection connexion = null;
        try {
            connexion = DriverManager.getConnection( url, utilisateur, motDePasse );

            p.sendMessage("COUCOU la co fonctionne");

            PreparedStatement statement = connexion.prepareStatement("select * from grade_in where pseudo = ?");
            statement.setString(1, name);
            ResultSet resultat = statement.executeQuery();

            while ( resultat.next() ) {
                String id_grade = resultat.getString( "grade" );

                //ICI ON VA MANUADD QUAND ON AURA L'API DE GROUP MANAGER

            }

            p.sendMessage("COUCOU premiere requete");
            PreparedStatement statement1 = connexion.prepareStatement("select * from nom_rp where pseudo = ?");
            statement1.setString(1, name);
            ResultSet resultat1 = statement1.executeQuery();

            while ( resultat1.next() ) {
                String id_nom = resultat1.getString( "nom" );
                String id_prenom = resultat1.getString( "prenom" );

                String total = id_nom + id_prenom;

                p.setCustomName(total);
                p.setDisplayName(total);
                p.setPlayerListName(total);

            }

            p.sendMessage("COUCOU fini");


        } catch ( SQLException c ) {

        } finally {
            if ( connexion != null )
                try {

                    connexion.close();
                } catch ( SQLException ignore ) {

                }
        }

    }

}