From 01becb452585f8c58fd250358e42a863f4bbe3e2 Mon Sep 17 00:00:00 2001 From: Matthew Date: Thu, 21 Jan 2021 19:01:04 -0500 Subject: Finish other SQL fixes --- .../com/pyratron/pugmatt/bedrockconnect/sql/Data.java | 15 +++++++++------ 1 file 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) { -- cgit v1.2.1