The Design And Implementation Of Based On The J2EE Pharmaceutical Product Quality Tracking Management System

In recent years, China’s pharmaceutical quality and safety problems occurred frequently, in order to reap huge profits, some pharmaceutical industries produce substandard products, even toxic drugs, such as leather capsules (use industrial scrap leather to make medicinal capsules), at the same time, the flow of the drug has been lack of supervision. In the era of rapid development of today’s networks, it is necessary to develop a management system for the pharmaceutical quality and safety issues, using minimum manpower and resources to strictly regulate pharmaceutical products, anti-counterfeiting anti-fluid-channeling, full tracking and tracing each pharmaceutical product from production to sell.By analyzing the background of pharmaceutical product quality tracking management systems, indicating the shortcomings of domestic similar systems existing in the pharmaceutical product quality tracking management process. As foe technologies, the overall design of the system was based on the B/S framework, using JAVA development language for system implementation, adopting the idea of the Model-View-Controller (MVC) design pattern, technical architecture used J2EE framework. Using the relational database SQL Server 2008.The user role of J2EE-based pharmaceutical product quality tracking management system is the system administrator, the system designed and implemented six modules:basic information management module, pre-production management module, production process management module, post-production management module, product sampling inspection management module and drug supervision code management module. Basic information management achieved eight sub-functions, including channel chain management, print business management, product management, print template management, packaging rule management, functional code printing, custom code rule and warehouse information management.. Pre-production management achieved three sub-functions, including IPC management, production line management and production planning management. Production process management achieved the management of test orders. Post-production management achieved two sub-functions, including packaging relation management and packaging relation export. Product sampling inspection management achieved the management of product sampling inspection. Drug supervision code management achieved the management of supervision codes.J2EE-based pharmaceutical product quality tracking management system provided a convenient and effective management tool for the supervision of pharmaceutical product, which can achieve the network management of pharmaceutical regulatory and improve the efficiency of relevant departments, thus perfecting the information management mode of pharmaceutical products.