利用Oracle、Java开发我院药品信息查询软件

目的 开发药品信息查询软件,解决纸质说明书药品信息更新速度慢、查阅不方便等实际问题,为临床提供快捷的药学信息服务。 方法 根据临床和医院药学实际需求,通过药品说明书收集、整理、扫描、图像处理、信息提取等步骤,利用Oracle 10G构建医院药品信息库,使用Java开发药品信息查询软件。 结果 本软件共收录药品1 201种,占我院药品目录品种数的98.85%。使用者可通过4种查询方式(通用名查询、商品名查询、模糊查询和关键词查询)获取药品说明书文字版信息和影印版信息。 结论 利用Oracle 、Java开发的药品信息查询软件可为临床提供实用快捷的药学信息服务。

Application of Oracle and Java for the development of medicine information search software in Wangjing Hospital

Objective Since it is a common problem for medical practice that paper instructions for medicine information are difficult to update and inconvenient to search, this article is to provide convenient service of pharmacy information for clinical practice by developing medicine information search software in our hospital. Methods According to the practical needs of clinical study and pharmacy research, we took appropriate measures to collect data, categorize contents, scan pictures, polish images and extract information for the medicine instructions. Based on the above work, we applied Oracle 10G to establish medicine information database for our hospital and utilized Java to design medicine information search software. Results Our search software includes 1 201 kinds of medicines, taking up 98.85% of the medicines in our catalogue. The users can use four different search Methods (including common name search, commodity name search, fuzzy search and key word search) to gain the written material and photographic information of medicine instructions. Conclusion With the help of the software of Oracle and Java, the newly designed software for medicine information search can provide convenient pharmacy information service for clinical practice.