diff options
| -rw-r--r-- | src/main/java/net/tylermurphy/ken/database/SelfRoleTable.java | 21 |
1 files changed, 14 insertions, 7 deletions
diff --git a/src/main/java/net/tylermurphy/ken/database/SelfRoleTable.java b/src/main/java/net/tylermurphy/ken/database/SelfRoleTable.java index 5ad289c..f44f6a2 100644 --- a/src/main/java/net/tylermurphy/ken/database/SelfRoleTable.java +++ b/src/main/java/net/tylermurphy/ken/database/SelfRoleTable.java @@ -55,13 +55,20 @@ public class SelfRoleTable { } public boolean deleteData(long guildId, int page){ - String sql = "DELETE FROM self_role_data WHERE guild_id = ? AND page = ?; UPDATE self_role_data SET page = page - 1 WHERE guild_id = ? AND page > ?;"; - try(Connection connection = database.connect(); PreparedStatement statement = connection.prepareStatement(sql)) { - statement.setLong(1, guildId); - statement.setInt(2, page); - statement.setLong(3, guildId); - statement.setInt(4, page); - return statement.executeUpdate() != 0; + try(Connection connection = database.connect();) { + String sql = "DELETE FROM self_role_data WHERE guild_id = ? AND page = ?;"; + try(PreparedStatement statement = connection.prepareStatement(sql)){ + statement.setLong(1, guildId); + statement.setInt(2, page); + statement.executeUpdate(); + } + sql = "UPDATE self_role_data SET page = page - 1 WHERE guild_id = ? AND page > ?;"; + try(PreparedStatement statement = connection.prepareStatement(sql)){ + statement.setLong(1, guildId); + statement.setInt(2, page); + statement.executeUpdate(); + } + return true; } catch (SQLException e) { Ken.getInstance().getLogger().error("SQL Error: " + e.getMessage()); return false; |