// ######################################################################################################################################## public MOCKioskKioskSlide getSlide(int slideId) { if (slideId != -1) { for (MOCKioskKioskSlide slide : this.slides) { if (slide.getIndeck_id() == slideId) { // Found matching slide return slide; } } } return null; }
private void updatePopupSlide( MOCKioskKioskSlide editSlide, String kioskName, String popupTitle, String popupText, String popupURL, String popupImageURL, int popupImageSize) { editSlide.setName(kioskName); editSlide.setTitle(popupTitle); editSlide.setText(popupText); editSlide.setUrl(popupURL); editSlide.setImage(popupImageURL); editSlide.setImage_size(popupImageSize); PreparedStatement statement = this.databaseConnection.prepareStatementAndKeys( "UPDATE `kiosk_slides` SET `name`=?, `title`=?, `text`=?, `url`=?, `image`=?, `image_size`=? WHERE `id`=?"); try { statement.setString(1, kioskName); // name statement.setString(2, popupTitle); // title statement.setString(3, popupText); // text statement.setString(4, popupURL); // url statement.setString(5, popupImageURL); // image statement.setInt(6, popupImageSize); // image_size statement.setInt(7, editSlide.getId()); // id this.databaseConnection.updateQuery(statement); } catch (SQLException e) { e.printStackTrace(); } }