title: ÐÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ Ð´Ð»Ñ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° ÑÑÐµÐ½Ð´Ð¾Ð² ÐºÑÐ¸ÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð°ÑÑÐ¸Ð±ÑÑÐ¾Ð² ÐºÐ°ÑÐµÑÑÐ²Ð° ÑÐ°ÑÐ¼Ð°ÑÐµÐ²ÑÐ¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð°
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: An application for analyzing trends of critical attributes of pharmaceutical production quality
Creators: name: ÐÑÑÐ¶Ð¸Ð½Ð¸Ð½, ÐÐ¸ÐºÐ¾Ð»Ð°Ð¹
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: Java
JavaFx
JDBC
MVC
Appache POI

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«ÐÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ Ð´Ð»Ñ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° ÑÑÐµÐ½Ð´Ð¾Ð² ÐºÑÐ¸ÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð°ÑÑÐ¸Ð±ÑÑÐ¾Ð² ÐºÐ°ÑÐµÑÑÐ²Ð° ÑÐ°ÑÐ¼Ð°ÑÐµÐ²ÑÐ¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð°Â».Ð¦ÐµÐ»Ñ Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ Ð·Ð°ÐºÐ»ÑÑÐ°ÐµÑÑÑ Ð² ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ, Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÑÑÑÐµÐ³Ð¾ Ð¿ÑÐ¾ÑÐµÑÑ Ð½ÐµÐ¿ÑÐµÑÑÐ²Ð½Ð¾Ð¹ Ð²ÐµÑÐ¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¸ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²ÐµÐ½Ð½ÑÑ Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð² Ð½Ð° ÑÐ°ÑÐ¼Ð°ÑÐµÐ²ÑÐ¸ÑÐµÑÐºÐ¾Ð¼ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ðµ. Ð­ÑÐ¾Ñ Ð¿ÑÐ¾ÑÐµÑÑ ÑÐ²ÑÐ·Ð°Ð½ ÑÐ¾ ÑÑÐ°ÑÐ¸ÑÑÐ¸ÑÐµÑÐºÐ¾Ð¹ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¾Ð¹ Ð´Ð°Ð½Ð½ÑÑ, Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½ÑÑ Ð² Ð¿ÑÐ¾ÑÐµÑÑÐµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð° Ð»ÐµÐºÐ°ÑÑÑÐ²ÐµÐ½Ð½Ð¾Ð¹ Ð¿ÑÐ¾Ð´ÑÐºÑÐ¸Ð¸, Ð¿Ð¾ÑÑÐµÐ´ÑÑÐ²Ð¾Ð¼ Ð¿Ð¾ÑÑÑÐ¾ÐµÐ½Ð¸Ñ ÐºÐ°ÑÑ Ð¨ÑÑÐ°ÑÑÐ°, ÐºÐ¾Ð½ÑÑÐ¾Ð»ÑÐ½ÑÑ ÐºÐ°ÑÑ, ÑÐ°ÑÑÐµÑÐ° Ð¸Ð½Ð´ÐµÐºÑÐ¾Ð² Ð¿ÑÐ¸Ð³Ð¾Ð´Ð½Ð¾ÑÑÐ¸ Ð¸ Ð²Ð¾ÑÐ¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸Ð¼Ð¾ÑÑÐ¸ Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð².Ð ÑÐ°Ð¼ÐºÐ°Ñ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð¸ Ð¿ÑÐ¾Ð°Ð½Ð°Ð»Ð¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ñ Ð¿Ð¾ÑÑÐµÐ±Ð½Ð¾ÑÑÐ¸ ÐºÐ»ÑÑÐµÐ²ÑÑ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ ÐÐÐ Â«ÐÐ¢Ð¤Ð¤ ÐÐ¾Ð»Ð¸ÑÐ°Ð½Â», ÑÐ¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð° ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð°Ñ ÑÐ¿ÐµÑÐ¸ÑÐ¸ÐºÐ°ÑÐ¸Ñ Ð¸ ÑÐ¿ÐµÑÐ¸ÑÐ¸ÐºÐ°ÑÐ¸Ñ Ð´Ð¸Ð·Ð°Ð¹Ð½Ð°. ÐÑÐ½Ð¾Ð²Ð½Ð¾Ð¹ ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð» Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÑÑÑ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ðµ Ð¾Ð¿ÐµÑÐ°ÑÐ¸Ð¸:ÐÐ²Ð¾Ð´ Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾ Ð¿Ð°ÑÐ°Ð¼ÐµÑÑÐ°Ð¼ Ð² Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ;ÐÐ¾Ð»ÑÑÐµÐ½Ð¸Ðµ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð²Ð²ÐµÐ´ÐµÐ½Ð½ÑÑ Ð´Ð°Ð½Ð½ÑÑ Ð² Ð²Ð¸Ð´Ðµ Ð³ÑÐ°ÑÐ¸ÐºÐ¾Ð²;Ð Ð°ÑÑÐµÑ ÑÑÐ°ÑÐ¸ÑÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð¿Ð¾ÐºÐ°Ð·Ð°ÑÐµÐ»ÐµÐ¹ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð²Ð²ÐµÐ´ÐµÐ½Ð½ÑÑ Ð´Ð°Ð½Ð½ÑÑ.Ð ÑÐ¾Ð¾ÑÐ²ÐµÑÑÑÐ²Ð¸Ðµ Ñ ÑÑÐ¸Ð¼, Ð±ÑÐ» Ð²ÑÐ±ÑÐ°Ð½ Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÐ½ÑÐ¹ ÑÑÐ¸Ð»Ñ ÐºÐ»Ð¸ÐµÐ½Ñ-ÑÐµÑÐ²ÐµÑ, Ð³Ð´Ðµ Ð² ÐºÐ°ÑÐµÑÑÐ²Ðµ ÑÐµÑÐ²ÐµÑÐ° Ð²ÑÑÑÑÐ¿Ð°ÐµÑ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ MySQL. ÐÐ»Ð¸ÐµÐ½ÑÑÐºÐ°Ñ ÑÐ°ÑÑÑ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ð° Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÑÑÐµÐ¹Ð¼Ð²Ð¾ÑÐºÐ° JavaFX Ð¸ Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÐ½Ð¾Ð³Ð¾ ÑÑÐ¸Ð»Ñ MVC (Ð¼Ð¾Ð´ÐµÐ»Ñ-Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ-ÐºÐ¾Ð½ÑÑÐ¾Ð»Ð»ÐµÑ). ÐÐ»Ñ Ð¿Ð¾Ð´ÐºÐ»ÑÑÐµÐ½Ð¸Ñ ÐºÐ»Ð¸ÐµÐ½ÑÐ¾Ð² Ðº Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÐµÑÑÑ ÑÑÐµÐ¹Ð¼Ð²Ð¾ÑÐº JDBC. ÐÐ»Ñ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð´Ð°Ð½Ð½ÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÐµÑÑÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÐ¹ Ð¸Ð½ÑÐµÑÑÐµÐ¹Ñ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ APACHE POI.Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð¼ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ Ñ Ð¾ÐºÐ¾Ð½Ð½ÑÐ¼ Ð¸Ð½ÑÐµÑÑÐµÐ¹ÑÐ¾Ð¼, ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ðµ Ð´Ð»Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð½Ð° ÐÐ¡ ÑÐµÐ¼ÐµÐ¹ÑÑÐ²Ð° Windows NT Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹: Java, JavaFX, JDBC, MySQL.
description: The topic of the final qualifying work: "An application for analyzing trends of critical attributes of pharmaceutical production quality ".The purpose of this work is to develop software that automates the process of continuous verification of production processes in pharmaceutical production. This process is associated with the statistical processing of data obtained during the production of medicinal products, through the construction of Shuhart maps, control maps, calculation of indices of suitability and reproducibility of processes.As part of the work, the needs of key software users in the company "NTFF Polisan" were analyzed, a functional specification and a design specification were compiled. The main functionality of the application allows you to perform the following operations:â¢ Input of parameter data into the database;â¢ Obtaining visualization based on the entered data in the form of Schuhart maps, control maps;â¢ Calculation of statistical indicators based on the entered data.In accordance with this, the client-server architectural style was chosen, where the MySQL database acts as the server. The client part of the application is implemented using the JavaFX framework and the MVC architectural style (model-view-controller). The JDBC framework is used to connect clients to the database. The APACHE POI application programming interface is used for data visualization.The result of the work is an application with a windowed interface designed for use on the Windows NT OS family using technologies: Java, JavaFX, JDBC, MySQL.