- Баллы
- 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);
}
}