如何将命令发送器从Commands类转到DB类

Question

我有两个类的数据库，其中有一个方法“GetMoney”和命令

一般来说，关键是在数据库类中，我需要以某种方式获得一个播放器，或者更确切地说，是在命令类中编写的命令的发送者。我该怎么做？

//DB-GETMONEY

    public int GetMoney(String name) throws Exception {
        String tableName = this.plugin.getConfig().getString("tableName");
        String dbNames = this.plugin.getConfig().getString("columnFirst");
        String dbBalance = this.plugin.getConfig().getString("columnSecond");
        Connection c = this.getConnection();
        Statement s = c.createStatement();
        ResultSet  res = s.executeQuery("SELECT " + dbBalance +" FROM "+ tableName +" WHERE " + dbNames +" = '"+ name +"'" );
        res.next();
        return res.getInt(dbBalance);   
    }

//命令-onCommand

 @Override
    public  boolean onCommand(CommandSender sender, Command command, String label, String[] args) {
        
        
        String name = sender.getName();;

        if(args.length == 0 ) {
            
            String showBalance = this.plugin.getConfig().getString("messages.showBalance"); 
            
            
            try {
                int balance = this.database.GetMoney(name);
                showBalance = showBalance.replace("&", "\u00a7").replace("_nm", name).replace("_bl", String.valueOf(balance));
                sender.sendMessage(showBalance);
            } catch (Exception e) {
                e.printStackTrace();
            }
            return false;
        }

Answer 1

我认为传球界面比一个简单的名字要好。首先，您必须确保发送者是玩家，而不是控制台命令发送者。在此之后，您可以传递玩家，在GetMoney（）方法中，您只需通过Player获得玩家的名字。getName（）方法。

编辑：我看到你需要命令发送者。你也可以传递它，而不是玩家，只需用命令发送者替换GetMoney参数，并删除我们确定发送者是否是玩家的实例检查。毕竟，你只需在任何地方再次检查它，然后再次将其转换为玩家。

@Override
    public  boolean onCommand(CommandSender sender, Command command, String label, String[] args) {
        if (args.length == 0) {
            if (sender instanceof Player) {
                Player player = (Player) sender;

                String showBalance = this.plugin.getConfig().getString("messages.showBalance");
                try {
                    int balance = this.database.GetMoney(player);
                    showBalance = showBalance.replace("&", "\u00a7").replace("_nm", player.getName()).replace("_bl", String.valueOf(balance));
                    sender.sendMessage(showBalance);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            } else {
                sender.sendMessage("Player only command.");
            }
        }
        return false;
    }
    
//DB - Getmoney
    public int GetMoney(Player player) throws Exception {
        String tableName = this.plugin.getConfig().getString("tableName");
        String dbNames = this.plugin.getConfig().getString("columnFirst");
        String dbBalance = this.plugin.getConfig().getString("columnSecond");
        
        Connection c = this.getConnection();
        Statement s = c.createStatement();
        ResultSet  res = s.executeQuery("SELECT " + dbBalance +" FROM "+ tableName +" WHERE " + dbNames +" = '"+ player.getName() +"'" );
        res.next();
        return res.getInt(dbBalance);
    }