Как установить параметр wood на 5 для игрока TestPlayer?
private final HikariDataSource src;
public MySQL(String host, int port, String database, String user, String password) throws SQLException {
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://"+host+":"+port+"/"+database);
config.setUsername(user);
config.setPassword(password);
config.addDataSourceProperty("cachePrepStmts", true);
config.addDataSourceProperty("prepStmtCacheSize", 250);
config.addDataSourceProperty("prepStmtCacheSqlLimit", 2048);
src = new HikariDataSource(config);
try(Connection cn = connect(); Statement st = cn.createStatement()) {
st.executeUpdate(String.format(
"CREATE TABLE IF NOT EXISTS `%s` (" +
"`player` TEXT NOT NULL PRIMARY KEY, " +
"`wood` INTEGER NOT NULL, " +
"`coal` INTEGER NOT NULL, " +
"`iron` INTEGER NOT NULL, " +
"`gold` INTEGER NOT NULL, " +
"`diamond` INTEGER NOT NULL)",
"jobs"));
}
}
private Connection connect() throws SQLException {
return src.getConnection();
}
private final HikariDataSource src;
public MySQL(String host, int port, String database, String user, String password) throws SQLException {
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://"+host+":"+port+"/"+database);
config.setUsername(user);
config.setPassword(password);
config.addDataSourceProperty("cachePrepStmts", true);
config.addDataSourceProperty("prepStmtCacheSize", 250);
config.addDataSourceProperty("prepStmtCacheSqlLimit", 2048);
src = new HikariDataSource(config);
try(Connection cn = connect(); Statement st = cn.createStatement()) {
st.executeUpdate(String.format(
"CREATE TABLE IF NOT EXISTS `%s` (" +
"`player` TEXT NOT NULL PRIMARY KEY, " +
"`wood` INTEGER NOT NULL, " +
"`coal` INTEGER NOT NULL, " +
"`iron` INTEGER NOT NULL, " +
"`gold` INTEGER NOT NULL, " +
"`diamond` INTEGER NOT NULL)",
"jobs"));
}
}
private Connection connect() throws SQLException {
return src.getConnection();
}