diff options
| author | Matthew <pugmatt@gmail.com> | 2021-01-21 19:01:04 -0500 |
|---|---|---|
| committer | Matthew <pugmatt@gmail.com> | 2021-01-21 19:01:04 -0500 |
| commit | 01becb452585f8c58fd250358e42a863f4bbe3e2 (patch) | |
| tree | 0b164d68b6960e4b9988577b0a863b95a6442407 | |
| parent | 09c6ce5a6411502c02fea9d726100d075df27c3d (diff) | |
| download | BedrockConnect-01becb452585f8c58fd250358e42a863f4bbe3e2.tar.gz BedrockConnect-01becb452585f8c58fd250358e42a863f4bbe3e2.tar.bz2 BedrockConnect-01becb452585f8c58fd250358e42a863f4bbe3e2.zip | |
Finish other SQL fixes
| -rw-r--r-- | serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java b/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java index 5a9dbb3..9385435 100644 --- a/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java +++ b/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java @@ -176,12 +176,11 @@ public class Data { if(!BedrockConnect.noDB) { new Thread(() -> { try { - PreparedStatement s = BedrockConnect.connection.prepareStatement("UPDATE servers SET " + column + "='" + value + "' WHERE uuid='" + uuid + "'"); - s.setString(1, column); - s.setString(2, value); - s.setString(3, uuid); + PreparedStatement s = BedrockConnect.connection.prepareStatement("UPDATE servers SET " + column + "= ? WHERE uuid= ?"); + s.setString(1, value); + s.setString(2, uuid); - Basic_SQL("UPDATE servers SET " + column + "='" + value + "' WHERE uuid='" + uuid + "'"); + s.executeUpdate(); } catch (Exception e) { errorAlert(e); } @@ -209,7 +208,11 @@ public class Data { new Thread(() -> { try { - Basic_SQL("UPDATE servers SET " + column + "=" + value + " WHERE uuid='" + uuid + "'"); + PreparedStatement s = BedrockConnect.connection.prepareStatement("UPDATE servers SET " + column + "= ? WHERE uuid= ?"); + s.setInt(1, value); + s.setString(2, uuid); + + s.executeUpdate(); } catch (Exception e) { |