public static void addCoins(Player p, int coins){
        openConnection();
        int previousCoins = 0;
        try{
            if(playerDataContainsPlayer(p)){
        PreparedStatement sqlC = connection
                .prepareStatement("SELECT coins FROM `player_data` WHERE player =?;");
        sqlC.setString(1, p.getName());
        ResultSet resultC = sqlC.executeQuery();
        resultC.next();

        previousCoins = resultC.getInt("coins");

        PreparedStatement CoinsUpdate = connection
                .prepareStatement("UPDATE `player_data` SET coins=? WHERE player=?;");
        CoinsUpdate.setInt(1, previousCoins + coins);
        CoinsUpdate.setString(2, p.getName());
        if(coins <= 1 ){
            p.sendMessage(ChatColor.GOLD + "+ 1 coin");
        } else {
            p.sendMessage(ChatColor.GOLD + "+ " + coins + " coins");
        }
        SQLHandler.coins.put(p, coins + previousCoins);
        CoinsUpdate.executeUpdate();


        CoinsUpdate.close();
        sqlC.close();
        resultC.close();
            }

    }   catch (Exception e) {
        e.printStackTrace();
    } finally {
        closeConnection();
    }
    }