MySQL creating multiple columns with same name

I am trying to create a column for a player uuid that logs their kills, deaths and joins:

I am having trouble with this as it creating a different column for each type (kills/deaths, etc) as shown below in this screenshot:



The following is my code:

Updating the statistic of a player:

Code:java

public void updatePlayer(Player player, StatType type) throws SQLException {
 
    String player_uuid = player.getUniqueId().toString();
 
    if (!(this.plugin.getMySql().checkConnection())) {
 
        this.plugin.getMySql().openConnection();
 
    }
 
    Statement statement = plugin.getMySql().getConnection().createStatement();
 
    int amount = this.getData(player, type);
 
    if (amount != 0) {
 
        statement.executeUpdate("UPDATE `player_data` SET `" + type.getName() + "`='" + (amount + 1) + "' WHERE `Name`='" + player_uuid + "';");
 
    } else {
 
        statement.executeUpdate("INSERT INTO `player_data` (`Name`, `" + type.getName() + "`) VALUES ('" + player_uuid + "', '1');");
 
    }
 
}

getData() method used for updatePlayer():

Code:java

    public int getData(Player player, StatType type) throws SQLException {
 
        String player_uuid = player.getUniqueId().toString();
 
        if (!(this.plugin.getMySql().checkConnection())) {
 
            this.plugin.getMySql().openConnection();
 
        }
 
        Statement statement = plugin.getMySql().getConnection().createStatement();
 
        ResultSet rs = statement.executeQuery("SELECT * FROM `player_data` WHERE `Name`='" + player_uuid + "';");
 
        if (!(rs.next())) {
 
            return 0;
 
        }
 
        return rs.getInt(type.getName());
 
    }

Setting up the database onEnable():

Code:java

public void setupDatabase() throws SQLException {
 
    Statement statement = plugin.getMySql().getConnection().createStatement();
    statement.executeUpdate("CREATE TABLE IF NOT EXISTS `player_data` (`Name` varchar(36), `" + StatType.JOINS.getName() + "` int);");
    statement.executeUpdate("CREATE TABLE IF NOT EXISTS `player_data` (`Name` varchar(36), `" + StatType.DEATHS.getName() + "` int);");
    statement.executeUpdate("CREATE TABLE IF NOT EXISTS `player_data` (`Name` varchar(36), `" + StatType.KILLS.getName() + "` int);");
 
}

And then finally I set the values onPlayerJoin() printing them to the player debugging if the values are updated:

Code:java

@EventHandler
public void onPlayerJoin(PlayerJoinEvent event) {
 
    Player player = event.getPlayer();
 
    try {
 
        updatePlayer(player, StatType.DEATHS);
        player.sendMessage("{" + getData(player, StatType.DEATHS) + "=" + StatType.DEATHS.getName() + "};");
 
        updatePlayer(player, StatType.KILLS);
        player.sendMessage("{" + getData(player, StatType.DEATHS) + "=" + StatType.KILLS.getName() + "};");
 
    } catch (SQLException e) {
 
        e.printStackTrace();
 
    }
 
}

If anyone could help me this, that would be really appreciated.

Thanks.

 

I don't have a ton of experience with this (and I could be totally wrong), but I believe that the ResultSet is originally pointing before the very first record. Hence, it will return false.

Try this:

Code:

while(rs.next())
{
    // get column values/do whatever you need with the record
}

Again, if I'm wrong feel free to yell at me