# Constant Field Values

## Contents

- com.rosivanyshyn.*

## com.rosivanyshyn.*

- com.rosivanyshyn.controller.dispatcher.ControllerConstant
  Modifier and Type
  Constant Field
  Value
  `public static final String`
  `ACCOUNT_DETAILS_JSP`
  `"/pages/account/account.jsp"`
  `public static final String`
  `ALL_BOOKINGS_JSP`
  `"/pages/booking/allBookings.jsp"`
  `public static final String`
  `ALL_ORDERS_JSP`
  `"/pages/order/allOrders.jsp"`
  `public static final String`
  `APARTMENT_DETAILS_JSP`
  `"/pages/apartment.jsp"`
  `public static final String`
  `APARTMENTS_JSP`
  `"/pages/apartments.jsp"`
  `public static final String`
  `BOOKINGS_JSP`
  `"/pages/booking/bookings.jsp"`
  `public static final String`
  `CHANGE_LANGUAGE_CONTROLLER`
  `"changeLanguage"`
  `public static final String`
  `CONTROLLER_NAME`
  `"controller"`
  `public static final String`
  `CREATE_BOOKING_CONTROLLER`
  `"createBooking"`
  `public static final String`
  `CREATE_ORDER_CONTROLLER`
  `"createOrder"`
  `public static final String`
  `CREATE_RESPONSE_TO_ORDER_CONTROLLER`
  `"createResponseToOrder"`
  `public static final String`
  `DELETE_APARTMENT_CONTROLLER`
  `"deleteApartment"`
  `public static final String`
  `DELETE_BOOKING_CONTROLLER`
  `"deleteBooking"`
  `public static final String`
  `DELETE_ORDER_CONTROLLER`
  `"deleteOrder"`
  `public static final String`
  `ERROR_JSP`
  `"/pages/error.jsp"`
  `public static final String`
  `FEATURE_TURN_SCHEMA_VALIDATION_ON`
  `"http://apache.org/xml/features/validation/schema"`
  `public static final String`
  `FEATURE_TURN_VALIDATION_ON`
  `"http://xml.org/sax/features/validation"`
  `public static final String`
  `GET_ACCOUNT_DETAILS_CONTROLLER`
  `"getAccountDetails"`
  `public static final String`
  `GET_ALL_BOOKINGS_CONTROLLER`
  `"getAllBookings"`
  `public static final String`
  `GET_ALL_ORDERS_CONTROLLER`
  `"getAllOrders"`
  `public static final String`
  `GET_APARTMENT_DETAILS_CONTROLLER`
  `"getApartmentDetails"`
  `public static final String`
  `GET_APARTMENTS_CONTROLLER`
  `"getApartments"`
  `public static final String`
  `GET_BOOKINGS_CONTROLLER`
  `"getBookings"`
  `public static final String`
  `GET_ORDERS_CONTROLLER`
  `"getOrders"`
  `public static final String`
  `GET_RESPONSE_TO_ORDER_CONTROLLER`
  `"getResponseToOrder"`
  `public static final String`
  `INDEX_JSP`
  `"/index.jsp"`
  `public static final String`
  `INITIALIZE_CONTROLLER`
  `"/front?controller="`
  `public static final String`
  `LOGIN_CONTROLLER`
  `"login"`
  `public static final String`
  `LOGIN_JSP`
  `"/pages/login.jsp"`
  `public static final String`
  `LOGOUT_CONTROLLER`
  `"logout"`
  `public static final String`
  `MAKE_PAYMENT_FOR_BOOKING`
  `"makePaymentForBooking"`
  `public static final String`
  `NEW_BOOKING_CONTROLLER`
  `"newBooking"`
  `public static final String`
  `NEW_BOOKING_JSP`
  `"/pages/booking/newBooking.jsp"`
  `public static final String`
  `NEW_ORDER_CONTROLLER`
  `"newOrder"`
  `public static final String`
  `NEW_ORDER_JSP`
  `"/pages/order/newOrder.jsp"`
  `public static final String`
  `NEW_RESPONSE_TO_ORDER_CONTROLLER`
  `"newResponseToOrder"`
  `public static final String`
  `NEW_RESPONSE_TO_ORDER_JSP`
  `"/pages/responseToOrder/newResponseToOrder.jsp"`
  `public static final String`
  `ORDERS_JSP`
  `"/pages/order/orders.jsp"`
  `public static final String`
  `REGISTRATION_CONTROLLER`
  `"registration"`
  `public static final String`
  `RESPONSE_TO_ORDER_JSP`
  `"/pages/responseToOrder/responseToOrder.jsp"`
  `public static final String`
  `SEARCH_APARTMENT_CONTROLLER`
  `"searchApartment"`
  `public static final String`
  `SECURITY`
  `"security"`
  `public static final String`
  `SECURITY_PATH`
  `"/WEB-INF/security/security.xml"`
  `public static final String`
  `UPDATE_ACCOUNT_CONTROLLER`
  `"updateAccount"`
