UltimateReporter

//Ma commande

package fr.xuarig.UltimateReporter;


import org.bukkit.command.Command;
import org.bukkit.command.CommandExecutor;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;

public class ReportCommand implements CommandExecutor {

	/*
	 * /report <player> <reason>
	 */

	@Override
	public boolean onCommand(CommandSender sender, Command cmd, String msg, String[] args) {

		if(sender instanceof Player){

			Player p = (Player)sender;

			if(cmd.getName().equalsIgnoreCase("report")){

				//Test de la commande /report

				String reason = "";
	         	for (int i = 1; i < args.length; i++)
	         	{
	         		String arg = args[i] + " ";
	         		reason = reason + arg;

	         		//Regarde uniquement les args de la Raison
	         	}

				if(args.length == 0){
					p.sendMessage("§b[§6UltimateReporter§b] §4Votre commande est incomplète !");
					p.sendMessage("§b[§6UltimateReporter§b] §cCommande : /report <joueur> [Raison]");

					//Message d'aide en cas de /report
				}


				if(args.length >= 1){
					Player target = p.getServer().getPlayerExact(args[0]);
					if(!args[0].equalsIgnoreCase(p.getName())){
						//Empèche le joueur de s'autoreport
						if(target != null){
								p.sendMessage("§b[§6UltimateReporter§b] §aVotre report a été pris en compte !");

								for(Player player : p.getServer().getOnlinePlayers()) {
									if(player.isOp()) {
										//Teste les joueurs ops

										String messageToSend = "§b[§6UltimateReporter§b]§4 " + target.getName() + " §6a été reporté par §4" + p.getName();
										String msgConsToSend = "\u001B[37mReport de \u001B[31m" + target.getName() + "\u001B[37m par \u001B[31m" + p.getName() + "\u001B[0m";
										if ( args.length >= 2 )
										{
											messageToSend = messageToSend + " §6! Raison :§4 " + reason;
											msgConsToSend = msgConsToSend + "\u001B[37m ! Raison : \u001B[33m" + reason + "\u001B[0m";
										}
										player.sendMessage(messageToSend); //Envoie le message aux modos
										System.out.println(msgConsToSend); //message report sur la console

								}
								//Envoie l'information vers SqlConection via Parametres.
								Parametres.sqlConnection.report(p,target,reason);
							}
						}



					}
				}
			}

		}
		return false;
	}
}

-------------------------------------------------------------------------------------------------------------------------

//Parametres.java

package fr.xuarig.UltimateReporter;

public class Parametres {
	static SqlConnection sqlConnection = null;
}

----------------------------------------------------------------------------------------------------------------------------

//SqlConnection.java

package fr.xuarig.UltimateReporter;

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;

public class SqlConnection {

	public static String raison;
	private Connection connection;
	private String urlbase,host,database,user,pass;

	public SqlConnection(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;
		//Va chercher les infos de connection
	}

	public void connection(){
		if(!isConnected()){
		try {
			connection = DriverManager.getConnection(urlbase + host + "/" + database, user, pass);
			System.out.println("\u001B[36m[\u001B[32mUltimateReporter\u001B[36m] \u001B[32mMySQL Connected \u001B[0m");
		} catch (SQLException e) {
			e.printStackTrace();
			//Se connecte
		}
		}
	}

	public void disconnect(){
		if(isConnected()){
		try {
			connection.close();
			System.out.println("\u001B[36m[\u001B[31mUltimateReporter\u001B[36m] \u001B[31mMySQL Disconnected \u001B[0m");
		} catch (SQLException e) {
			e.printStackTrace();
			//Se déconnecte
		}
		}

	}

	public boolean isConnected(){
		return connection != null;
		//Teste si mysql est connecté
	}

	public void report (Player p_player, Player p_target, String p_reason){
		//INSERT
		try {
			PreparedStatement q = connection.prepareStatement("INSERT INTO ultimatereporter(accusateur,accuse,dateheure,raison) VALUES (?,?,now(),?)");
			q.setString(1, p_player.getUniqueId().toString());
			q.setString(2, p_target.getUniqueId().toString());
			q.setString(3, p_reason);
			q.execute();
			q.close();
			} catch(SQLException e) {
			System.out.println(e.getMessage());

			//Envoie les infos à la BDD


			}
	}


	public void getRaison(Player target){
		try {
			PreparedStatement q = connection.prepareStatement("SELECT raison FROM ultimatereporter WHERE accuse = ?");
			q.setString(1, target.getUniqueId().toString());

			ResultSet rs = q.executeQuery();

			while(rs.next()){
				raison = rs.getString("raison");
				if(raison == null){

				}
			}


				q.close();


		} catch (SQLException e) {
			System.out.println(e.getMessage());
			//e.printStackTrace();

		}
	}
	}