Помогите Не реагирует на базу данных

  • Автор темы Автор темы Sergeo
  • Дата начала Дата начала
Статус
Закрыто для дальнейших ответов.

Sergeo

Активный участник
Пользователь
Баллы
76
Имя в Minecraft
Solomka
Нет реакции на вызов бд (Ошибок нет, база данных создана)

бд:

Код:
    private static Connection connection;
    private static Statement statement;

    @Getter @Setter private int old;
    @Getter @Setter private int fraction;
    @Getter @Setter private int house;
    @Getter @Setter private int biz;
    @Getter @Setter private int stars;
    @Getter @Setter private int jail;

    @Getter @Setter private String card;
    @Getter @Setter private String billet;
    @Getter @Setter private String gender;

    public DatabaseHandler(String host, String base,
                           String user, String password) {
        try {
            connection = DriverManager.getConnection("jdbc:mysql://" + host + ":3306/" + base, user, password);
            this.update("CREATE TABLE IF NOT EXISTS `role` (`player` varchar(50) NOT NULL," +
                    "`old` int(11) NOT NULL," +
                    "`gender` int(11) NOT NULL," +
                    "`billet` varchar(50) NOT NULL," +
                    "`house` int(11) NOT NULL," +
                    "`biz` int(11) NOT NULL," +
                    "`fraction` int(11) NOT NULL," +
                    "`medcard` varchar(50) NOT NULL," +
                    "`stars` int(11) NOT NULL" +
                    ",`jail` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8");
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public ResultSet query(String query) {
        try {
            statement = connection.createStatement();
            ResultSet result = statement.executeQuery(query);
            result.next();
            return result;
        } catch (Exception exception) {
            exception.printStackTrace();
            return null;
        }
    }

    public void update(String... lines) {
        try {
            int count = lines.length;
            for(int i = 0; i < count; ++i) {
                String string = lines[i];
                (statement = connection.createStatement()).executeUpdate(string);
            }
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public void addDefaultValues(String player) {
        update("INSERT INTO role (`player`,`old`,`gender`,`billet`,`house`,`biz`," +
                "`fraction`,`medcard`,`stars`,`jail`) VALUES " +
                "('" + player + "',0,0,0,0,0,0,0,0,0);");
    }

    public void old(String player, String old) {
        update("UPDATE `role` SET `old` = " + old + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `old` FROM `protect` WHERE `player` = '" + player + "';");
            setOld(set.getInt("old"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public void gender(String player, String gender) {
        update("UPDATE `role` SET `gender` = " + gender + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `gender` FROM `role` WHERE `player` = '" + player + "';");
            setGender(set.getString("gender"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }


    public void billet(String player, String billet) {
        update("UPDATE `role` SET `billet` = " + billet + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `billet` FROM `role` WHERE `player` = '" + player + "';");
            setBillet(set.getString("billet"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }


    public void house(String player, String id) {
        update("UPDATE `role` SET `house` = " + id + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `house` FROM `role` WHERE `player` = '" + player + "';");
            setHouse(set.getInt("house"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public void biz(String player, String id) {
        update("UPDATE `role` SET `house` = " + id + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `house` FROM `role` WHERE `player` = '" + player + "';");
            setHouse(set.getInt("house"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public void fraction(String player, String fraction) {
        update("UPDATE `role` SET `fraction` = " + fraction + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `fraction` FROM `role` WHERE `player` = '" + player + "';");
            setFraction(set.getInt("fraction"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }


    public void stars(String player, String stars) {
        update("UPDATE `role` SET `stars` = " + stars + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `stars` FROM `role` WHERE `player` = '" + player + "';");
            setStars(set.getInt("stars"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public void jail(String player, String time) {
        update("UPDATE `role` SET `jail` = " + time + " WHERE `player`='" + player + "';");
        try {
            ResultSet set = query("SELECT `time` FROM `role` WHERE `player` = '" + player + "';");
            setJail(set.getInt("time"));
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
}

Пример вызова: (При клике на предмет значение в бд не меняется)

Код:
        if (inv.getName().equals("Выберите свой пол...")) {
            if (clickInv == null) return;
            if (slot <= 27) e.setCancelled(true);

            switch (slot) {
                case 4 : {
                    db.gender(p.getName(), "Женский");
                    send(translateAlternateColorCodes('&', "&aВы успешно выбрали пол: &cЖенский&f!"));
                    p.closeInventory();
                }
                case 5 : {
                    db.gender(p.getName(), "Мужской");
                    send(translateAlternateColorCodes('&', "&aВы успешно выбрали пол: &9Мужской&f!"));
                    p.closeInventory();
                }
                default: e.setCancelled(true);
            }
        }
 
Решено.
 
Статус
Закрыто для дальнейших ответов.
Назад
Верх