- com.rosivanyshyn.controller.dispatcher.ControllerMessageConstant
  Modifier and Type
  Constant Field
  Value
  `public static final String`
  `ACCOUNT_NOTHING_UPDATE`
  `"app.message.account.nothingUpdate"`
  `public static final String`
  `ACCOUNT_SUCCEED_LOGOUT`
  `"app.message.logout"`
  `public static final String`
  `ACCOUNT_SUCCEED_REGISTRATION`
  `"app.message.registration"`
  `public static final String`
  `ACCOUNT_SUCCEED_UPDATE`
  `"app.message.account.update"`
  `public static final String`
  `APARTMENT_SUCCEED_DELETE`
  `"app.message.apartment.delete"`
  `public static final String`
  `BOOKING_SUCCEED_CREATE`
  `"app.message.booking.create"`
  `public static final String`
  `BOOKING_SUCCEED_DELETE`
  `"app.message.booking.delete"`
  `public static final String`
  `BOOKING_SUCCEED_PAYMENT`
  `"app.message.booking.makePaymentForBooking"`
  `public static final String`
  `ORDER_DONT_HAVE_ACCESS_TO_DELETE`
  `"app.message.order.dontHaveAccessToDelete"`
  `public static final String`
  `ORDER_SUCCEED_CREATE`
  `"app.message.order.create"`
  `public static final String`
  `ORDER_SUCCEED_DELETE`
  `"app.message.order.delete"`
  `public static final String`
  `RESPONSE_TO_ORDER_SUCCEED_CREATE`
  `"app.message.responseToOrder.create"`

