基于Oracle数据库的医疗设备在线验收系统的开发与应用  

Development and Application of Online Acceptance System for Medical Equipment Based on Oracle Database

作　　者：曾闻如 刘盾 王金毅 邱春冬[1] ZENG Wenru;LIU Dun;WANG Jinyi;QIU Chundong(Department of Clinical Medical Engineering,Nanjing Drum Tower Hospital,The Affiliated Hospital of Nanjing University Medical School,Nanjing Jiangsu 210008,China)

机构地区：[1]南京大学医学院附属鼓楼医院临床医学工程处,江苏南京210008

出　　处：《中国医疗设备》2025年第4期84-89,150,共7页China Medical Devices

基　　金：南京大学中国医院改革发展研究院课题(NDYGN2023022)。

摘　　要：目的设计一款医疗设备在线验收系统,提高医疗设备验收材料质量和验收工作效率。方法采用Vue框架、ElementUI组件库、JavaScript、HTML、CSS等技术进行系统前端设计开发;基于Oracle数据库,使用Java语言、Spring MVC框架、MyBatis框架等进行系统后端数据库的设计与数据存储;选用HTTPS协议、安全隔离网闸硬件保障数据传输与交互安全,实现设备到货登记、验收资料的上传审核、定期维护保养执行情况的提醒跟踪等功能。结果系统上线后,资料审核时间由(31.05±6.28)d缩短为(6.62±4.57)d,验收完成时间由(44.30±7.35)d缩短为(13.42±6.34)d,约定时间到货率由67.78%提高至97.78%,验收资料完整率由60.00%提高至91.11%,且差异均有统计学意义(P<0.05)。结论基于Oracle数据库的医疗设备在线验收系统可规范医疗设备验收流程中供应商和工程师的工作职能,保证验收材料的完整性及可追溯性,提高验收工作效率。Objective To design an online acceptance system for medical equipment,to improve the quality of acceptance materials and the efficiency of acceptance work for medical equipment.Methods The front-end of system was developed on the basis of Vue framework,ElementUI component library,JavaScript,HTML,CSS and other technologies.The back-end of system was deployed on Oracle database by using Java language,Spring MVC framework and MyBatis framework.The HTTPS protocol and security isolation gateway hardware were used to ensure the security of data transmission and interaction.The functions of equipment arrival registration,uploading and review of acceptance materials,reminding and tracking the implementation of regular maintenance were realized.Results After the launch of the system,the data review time was reduced from(31.05±6.28)d to(6.62±4.57)d,the acceptance completion time was shortened from(44.30±7.35)d to(13.42±6.34)d,the agreed time arrival rate was increased from 67.78%to 97.78%,the acceptance data integrity rate was increased from 60.00%to 91.11%,and all the differences were statistically significant(P<0.05).Conclusion The online acceptance system for medical equipment based on Oracle database can standardize the work functions of suppliers and engineers in the acceptance process of medical equipment,ensure the integrity and traceability of acceptance materials,which can improve the efficiency of acceptance work.

关 键 词：医疗设备 验收管理 在线验收 供应商 档案管理 信息系统 数据库 

分 类 号：R197.32[医药卫生—卫生事业管理]