/
Bungus
/
ShoesIS
Обзор
Документация
Войти
/
Bungus
/
ShoesIS
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
exportToHTML/com/example/obuv/Controller/OrdersListController.java.html
217 строк
31 KB
Шоин Максим
Добавлен проект ИС магазина обуви
28 май 2026, 14:47
28 май 2026, 14:47
383b797
Код
Авторство
О чём код?
<html> <head> <title>OrdersListController.java</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <style type="text/css"> .s0 { color: #cf8e6d;} .s1 { color: #bcbec4;} .s2 { color: #bcbec4;} .s3 { color: #6aab73;} .s4 { color: #2aacb8;} </style> </head> <body bgcolor="#1e1f22"> <table CELLSPACING=0 CELLPADDING=5 COLS=1 WIDTH="100%" BGCOLOR="#606060" > <tr><td><center> <font face="Arial, Helvetica" color="#000000"> OrdersListController.java</font> </center></td></tr></table> <pre><span class="s0">package </span><span class="s1">com</span><span class="s2">.</span><span class="s1">example</span><span class="s2">.</span><span class="s1">obuv</span><span class="s2">.</span><span class="s1">Controller</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">com</span><span class="s2">.</span><span class="s1">example</span><span class="s2">.</span><span class="s1">obuv</span><span class="s2">.</span><span class="s1">DBHandler</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">com</span><span class="s2">.</span><span class="s1">example</span><span class="s2">.</span><span class="s1">obuv</span><span class="s2">.</span><span class="s1">HelloApplication</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">com</span><span class="s2">.</span><span class="s1">example</span><span class="s2">.</span><span class="s1">obuv</span><span class="s2">.</span><span class="s1">Model</span><span class="s2">.</span><span class="s1">Order</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">com</span><span class="s2">.</span><span class="s1">example</span><span class="s2">.</span><span class="s1">obuv</span><span class="s2">.</span><span class="s1">Service</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">event</span><span class="s2">.</span><span class="s1">ActionEvent</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">fxml</span><span class="s2">.</span><span class="s1">FXML</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">fxml</span><span class="s2">.</span><span class="s1">FXMLLoader</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">scene</span><span class="s2">.</span><span class="s1">Node</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">scene</span><span class="s2">.</span><span class="s1">control</span><span class="s2">.</span><span class="s1">Button</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">scene</span><span class="s2">.</span><span class="s1">control</span><span class="s2">.</span><span class="s1">ListView</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">scene</span><span class="s2">.</span><span class="s1">input</span><span class="s2">.</span><span class="s1">MouseEvent</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">javafx</span><span class="s2">.</span><span class="s1">scene</span><span class="s2">.</span><span class="s1">text</span><span class="s2">.</span><span class="s1">Text</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">java</span><span class="s2">.</span><span class="s1">io</span><span class="s2">.</span><span class="s1">IOException</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">java</span><span class="s2">.</span><span class="s1">sql</span><span class="s2">.</span><span class="s1">ResultSet</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">java</span><span class="s2">.</span><span class="s1">sql</span><span class="s2">.</span><span class="s1">SQLException</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">java</span><span class="s2">.</span><span class="s1">util</span><span class="s2">.</span><span class="s1">ArrayList</span><span class="s2">;</span> <span class="s0">public class </span><span class="s1">OrdersListController </span><span class="s2">{</span> <span class="s1">@FXML</span> <span class="s0">private </span><span class="s1">Button btnBackProducts</span><span class="s2">;</span> <span class="s1">@FXML</span> <span class="s0">private </span><span class="s1">Button btnAddOrder</span><span class="s2">;</span> <span class="s1">@FXML</span> <span class="s0">private </span><span class="s1">Button btnDeleteOrder</span><span class="s2">;</span> <span class="s1">@FXML</span> <span class="s0">private </span><span class="s1">ListView</span><span class="s2"><</span><span class="s1">Node</span><span class="s2">> </span><span class="s1">ordersListView</span><span class="s2">;</span> <span class="s1">@FXML</span> <span class="s0">private </span><span class="s1">Text txtFIO</span><span class="s2">;</span> <span class="s1">@FXML</span> <span class="s0">private </span><span class="s1">Text txtRole</span><span class="s2">;</span> <span class="s0">private final </span><span class="s1">Service service </span><span class="s2">= </span><span class="s0">new </span><span class="s1">Service</span><span class="s2">();</span> <span class="s0">private final </span><span class="s1">DBHandler dbHandler </span><span class="s2">= </span><span class="s0">new </span><span class="s1">DBHandler</span><span class="s2">();</span> <span class="s0">private final </span><span class="s1">ArrayList</span><span class="s2"><</span><span class="s1">Order</span><span class="s2">> </span><span class="s1">orders </span><span class="s2">= </span><span class="s0">new </span><span class="s1">ArrayList</span><span class="s2"><>();</span> <span class="s1">@FXML</span> <span class="s0">public void </span><span class="s1">initialize</span><span class="s2">() </span><span class="s0">throws </span><span class="s1">SQLException</span><span class="s2">, </span><span class="s1">ClassNotFoundException</span><span class="s2">, </span><span class="s1">IOException </span><span class="s2">{</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">Service</span><span class="s2">.</span><span class="s1">user </span><span class="s2">!= </span><span class="s0">null</span><span class="s2">) {</span> <span class="s1">txtFIO</span><span class="s2">.</span><span class="s1">setText</span><span class="s2">(</span><span class="s1">Service</span><span class="s2">.</span><span class="s1">user</span><span class="s2">.</span><span class="s1">getFullName</span><span class="s2">());</span> <span class="s1">txtRole</span><span class="s2">.</span><span class="s1">setText</span><span class="s2">(</span><span class="s1">Service</span><span class="s2">.</span><span class="s1">user</span><span class="s2">.</span><span class="s1">getRole</span><span class="s2">());</span> <span class="s0">if </span><span class="s2">(!</span><span class="s1">Service</span><span class="s2">.</span><span class="s1">user</span><span class="s2">.</span><span class="s1">getRole</span><span class="s2">().</span><span class="s1">equals</span><span class="s2">(</span><span class="s3">"Администратор"</span><span class="s2">)) {</span> <span class="s1">btnAddOrder</span><span class="s2">.</span><span class="s1">setVisible</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s1">btnAddOrder</span><span class="s2">.</span><span class="s1">setManaged</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s1">btnDeleteOrder</span><span class="s2">.</span><span class="s1">setVisible</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s1">btnDeleteOrder</span><span class="s2">.</span><span class="s1">setManaged</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s2">}</span> <span class="s2">} </span><span class="s0">else </span><span class="s2">{</span> <span class="s1">txtFIO</span><span class="s2">.</span><span class="s1">setText</span><span class="s2">(</span><span class="s3">""</span><span class="s2">);</span> <span class="s1">txtRole</span><span class="s2">.</span><span class="s1">setText</span><span class="s2">(</span><span class="s3">"Гость"</span><span class="s2">);</span> <span class="s1">btnAddOrder</span><span class="s2">.</span><span class="s1">setVisible</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s1">btnAddOrder</span><span class="s2">.</span><span class="s1">setManaged</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s1">btnDeleteOrder</span><span class="s2">.</span><span class="s1">setVisible</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s1">btnDeleteOrder</span><span class="s2">.</span><span class="s1">setManaged</span><span class="s2">(</span><span class="s0">false</span><span class="s2">);</span> <span class="s2">}</span> <span class="s1">loadOrders</span><span class="s2">();</span> <span class="s1">loadOrdersInLV</span><span class="s2">();</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"OrdersListController инициализирован"</span><span class="s2">);</span> <span class="s2">}</span> <span class="s1">@FXML</span> <span class="s0">public void </span><span class="s1">btnBackProductsClick</span><span class="s2">(</span><span class="s1">ActionEvent actionEvent</span><span class="s2">) </span><span class="s0">throws </span><span class="s1">IOException </span><span class="s2">{</span> <span class="s1">service</span><span class="s2">.</span><span class="s1">loadScene</span><span class="s2">(</span><span class="s3">"ProductsList.fxml"</span><span class="s2">, </span><span class="s3">"Список товаров"</span><span class="s2">);</span> <span class="s1">btnBackProducts</span><span class="s2">.</span><span class="s1">getScene</span><span class="s2">().</span><span class="s1">getWindow</span><span class="s2">().</span><span class="s1">hide</span><span class="s2">();</span> <span class="s2">}</span> <span class="s1">@FXML</span> <span class="s0">public void </span><span class="s1">btnAddOrderClick</span><span class="s2">(</span><span class="s1">ActionEvent actionEvent</span><span class="s2">) </span><span class="s0">throws </span><span class="s1">IOException </span><span class="s2">{</span> <span class="s1">Service</span><span class="s2">.</span><span class="s1">order </span><span class="s2">= </span><span class="s0">null</span><span class="s2">;</span> <span class="s1">service</span><span class="s2">.</span><span class="s1">loadScene</span><span class="s2">(</span><span class="s3">"AddEditOrder.fxml"</span><span class="s2">, </span><span class="s3">"Добавление заказа"</span><span class="s2">);</span> <span class="s1">btnAddOrder</span><span class="s2">.</span><span class="s1">getScene</span><span class="s2">().</span><span class="s1">getWindow</span><span class="s2">().</span><span class="s1">hide</span><span class="s2">();</span> <span class="s2">}</span> <span class="s1">@FXML</span> <span class="s0">public void </span><span class="s1">deleteOrderLV</span><span class="s2">(</span><span class="s1">ActionEvent actionEvent</span><span class="s2">) </span><span class="s0">throws </span><span class="s1">SQLException</span><span class="s2">, </span><span class="s1">ClassNotFoundException</span><span class="s2">, </span><span class="s1">IOException </span><span class="s2">{</span> <span class="s0">int </span><span class="s1">selectedIndex </span><span class="s2">= </span><span class="s1">ordersListView</span><span class="s2">.</span><span class="s1">getSelectionModel</span><span class="s2">().</span><span class="s1">getSelectedIndex</span><span class="s2">();</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">selectedIndex </span><span class="s2">< </span><span class="s4">0</span><span class="s2">) {</span> <span class="s1">service</span><span class="s2">.</span><span class="s1">showAlert</span><span class="s2">(</span><span class="s3">"Предупреждение"</span><span class="s2">, </span><span class="s3">"Выберите заказ для удаления"</span><span class="s2">, </span><span class="s4">0</span><span class="s2">);</span> <span class="s0">return</span><span class="s2">;</span> <span class="s2">}</span> <span class="s1">Order selectedOrder </span><span class="s2">= </span><span class="s1">orders</span><span class="s2">.</span><span class="s1">get</span><span class="s2">(</span><span class="s1">selectedIndex</span><span class="s2">);</span> <span class="s0">int </span><span class="s1">orderNumber </span><span class="s2">= </span><span class="s1">selectedOrder</span><span class="s2">.</span><span class="s1">getOrderNumber</span><span class="s2">();</span> <span class="s1">dbHandler</span><span class="s2">.</span><span class="s1">DBConnection</span><span class="s2">();</span> <span class="s1">String deleteProductsOrders </span><span class="s2">= </span><span class="s1">String</span><span class="s2">.</span><span class="s1">format</span><span class="s2">(</span><span class="s3">"DELETE FROM products_orders WHERE </span><span class="s0">\"</span><span class="s3">order</span><span class="s0">\"</span><span class="s3">=%d"</span><span class="s2">, </span><span class="s1">orderNumber</span><span class="s2">);</span> <span class="s1">dbHandler</span><span class="s2">.</span><span class="s1">executeUpdate</span><span class="s2">(</span><span class="s1">deleteProductsOrders</span><span class="s2">);</span> <span class="s1">String deleteOrder </span><span class="s2">= </span><span class="s1">String</span><span class="s2">.</span><span class="s1">format</span><span class="s2">(</span><span class="s3">"DELETE FROM orders WHERE order_number=%d"</span><span class="s2">, </span><span class="s1">orderNumber</span><span class="s2">);</span> <span class="s0">int </span><span class="s1">count </span><span class="s2">= </span><span class="s1">dbHandler</span><span class="s2">.</span><span class="s1">executeUpdate</span><span class="s2">(</span><span class="s1">deleteOrder</span><span class="s2">);</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">count </span><span class="s2">> </span><span class="s4">0</span><span class="s2">) {</span> <span class="s1">service</span><span class="s2">.</span><span class="s1">showAlert</span><span class="s2">(</span><span class="s3">"Информация"</span><span class="s2">, </span><span class="s3">"Заказ удалён"</span><span class="s2">, </span><span class="s4">2</span><span class="s2">);</span> <span class="s2">} </span><span class="s0">else </span><span class="s2">{</span> <span class="s1">service</span><span class="s2">.</span><span class="s1">showAlert</span><span class="s2">(</span><span class="s3">"Ошибка"</span><span class="s2">, </span><span class="s3">"Заказ не удалён"</span><span class="s2">, </span><span class="s4">1</span><span class="s2">);</span> <span class="s0">return</span><span class="s2">;</span> <span class="s2">}</span> <span class="s1">loadOrders</span><span class="s2">();</span> <span class="s1">loadOrdersInLV</span><span class="s2">();</span> <span class="s2">}</span> <span class="s1">@FXML</span> <span class="s0">public void </span><span class="s1">handleOrdersListClick</span><span class="s2">(</span><span class="s1">MouseEvent mouseEvent</span><span class="s2">) </span><span class="s0">throws </span><span class="s1">IOException </span><span class="s2">{</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Клик по ListView, количество кликов: " </span><span class="s2">+ </span><span class="s1">mouseEvent</span><span class="s2">.</span><span class="s1">getClickCount</span><span class="s2">());</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">mouseEvent</span><span class="s2">.</span><span class="s1">getClickCount</span><span class="s2">() == </span><span class="s4">2</span><span class="s2">) {</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Двойной щелчок обнаружен"</span><span class="s2">);</span> <span class="s0">int </span><span class="s1">selectedIndex </span><span class="s2">= </span><span class="s1">ordersListView</span><span class="s2">.</span><span class="s1">getSelectionModel</span><span class="s2">().</span><span class="s1">getSelectedIndex</span><span class="s2">();</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Выбранный индекс: " </span><span class="s2">+ </span><span class="s1">selectedIndex</span><span class="s2">);</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">selectedIndex </span><span class="s2">>= </span><span class="s4">0</span><span class="s2">) {</span> <span class="s1">Order selectedOrder </span><span class="s2">= </span><span class="s1">orders</span><span class="s2">.</span><span class="s1">get</span><span class="s2">(</span><span class="s1">selectedIndex</span><span class="s2">);</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Выбран заказ №" </span><span class="s2">+ </span><span class="s1">selectedOrder</span><span class="s2">.</span><span class="s1">getOrderNumber</span><span class="s2">());</span> <span class="s1">Service</span><span class="s2">.</span><span class="s1">order </span><span class="s2">= </span><span class="s1">selectedOrder</span><span class="s2">;</span> <span class="s1">service</span><span class="s2">.</span><span class="s1">loadScene</span><span class="s2">(</span><span class="s3">"AddEditOrder.fxml"</span><span class="s2">, </span><span class="s3">"Редактирование заказа"</span><span class="s2">);</span> <span class="s1">ordersListView</span><span class="s2">.</span><span class="s1">getScene</span><span class="s2">().</span><span class="s1">getWindow</span><span class="s2">().</span><span class="s1">hide</span><span class="s2">();</span> <span class="s2">} </span><span class="s0">else </span><span class="s2">{</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Ничего не выбрано"</span><span class="s2">);</span> <span class="s2">}</span> <span class="s2">}</span> <span class="s2">}</span> <span class="s0">private void </span><span class="s1">loadOrders</span><span class="s2">() </span><span class="s0">throws </span><span class="s1">SQLException</span><span class="s2">, </span><span class="s1">ClassNotFoundException </span><span class="s2">{</span> <span class="s1">dbHandler</span><span class="s2">.</span><span class="s1">DBConnection</span><span class="s2">();</span> <span class="s1">String query </span><span class="s2">= </span><span class="s3">"SELECT o.order_number, o.order_article, o.order_status, " </span><span class="s2">+</span> <span class="s3">"o.order_date, o.delivery_date, o.pick_up_address, o.client, " </span><span class="s2">+</span> <span class="s3">"u.full_name, o.code_to_receive, po.product, po.product_quantity, " </span><span class="s2">+</span> <span class="s3">"pp.city, pp.street, pp.building_number " </span><span class="s2">+</span> <span class="s3">"FROM orders o " </span><span class="s2">+</span> <span class="s3">"INNER JOIN pick_up_points pp ON o.pick_up_address = pp.</span><span class="s0">\"</span><span class="s3">index</span><span class="s0">\" </span><span class="s3">" </span><span class="s2">+</span> <span class="s3">"INNER JOIN users u ON o.client = u.id " </span><span class="s2">+</span> <span class="s3">"LEFT JOIN products_orders po ON po.</span><span class="s0">\"</span><span class="s3">order</span><span class="s0">\" </span><span class="s3">= o.order_number " </span><span class="s2">+</span> <span class="s3">"ORDER BY o.order_number"</span><span class="s2">;</span> <span class="s1">ResultSet rs </span><span class="s2">= </span><span class="s1">dbHandler</span><span class="s2">.</span><span class="s1">executeQuery</span><span class="s2">(</span><span class="s1">query</span><span class="s2">);</span> <span class="s1">createOrdersList</span><span class="s2">(</span><span class="s1">rs</span><span class="s2">);</span> <span class="s2">}</span> <span class="s0">private void </span><span class="s1">createOrdersList</span><span class="s2">(</span><span class="s1">ResultSet rs</span><span class="s2">) </span><span class="s0">throws </span><span class="s1">SQLException </span><span class="s2">{</span> <span class="s1">orders</span><span class="s2">.</span><span class="s1">clear</span><span class="s2">();</span> <span class="s0">while </span><span class="s2">(</span><span class="s1">rs</span><span class="s2">.</span><span class="s1">next</span><span class="s2">()) {</span> <span class="s0">int </span><span class="s1">orderNumber </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getInt</span><span class="s2">(</span><span class="s3">"order_number"</span><span class="s2">);</span> <span class="s1">String orderArticle </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getString</span><span class="s2">(</span><span class="s3">"order_article"</span><span class="s2">);</span> <span class="s1">String orderStatus </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getString</span><span class="s2">(</span><span class="s3">"order_status"</span><span class="s2">);</span> <span class="s1">String orderDate </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getDate</span><span class="s2">(</span><span class="s3">"order_date"</span><span class="s2">) != </span><span class="s0">null </span><span class="s2">?</span> <span class="s1">rs</span><span class="s2">.</span><span class="s1">getDate</span><span class="s2">(</span><span class="s3">"order_date"</span><span class="s2">).</span><span class="s1">toString</span><span class="s2">() : </span><span class="s3">"Дата не указана"</span><span class="s2">;</span> <span class="s1">String deliveryDate </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getDate</span><span class="s2">(</span><span class="s3">"delivery_date"</span><span class="s2">) != </span><span class="s0">null </span><span class="s2">?</span> <span class="s1">rs</span><span class="s2">.</span><span class="s1">getDate</span><span class="s2">(</span><span class="s3">"delivery_date"</span><span class="s2">).</span><span class="s1">toString</span><span class="s2">() : </span><span class="s3">"Дата не указана"</span><span class="s2">;</span> <span class="s0">int </span><span class="s1">pickUpId </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getInt</span><span class="s2">(</span><span class="s3">"pick_up_address"</span><span class="s2">);</span> <span class="s0">int </span><span class="s1">clientId </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getInt</span><span class="s2">(</span><span class="s3">"client"</span><span class="s2">);</span> <span class="s1">String clientName </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getString</span><span class="s2">(</span><span class="s3">"full_name"</span><span class="s2">);</span> <span class="s0">int </span><span class="s1">code </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getInt</span><span class="s2">(</span><span class="s3">"code_to_receive"</span><span class="s2">);</span> <span class="s1">String productArticle </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getString</span><span class="s2">(</span><span class="s3">"product"</span><span class="s2">) != </span><span class="s0">null </span><span class="s2">? </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getString</span><span class="s2">(</span><span class="s3">"product"</span><span class="s2">) : </span><span class="s3">""</span><span class="s2">;</span> <span class="s0">int </span><span class="s1">productQuantity </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getInt</span><span class="s2">(</span><span class="s3">"product_quantity"</span><span class="s2">);</span> <span class="s1">String address </span><span class="s2">= </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getString</span><span class="s2">(</span><span class="s3">"city"</span><span class="s2">) + </span><span class="s3">", " </span><span class="s2">+ </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getString</span><span class="s2">(</span><span class="s3">"street"</span><span class="s2">) + </span><span class="s3">", " </span><span class="s2">+ </span><span class="s1">rs</span><span class="s2">.</span><span class="s1">getInt</span><span class="s2">(</span><span class="s3">"building_number"</span><span class="s2">);</span> <span class="s1">Order order </span><span class="s2">= </span><span class="s0">new </span><span class="s1">Order</span><span class="s2">(</span><span class="s1">orderNumber</span><span class="s2">, </span><span class="s1">orderArticle</span><span class="s2">, </span><span class="s1">orderStatus</span><span class="s2">,</span> <span class="s1">orderDate</span><span class="s2">, </span><span class="s1">deliveryDate</span><span class="s2">, </span><span class="s1">address</span><span class="s2">, </span><span class="s1">pickUpId</span><span class="s2">, </span><span class="s1">clientId</span><span class="s2">,</span> <span class="s1">clientName</span><span class="s2">, </span><span class="s1">code</span><span class="s2">, </span><span class="s1">productArticle</span><span class="s2">, </span><span class="s1">productQuantity</span><span class="s2">);</span> <span class="s1">orders</span><span class="s2">.</span><span class="s1">add</span><span class="s2">(</span><span class="s1">order</span><span class="s2">);</span> <span class="s2">}</span> <span class="s1">rs</span><span class="s2">.</span><span class="s1">close</span><span class="s2">();</span> <span class="s2">}</span> <span class="s0">private void </span><span class="s1">loadOrdersInLV</span><span class="s2">() </span><span class="s0">throws </span><span class="s1">IOException </span><span class="s2">{</span> <span class="s1">ordersListView</span><span class="s2">.</span><span class="s1">getItems</span><span class="s2">().</span><span class="s1">clear</span><span class="s2">();</span> <span class="s0">for </span><span class="s2">(</span><span class="s1">Order order </span><span class="s2">: </span><span class="s1">orders</span><span class="s2">) {</span> <span class="s1">FXMLLoader fxmlLoader </span><span class="s2">= </span><span class="s0">new </span><span class="s1">FXMLLoader</span><span class="s2">(</span> <span class="s1">HelloApplication</span><span class="s2">.</span><span class="s0">class</span><span class="s2">.</span><span class="s1">getResource</span><span class="s2">(</span><span class="s3">"fxml/OrderCard.fxml"</span><span class="s2">)</span> <span class="s2">);</span> <span class="s1">Node root </span><span class="s2">= </span><span class="s1">fxmlLoader</span><span class="s2">.</span><span class="s1">load</span><span class="s2">();</span> <span class="s1">OrderCardController controller </span><span class="s2">= </span><span class="s1">fxmlLoader</span><span class="s2">.</span><span class="s1">getController</span><span class="s2">();</span> <span class="s1">controller</span><span class="s2">.</span><span class="s1">setOrderCardData</span><span class="s2">(</span><span class="s1">order</span><span class="s2">);</span> <span class="s1">ordersListView</span><span class="s2">.</span><span class="s1">getItems</span><span class="s2">().</span><span class="s1">add</span><span class="s2">(</span><span class="s1">root</span><span class="s2">);</span> <span class="s2">}</span> <span class="s2">}</span> <span class="s2">}</span></pre> </body> </html>