main.class

package dev.stylenetwork.clans;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

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

import dev.stylenetwork.clans.commands.Clan;
import dev.stylenetwork.clans.commands.ClanRegistrar;
import dev.stylenetwork.clans.commands.ResetKdr;
import dev.stylenetwork.clans.sql.Mysql;
import dev.stylenetwork.clans.sql.MysqlApi;
import dev.stylenetwork.clans.systems.Arrays;
import dev.stylenetwork.clans.systems.ClanPOO;
import dev.stylenetwork.clans.systems.ClanPlayerPOO;

public class Main extends JavaPlugin {

	public static String host;
	public static String porta;
	public static String bancodedados;
	public static String usuario;
	public static String senha;

	public Mysql db;
	public static Main plugin;
	public static CommandSender console = Bukkit.getConsoleSender();
	public static String Menssagems = "§b§lStyle§f§lNetwork §7➡ ";

	public void onEnable() {
		plugin = this;
		MysqlSetup();
		getCommand("clan").setExecutor(new Clan());
		getCommand("resetkdr").setExecutor(new ResetKdr());
		getCommand("clanregistrar").setExecutor(new ClanRegistrar());
	}

	public void onDisable() {
		try {
			Connection c = DriverManager.getConnection("jdbc:mysql://" + Main.host + ":" + Main.porta + "/" + Main.bancodedados, Main.usuario, Main.senha);
			Statement stmt = c.createStatement();
			for (String clans : Arrays.clandados.keySet()) {
				ClanPOO clan = Arrays.clandados.get(clans);
				clan.ClansUpdate(stmt, clan, clan.nome);
			}
			for (String players : Arrays.playerdados.keySet()) {
				ClanPlayerPOO cp = Arrays.playerdados.get(players);
				cp.PlayerUpdate(stmt, cp.jogador);
			}
			console.sendMessage("§e§lMysql§7: §fBanco de dados §e" + Mysql.database +" §fsalvou os dados.");
		} catch (Exception e) {
			console.sendMessage("§e§lMysql§7: §cOcorreu um erro ao salvar o banco de dados §e" + Mysql.database);
			e.printStackTrace();
		}
	}

	public void MysqlSetup() {
		host = "127.0.0.1";
		porta = "3306";
		bancodedados = Mysql.database;
		usuario = "root";
		senha = "";
		db = new Mysql();

		try {
			Connection c = DriverManager.getConnection("jdbc:mysql://" + Main.host + ":" + Main.porta + "/" + Main.bancodedados, Main.usuario, Main.senha);
			Statement stmt = c.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM " + Mysql.tabela2 + ";");
			while (rs.next()) {
				String jogador = rs.getString("Jogador");
				int kills = rs.getInt("Assasinatos");
				int Mortes = rs.getInt("Mortes");
				String clan = rs.getString("Clan");
				String lider = rs.getString("Lider");
				String pvp = rs.getString("PvP");
				ClanPlayerPOO cp = new ClanPlayerPOO(jogador);
				cp.assasinatos = kills;
				cp.mortes = Mortes;
				cp.clan = clan;
				cp.lider = lider;
				cp.pvp = pvp;
				Arrays.playerdados.put(jogador, cp);
			}
			c.close();
			stmt.close();
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

		try {
			Connection c = DriverManager.getConnection("jdbc:mysql://" + Main.host + ":" + Main.porta + "/" + Main.bancodedados, Main.usuario, Main.senha);
			Statement stmt = c.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM " + Mysql.tabela + ";");
			ArrayList<String> deletar = new ArrayList<>();
			while (rs.next()) {
				String nome = rs.getString("Tag");
				String tag = rs.getString("TagColor");
				String PvPClan = rs.getString("PvPClan");
				int eventos = rs.getInt("Eventos");
				int quantidademembros = rs.getInt("Membros");
				String lideres = MysqlApi.getLideresClan(nome);
				String membros = MysqlApi.getMembros(nome);

				if (nome == null) {
					deletar.add(nome);
				}
				ClanPOO clan = new ClanPOO(nome);
				clan.tag = tag;
				clan.PvPClan = PvPClan;
				clan.eventos = eventos;
				clan.membros = quantidademembros;
				clan.ClanLideres.add(lideres);
				clan.ClanMembros.add(membros);
				Arrays.clandados.put(nome, clan);
			}
			for (String clan : deletar) {
				MysqlApi.DeletarClan(clan);
			}
			deletar.clear();
			c.close();
			stmt.close();
			rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}