public void delete() throws SQLException { Connection databaseConnection = server.getDatabaseConnection(); try (PreparedStatement statement = databaseConnection.prepareStatement("DELETE FROM `game` WHERE `uuid` = ?")) { statement.setString(1, getUUID().toString()); statement.executeUpdate(); } catch (SQLException exception) { server.getLogger().log(SEVERE, "Failed to delete game", exception); } finally { databaseConnection.close(); } }
public void update() throws SQLException { Connection databaseConnection = server.getDatabaseConnection(); try (PreparedStatement statement = databaseConnection.prepareStatement( "UPDATE `game` SET `player1_uuid` = ?, `player2_uuid` = ?, `winner_uuid` = ?, `timestamp` = ? WHERE `uuid` = ?")) { statement.setString(1, getPlayer1().getUUID().toString()); statement.setString(2, getPlayer2().getUUID().toString()); statement.setString(3, getWinner().getUUID().toString()); statement.setLong(4, getTimestamp()); statement.setString(5, getUUID().toString()); statement.executeUpdate(); } catch (SQLException exception) { server.getLogger().log(SEVERE, "Failed to update game", exception); } finally { databaseConnection.close(); } }
public void insert() throws SQLException { Connection databaseConnection = server.getDatabaseConnection(); try (PreparedStatement statement = databaseConnection.prepareStatement( "INSERT INTO `game`(`uuid`, `player1_uuid`, `player2_uuid`, `winner_uuid`, `timestamp`) VALUES(?, ?, ?, ?, ?)")) { statement.setString(1, getUUID().toString()); statement.setString(2, getPlayer1().getUUID().toString()); statement.setString(3, getPlayer2().getUUID().toString()); statement.setString(4, getWinner().getUUID().toString()); statement.setLong(5, getTimestamp()); statement.executeUpdate(); } catch (SQLException exception) { server.getLogger().log(SEVERE, "Failed to insert game", exception); } finally { databaseConnection.close(); } }