package Cmd;



import java.util.ArrayList;

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



public class ManageReportsCMD implements CommandExecutor{
	 static ArrayList<String> array = new ArrayList<>();
	private String Prefix = Main.Main.Prefix;

	@Override
	public boolean onCommand(CommandSender s, Command cmd, String label, String[] a) {
	if(cmd.getName().equalsIgnoreCase("ManageReports")) {
		if(s.hasPermission("J.ReportManage")) {
			if(a.length == 0) {
				Main.Main.get();
				s.sendMessage(Main.Main.Name.get("Name")+" "+Main.Main.Reason.get("Reason")+" " +Main.Main.Reporter.get("Report"));
				System.out.println(Main.Main.Name+" "+Main.Main.Reason+" "+Main.Main.Reporter.get("Report") );

				}
			}else {
				s.sendMessage(Prefix+"Dazu hast du keine Berechtigung");
			}
			}




		return false;
	}

}

----------Main-------------

package Main;



import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

import org.bukkit.Bukkit;
import org.bukkit.plugin.java.JavaPlugin;

import Cmd.ManageReportsCMD;
import Cmd.ReportCMD;
import Listener.InventoryClickiEvent;




public class Main extends JavaPlugin {
	public static String Prefix = "§8[§cReport§8]§a";
	static ArrayList<String> array = new ArrayList<>();

	public static HashMap <String,String> Name = new HashMap<>();
	public static HashMap <String,String> Reason = new HashMap<>();
	public static HashMap <String,String> Reporter = new HashMap<>();

	private static Main plugin;

	public static String Database;
	public static String Username;
	public static String Password;
	public static String Host;
	public static int Port;
	public static Connection con;
	public static Main getPlugin() {
		return plugin;
	}

	public static void setPlugin(Main plugin) {
		Main.plugin = plugin;
	}

	public void onEnable() {
		setPlugin(this);
		Bukkit.getConsoleSender().sendMessage("§4Report Plugin gestartet!");

		Bukkit.getPluginManager().registerEvents(new InventoryClickiEvent(), this);

		this.getCommand("Report").setExecutor(new ReportCMD());
		this.getCommand("ManageReports").setExecutor(new ManageReportsCMD());


		MySqlsetup();
		get();
		System.out.println(Name.get("Grund"));

		reloadConfig();
		getConfig().addDefault("Database","...");
		getConfig().addDefault("Username","...");
		getConfig().addDefault("Password","...");
		getConfig().addDefault("Host","...");
		getConfig().addDefault("Port","...");
		getConfig().options().copyDefaults(true);
		saveConfig();
		 CreateTable();
	}


	public  void MySqlsetup() {

		String Database = getConfig().getString("Database");
		String Username = getConfig().getString("Username");
		String Password = getConfig().getString("Password");
		String Port = getConfig().getString("Port");
		String Host = getConfig().getString("Host");


		try {

			synchronized(this) {
				if(getConnection() != null && !getConnection().isClosed()) {
				return;
			}
			Class.forName("com.mysql.jdbc.Driver");
			setConnection(DriverManager.getConnection("jdbc:mysql://"+Host+":"+Port+"/"+Database,Username,Password));
			Bukkit.getConsoleSender().sendMessage("§aVerbindung zur MySql aufgenommen!");
			}

		}catch(SQLException e)  {
			e.printStackTrace();
			Bukkit.getConsoleSender().sendMessage("§4Verbindung zu MySql konnte nicht aufgenommen werden!");
		}catch(ClassNotFoundException e) {
			e.printStackTrace();
			System.out.println("Klassenfehler");
		}
	}


	public static Connection getConnection() {
		return con;
	}

	public  void setConnection(Connection con) {
		this.con = con;
	}
	public void CreateTable() {
		try {
			con.createStatement().executeUpdate("CREATE TABLE IF NOT EXISTS ReportedPlayers (Name VARCHAR(100), "
					+ "UUID VARCHAR(100), Grund VARCHAR(100), Reporter VARCHAR(100) )");
			Bukkit.getConsoleSender().sendMessage(Prefix+"MySql Table erfolgreich erstellt!");
		} catch (SQLException e) {

			e.printStackTrace();
		}
	}

	public static void update(String qry) {
	try {
		con.createStatement().executeUpdate(qry);
	} catch (SQLException e) {
		e.printStackTrace();
	}
	}

	public static ArrayList<String> get() {
		try {

			PreparedStatement st = con.prepareStatement("SELECT Name,Grund,Reporter FROM reportedplayers");
			ResultSet rs = st.executeQuery();

			while(rs.next()) {
				Reason.put("Reason", rs.getString("Grund"));
				Name.put("Name",rs.getString("Name"));
				Reporter.put("Report",rs.getString("Reporter"));


				array.add(rs.getString("Name"));
			}
			return array;

		}catch(SQLException e) {
			e.printStackTrace();
			System.out.println("Fehler beim laden!");
	}
		return null;
}
}