No PaperSpigot values are added to mysql

Viewed 39

The plugin connects to the MySQL Database, creates the necessary columns, but does not add anything there, either when the player logs on to the server, or when he selects one of the effects. My code: `

package org.aneras.mc.trails.MySql;
 
import org.aneras.mc.trails.Trails;
import org.bukkit.entity.Player;
 
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.UUID;
 
 
public class MySqlWorker {
 
    private Trails plugin;
    public MySqlWorker(Trails plugin){
        this.plugin = plugin;
    }
 
    public void createTable(){
        PreparedStatement preparedStatement;
        try {
            preparedStatement = plugin.SQL.getConnection().prepareStatement("CREATE TABLE IF NOT EXISTS playersInfo "
            + "(NAME VARCHAR(100),UUID VARCHAR(100),MessageFlag INT(100),BedFlag INT(100),SignFlag INT(100),SoundFlag INT(100),FrameFlag INT(100),KillFlag INT(100),ArrowFlag INT(100),WalkFlag INT(100),BedBreakCount INT NOT NULL,KillCount INT NOT NULL, PRIMARY KEY (NAME))");
        preparedStatement.executeUpdate();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
 
    public void createPlayer(Player player){
        try {
            UUID uuid = player.getUniqueId();
            if(!exists(uuid)){
                PreparedStatement ps = plugin.SQL.getConnection().prepareStatement("INSERT IGNORE INFO playersInfo" + " (NAME,UUID) VALUES (?,?)");
                ps.setString(1, player.getName());
                ps.setString(2, uuid.toString());
                ps.executeUpdate();
 
                return;
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
 
    public boolean exists(UUID uuid){
        try {
            PreparedStatement preparedStatement = plugin.SQL.getConnection().prepareStatement("SELECT * FROM playersInfo WHERE UUID=?");
            preparedStatement.setString(1, uuid.toString());
            ResultSet results = preparedStatement.executeQuery();
            if(results.next()){
                return true;
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return false;
    }

` I tried to check if the connection to the database is accurate

0 Answers
Related