code

package me.wafflemaster.com;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.logging.Logger;

import org.bukkit.ChatColor;
import org.bukkit.Material;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.plugin.PluginDescriptionFile;
import org.bukkit.plugin.java.JavaPlugin;

public class main extends JavaPlugin{
	public final Logger logger = Logger.getLogger("Minecraft");

	public static main plugin;

	@Override
	public void onDisable() {
		PluginDescriptionFile pdfFile = this.getDescription();
		this.logger.info(pdfFile.getName() + " s-a dezactivat!");
		closeConnection();
	}

	@Override
	public void onEnable() {
		PluginDescriptionFile pdfFile = this.getDescription();
		this.logger.info(pdfFile.getName() + " versiunea " + pdfFile.getVersion() + " s-a activat!");
		openConnection();
		createTable();
		createConfig();
	}

	public void createConfig(){
		try {
			if (!getDataFolder().exists()) {
            	getDataFolder().mkdirs();
        	}
        	File file = new File("config.yml");
        	if (!file.exists()) {
            	getLogger().info("Config.yml not found, creating!");
            	saveDefaultConfig();
        	} else {
        		getLogger().info("Config.yml found, loading!");
        	}
		} catch (Exception e) {
			e.printStackTrace();
		}
    }

	public boolean onCommand(CommandSender sender, Command cmd, String commandLabel, String[] args) {
		Player player = (Player) sender;
		if(commandLabel.equalsIgnoreCase("arena")) {
			if(args.length == 0){
				player.sendMessage("Foloseste /arena join");
				player.sendMessage(getUsername(2));
				return true;
			}
				if(player instanceof Player){
					if(getRows() <= 15){
						if(args[0].equalsIgnoreCase("join")) {
							addPlayer(player);
							return true;
						}
					}else{
						player.sendMessage(ChatColor.RED + "S-a atins deja numarul mexim de Playeri");
					}
				}else{
					logger.info("Aceasta comanda poate fi rulata doar de jucatori!");
				}
			if(args[0].equalsIgnoreCase("refresh")){
				setPlayer();
				return true;
			}
		}
		return true;
	}

	private static Connection connection;
	String table = "Players";

	public void openConnection() {
		String host = getConfig().getString("MySQL.host");
		String port = getConfig().getString("MySQL.port");
		String database = getConfig().getString("MySQL.database");
		String user = getConfig().getString("MySQL.user");
		String pass = getConfig().getString("MySQL.pass");

		try
		{
			connection = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, user, pass);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}

	public void closeConnection() {
		try
		{
			connection.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}

	public void createTable() {
	    try{
	        PreparedStatement sql = connection.prepareStatement("CREATE TABLE IF NOT EXISTS `" + table + "` (ID INT(11) NOT NULL AUTO_INCREMENT, USERNAME VARCHAR(17), primary key (ID));");
	        sql.execute();
	        sql.close();
	    }catch (Exception e){
	        e.printStackTrace();
	    }
	}

	public void addPlayer(Player player) {
		if(checkPlayer(player) == false){
			try{
				PreparedStatement sql = connection.prepareStatement("INSERT INTO `" + table + "` VALUES(null,'" + player.getName() + "');");
				sql.execute();
				sql.close();
				player.sendMessage(ChatColor.GREEN + "Te-ai inscris cu succes!");
			}catch (Exception e){
				e.printStackTrace();
			}
		}else{
			player.sendMessage(ChatColor.RED + "Esti deja inscris alaturi de inca " + (getRows() - 1) + " palyeri");
		}
	}

	public boolean checkPlayer(Player player){
		try{
			PreparedStatement sql = connection.prepareStatement("SELECT * FROM `" + table + "` WHERE USERNAME='" + player.getName() + "';");
			sql.execute();
			ResultSet resultSet = sql.executeQuery();
			boolean containsPlayer = resultSet.next();

			sql.close();
			resultSet.close();

			return containsPlayer;
		} catch(Exception e){
			e.printStackTrace();
			return true;
		}
	}

	public int getRows() {
		try{
			PreparedStatement sql = connection.prepareStatement("SELECT * FROM`" + table + "`;");
			sql.execute();
			ResultSet resultSet = sql.executeQuery();
			int count = 0;
		      while (resultSet.next()) {
		        count++;
		      }
		    return count;
		} catch(Exception e){
			e.printStackTrace();
			return 0;
		}
	}

	public String getUsername(int id){
		try{
			PreparedStatement sql = connection.prepareStatement("SELECT USERNAME FROM`" + table + "` WHERE id='" + id + "';");
			sql.execute();
			ResultSet resultSet = sql.executeQuery();
			String Nume = null;
			if (resultSet.next() == true) {
			    Nume = resultSet.getString("USERNAME");
			}
			return Nume;
		}catch(Exception e){
			e.printStackTrace();
			return "null";
		}
	}

	public void setPlayer() {
		if(getRows() == 1){
			setBlock(1);
		}else if(getRows() == 2){
			setBlock(1);
			setBlock(2);
		}else if(getRows() == 3){
			setBlock(1);
			setBlock(2);
			setBlock(3);
		}else if(getRows() == 4){

		}else if(getRows() == 5){

		}
	}

	private void setBlock(int nr) {
		plugin.getServer().getWorld("world").getBlockAt(getConfig().getInt("player" + nr + "block.X"), getConfig().getInt("player" + nr + "block.Y"), getConfig().getInt("player" + nr + "block.Z")).setType(Material.DIAMOND_BLOCK);
	}
}