- com.rosivanyshyn.db.dao.constant.Field
  Modifier and Type
  Constant Field
  Value
  `public static final String`
  `ACCOUNT_EMAIL`
  `"email"`
  `public static final String`
  `ACCOUNT_FIRST_NAME`
  `"first_name"`
  `public static final String`
  `ACCOUNT_LAST_NAME`
  `"last_name"`
  `public static final String`
  `ACCOUNT_PASSWORD`
  `"password"`
  `public static final String`
  `ACCOUNT_ROLE`
  `"role"`
  `public static final String`
  `APARTMENT`
  `"apartment"`
  `public static final String`
  `APARTMENT_ADRESS`
  `"address"`
  `public static final String`
  `APARTMENT_CLASS`
  `"apartment_class"`
  `public static final String`
  `APARTMENT_DESCRIPTION`
  `"description"`
  `public static final String`
  `APARTMENT_IMAGE_URL`
  `"imageURL"`
  `public static final String`
  `APARTMENT_MAX_GUEST_NUMBER`
  `"max_guests_number"`
  `public static final String`
  `APARTMENT_PRICE`
  `"price"`
  `public static final String`
  `APARTMENT_ROOMS_NUMBER`
  `"rooms_number"`
  `public static final String`
  `APARTMENT_TITLE`
  `"title"`
  `public static final String`
  `BOOKING`
  `"booking"`
  `public static final String`
  `BOOKING_ACCOUNT_ID`
  `"account_id"`
  `public static final String`
  `BOOKING_APARTMENT_ID`
  `"apartment_id"`
  `public static final String`
  `BOOKING_CHECK_IN_DATE`
  `"check_in_date"`
  `public static final String`
  `BOOKING_CHECK_OUT_DATE`
  `"check_out_date"`
  `public static final String`
  `BOOKING_GUESTS_NUMBER`
  `"guests_number"`
  `public static final String`
  `BOOKING_IS_PAID_FOR_RESERVATION`
  `"is_paid_for_reservation"`
  `public static final String`
  `BOOKING_RESERVATION_DATA`
  `"reservation_data"`
  `public static final String`
  `ENTITY_ID`
  `"id"`
  `public static final String`
  `ENTITY_STATE`
  `"state"`
  `public static final String`
  `ORDER_ACCOUNT_ID`
  `"account_id"`
  `public static final String`
  `ORDER_APARTMENT_CLASS`
  `"apartment_class"`
  `public static final String`
  `ORDER_APARTMENT_PRICE`
  `"price"`
  `public static final String`
  `ORDER_CHECK_IN_DATE`
  `"check_in_date"`
  `public static final String`
  `ORDER_CHECK_OUT_DATE`
  `"check_out_date"`
  `public static final String`
  `ORDER_DESCRIPTION`
  `"description"`
  `public static final String`
  `ORDER_GUESTS_NUMBER`
  `"guests_number"`
  `public static final String`
  `ORDER_RESPONSE_TO_ORDER_ID`
  `"response_to_order_id"`
  `public static final String`
  `ORDER_ROOMS_NUMBER`
  `"rooms_number"`
  `public static final String`
  `RESPONSE_TO_ORDER_DESKR`
  `"description"`
  `public static final String`
  `RESPONSE_TO_ORDER_HAS_APARTMENT`
  `"response_to_order_has_apartment"`
  `public static final String`
  `RESPONSE_TO_ORDER_HAS_APARTMENT_AP_ID`
  `"apartment_id"`
  `public static final String`
  `RESPONSE_TO_ORDER_HAS_APARTMENT_RS_ID`
  `"response_to_order_id"`
- com.rosivanyshyn.db.dao.constant.Query
  Modifier and Type
  Constant Field
  Value
  `public static final String`
  `COUNT_ROWS_IN_LAST_QUERY`
  `"SELECT FOUND_ROWS() AS count"`
  `public static final String`
  `CREATE_EVENT_IS_BILL_PAID`
  `"CREATE EVENT %s ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE DO DELETE FROM `hotel`.`booking` WHERE id = ? AND is_paid_for_reservation = 0"`
  `public static final String`
  `DELETE_ACCOUNT`
  `"DELETE FROM account WHERE id = ?"`
  `public static final String`
  `DELETE_APARTMENT`
  `"DELETE FROM apartment WHERE id = ?"`
  `public static final String`
  `DELETE_BOOKING`
  `"DELETE FROM booking WHERE id = ?"`
  `public static final String`
  `DELETE_ORDER`
  `"DELETE FROM `order` WHERE id = ?"`
  `public static final String`
  `DELETE_RESPONSE_TO_ORDER`
  `"DELETE FROM `response_to_order` WHERE id = ?"`
  `public static final String`
  `DELETE_RESPONSE_TO_ORDER_APARTMENTS`
  `"DELETE FROM `response_to_order_has_apartment` WHERE response_to_order_id = ?"`
  `public static final String`
  `INSERT_ACCOUNT`
  `"INSERT INTO account VALUES (DEFAULT, ?, ?, ?, ?, ?, ?)"`
  `public static final String`
  `INSERT_APARTMENT`
  `"INSERT INTO apartment VALUES (DEFAULT, ?, ?, ?, ?, ?, ?, ?, ?, ?)"`
  `public static final String`
  `INSERT_BOOKING`
  `"INSERT INTO booking VALUES (DEFAULT, ?, ?, ?, ?, ?, ?, ?)"`
  `public static final String`
  `INSERT_ORDER`
  `"INSERT INTO `order` VALUES (DEFAULT, ?, ?, ?, ?, ?, ?, ?, ?, DEFAULT)"`
  `public static final String`
  `INSERT_RESPONSE_TO_ORDER`
  `"INSERT INTO `response_to_order` VALUES (DEFAULT, ?)"`
  `public static final String`
  `INSERT_RESPONSE_TO_ORDER_APARTMENTS`
  `"INSERT INTO `response_to_order_has_apartment` VALUES (?, ?)"`
  `public static final String`
  `SEARCH_APARTMENTS`
  `"SELECT SQL_CALC_FOUND_ROWS *, MATCH(`title`, `description`, `address`, `apartment_class`) AGAINST(? IN BOOLEAN MODE) AS REL FROM hotel.apartment WHERE MATCH(`title`, `description`, `address`, `apartment_class`) AGAINST(? IN BOOLEAN MODE) ORDER BY REL LIMIT ?, ? "`
  `public static final String`
  `SELECT_ACCOUNT`
  `"SELECT * FROM account WHERE id = ?"`
  `public static final String`
  `SELECT_ACCOUNT_BY_FIELD`
  `"SELECT * FROM account WHERE %s LIKE ?"`
  `public static final String`
  `SELECT_ALL_ACCOUNTS`
  `"SELECT * FROM account "`
  `public static final String`
  `SELECT_ALL_APARTMENTS`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM apartment "`
  `public static final String`
  `SELECT_ALL_BOOKINGS`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM booking "`
  `public static final String`
  `SELECT_ALL_ORDERS`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM `order` "`
  `public static final String`
  `SELECT_ALL_RESPONSES_TO_ORDER`
  `"SELECT * FROM `response_to_order` "`
  `public static final String`
  `SELECT_APARTMENT`
  `"SELECT * FROM apartment WHERE id = ?"`
  `public static final String`
  `SELECT_APARTMENT_BY_FIELD`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM apartment WHERE %s LIKE ?"`
  `public static final String`
  `SELECT_BOOKING`
  `"SELECT * FROM booking WHERE id = ?"`
  `public static final String`
  `SELECT_BOOKING_BY_FIELD`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM booking WHERE %s LIKE ?"`
  `public static final String`
  `SELECT_FEW_ACCOUNTS`
  `"SELECT * FROM account LIMIT ?, ?"`
  `public static final String`
  `SELECT_FEW_APARTMENTS`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM apartment LIMIT ?, ?"`
  `public static final String`
  `SELECT_FEW_BOOKINGS`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM booking LIMIT ?, ?"`
  `public static final String`
  `SELECT_FEW_ORDERS`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM `order` LIMIT ?, ?"`
  `public static final String`
  `SELECT_FEW_RESPONSES_TO_ORDER`
  `"SELECT * FROM `response_to_order` LIMIT ?, ?"`
  `public static final String`
  `SELECT_ORDER`
  `"SELECT * FROM `order` WHERE id = ?"`
  `public static final String`
  `SELECT_ORDER_BY_FIELD`
  `"SELECT SQL_CALC_FOUND_ROWS * FROM `order` WHERE %s LIKE ?"`
  `public static final String`
  `SELECT_RESPONSE_TO_ORDER`
  `"SELECT * FROM `response_to_order` WHERE id = ?"`
  `public static final String`
  `SELECT_RESPONSE_TO_ORDER_APARTMENTS`
  `"SELECT ap.id, ap.title, ap.description, ap.imageURL, ap.address, ap.max_guests_number, ap.rooms_number, ap.apartment_class, ap.price, ap.state FROM hotel.`response_to_order_has_apartment` as rto_ap JOIN hotel.`apartment` AS ap ON ap.id = rto_ap.apartment_id WHERE rto_ap.response_to_order_id = ?"`
  `public static final String`
  `SELECT_RESPONSE_TO_ORDER_BY_FIELD`
  `"SELECT * FROM `response_to_order` WHERE %s LIKE ?"`
  `public static final String`
  `UNIQUE_APARTMENTS_WHICH_ARE_BOOKED`
  `"INNER JOIN (SELECT DISTINCT `apartment`.`id` FROM apartment INNER JOIN `booking` booking ON booking.`apartment_id` = `apartment`.`id`) AS a2 ON `apartment`.`id` = a2.`id` %s"`
  `public static final String`
  `UNIQUE_APARTMENTS_WHICH_ARE_BOOKED_AND_ACTUAL`
  `"INNER JOIN (SELECT DISTINCT `apartment`.`id` FROM apartment INNER JOIN `booking` booking ON booking.`apartment_id` = `apartment`.`id` WHERE `booking`.`check_in_date` >= CURRENT_DATE() OR `booking`.`check_out_date` >= CURRENT_DATE() ) AS a2 ON `apartment`.`id` = a2.`id` %s"`
  `public static final String`
  `UNIQUE_APARTMENTS_WHICH_ARE_FREE_AND_ACTUAL`
  `"WHERE `id` NOT IN (SELECT DISTINCT `apartment`.`id` FROM apartment INNER JOIN `booking` booking ON booking.`apartment_id` = `apartment`.`id` WHERE `booking`.`check_in_date` >= CURRENT_DATE() OR `booking`.`check_out_date` >= CURRENT_DATE() ) AND State = 1 %s"`
  `public static final String`
  `UPDATE_ACCOUNT`
  `"UPDATE `account` SET `role` = ?, `first_name` = ?, `last_name` = ?, `email` = ?, `password` = ?, `state` = ? WHERE `id` = ?"`
  `public static final String`
  `UPDATE_APARTMENT`
  `"UPDATE apartment SET `title` = ?, `description` = ?, `imageURL` = ?, `address` = ?, `max_guests_number` = ?, `rooms_number` = ?, `apartment_class` = ?, `price` = ?, `state` = ? WHERE `id` = ?"`
  `public static final String`
  `UPDATE_BOOKING`
  `"UPDATE `booking` SET `guests_number` = ?, `check_in_date` = ?, `check_out_date` = ?, `is_paid_for_reservation` = ?, `account_id` = ?,`apartment_id` = ? WHERE `id` = ?"`
  `public static final String`
  `UPDATE_ORDER`
  `"UPDATE `order` SET `guests_number` = ?, `rooms_number` = ?, `apartment_class` = ?, `price` = ?, `description` = ?, `check_out_date` = ?, `check_in_date` = ?, `response_to_order_id` = ? WHERE `id` = ?"`
  `public static final String`
  `UPDATE_RESPONSE_TO_ORDER`
  `"UPDATE `response_to_order`SET `description` = ? WHERE `id` = ? "`

- com.rosivanyshyn.exeption.Message
  Modifier and Type
  Constant Field
  Value
  `public static final String`
  `ACCOUNT_DETAILS_ERROR`
  `"Cannot get Account Details"`
  `public static final String`
  `ACCOUNT_ISNT_EXIST`
  `"Account isn`t exist!"`
  `public static final String`
  `ACCOUNT_LOGIN_ERROR`
  `"Cannot log in account"`
  `public static final String`
  `ACCOUNT_LOGOUT_ERROR`
  `"Cannot log out"`
  `public static final String`
  `ACCOUNT_REGISTRATION_ERROR`
  `"Cannot registration account"`
  `public static final String`
  `ACCOUNT_UPDATE_ERROR`
  `"Cannot update account"`
  `public static final String`
  `APARTMENT_DELETE_ERROR`
  `"Cannot delete Apartment"`
  `public static final String`
  `APARTMENT_GET_DETAILS_ERROR`
  `"Cannot get Apartment Details"`
  `public static final String`
  `APARTMENTS_GET_ERROR`
  `"Cannot get Apartments"`
  `public static final String`
  `BOOKING_ALREADY_EXIST_ON_THIS_DATE`
  `"validation.error.bookingAlreadyExistOnThisDate"`
  `public static final String`
  `BOOKING_CREATE_ERROR`
  `"Cannot booking apartment"`
  `public static final String`
  `BOOKING_DELETE_ERROR`
  `"Cannot delete booking"`
  `public static final String`
  `BOOKING_GET_CREATE_PAGE_ERROR`
  `"Cannot get create-booking page"`
  `public static final String`
  `BOOKING_PAYMENT_ERROR`
  `"Cannot make payment for booking"`
  `public static final String`
  `BOOKINGS_GET_ALL_ERROR`
  `"Cannot get All Bookings"`
  `public static final String`
  `BOOKINGS_GET_ERROR`
  `"Cannot get Bookings"`
  `public static final String`
  `COUNT_ROWS_ERROR`
  `"Cannot count rows of the last query"`
  `public static final String`
  `DELETE_ERROR`
  `"Cannot delete row by given id"`
  `public static final String`
  `EVENT_IS_BILL_PAID_ERROR`
  `"Cannot create event is-bill-paid by given id"`
  `public static final String`
  `INCORRECT_ACCOUNT_EMAIL`
  `"validation.error.email.format"`
  `public static final String`
  `INCORRECT_ACCOUNT_FIRST_NAME`
  `"validation.error.firstName.format"`
  `public static final String`
  `INCORRECT_ACCOUNT_LAST_NAME`
  `"validation.error.lastName.format"`
  `public static final String`
  `INCORRECT_ACCOUNT_PASSWORD`
  `"validation.error.password.format"`
  `public static final String`
  `INCORRECT_ACCOUNT_ROLE`
  `"validation.error.role.format"`
  `public static final String`
  `INCORRECT_APARTMENT_ADDRESS`
  `"validation.error.address.format"`
  `public static final String`
  `INCORRECT_APARTMENT_CLASS`
  `"validation.error.apartmentClass.format"`
  `public static final String`
  `INCORRECT_APARTMENT_IMAGE`
  `"validation.error.image.format"`
  `public static final String`
  `INCORRECT_APARTMENT_MAX_GUESTS_NUMBER`
  `"validation.error.maxGuestsNumber.format"`
  `public static final String`
  `INCORRECT_APARTMENT_PRICE`
  `"validation.error.price.format"`
  `public static final String`
  `INCORRECT_APARTMENT_ROOMS_NUMBER`
  `"validation.error.roomsNumber.format"`
  `public static final String`
  `INCORRECT_APARTMENT_TITLE`
  `"validation.error.title.format"`
  `public static final String`
  `INCORRECT_BOOKING_DATE`
  `"validation.error.bookingDate.format"`
  `public static final String`
  `INCORRECT_DESCRIPTION`
  `"validation.error.description.format"`
  `public static final String`
  `INCORRECT_GUESTS_NUMBER`
  `"validation.error.guestsNumber.format"`
  `public static final String`
  `INCORRECT_SORTING_ORDER`
  `"Input sorting order doesn`t exist"`
  `public static final String`
  `INSERT_ERROR`
  `"Cannot create row"`
  `public static final String`
  `LANGUAGE_CHANGE_ERROR`
  `"Cannot change language"`
  `public static final String`
  `MANY_TO_MANY_ERROR`
  `"Cannot operate with ManyToMany"`
  `public static final String`
  `ORDER_CREATE_ERROR`
  `"Cannot create order"`
  `public static final String`
  `ORDER_DELETE_ERROR`
  `"Cannot delete order"`
  `public static final String`
  `ORDER_GET_CREATE_PAGE_ERROR`
  `"Cannot get create-order page"`
  `public static final String`
  `ORDERS_GET_ALL_ERROR`
  `"Cannot get All Orders"`
  `public static final String`
  `ORDERS_GET_ERROR`
  `"Cannot get Orders"`
  `public static final String`
  `RESPONSE_TO_ORDER_CREATE_ERROR`
  `"Cannot create response to order"`
  `public static final String`
  `RESPONSE_TO_ORDER_GET_CREATE_PAGE_ERROR`
  `"Cannot get create-response to order page"`
  `public static final String`
  `RESPONSE_TO_ORDER_GET_ERROR`
  `"Cannot get Response to order"`
  `public static final String`
  `SEARCH_ERROR`
  `"Cannot search"`
  `public static final String`
  `SELECT_ALL_ERROR`
  `"Cannot find all rows"`
  `public static final String`
  `SELECT_BY_FIELD_ERROR`
  `"Cannot find row by given field and value"`
  `public static final String`
  `SELECT_DYNAMIC_ERROR`
  `"Cannot find row by given query or fields"`
  `public static final String`
  `SELECT_ERROR`
  `"Cannot find row"`
  `public static final String`
  `SELECT_FEW_ERROR`
  `"Cannot find few rows"`
  `public static final String`
  `UPDATE_ERROR`
  `"Cannot update row by given object"`