利用Oracle、Java开发我院药品信息查询软件
投稿时间:2013-12-20  修订日期:2014-05-17  点此下载全文
引用本文:宗志勇,贾鹰珏,刘小鹏,张瑞丽,苏爽,刘权.利用Oracle、Java开发我院药品信息查询软件[J].药学实践杂志,2015,33(3):283~286
摘要点击次数: 1411
全文下载次数: 653
作者单位
宗志勇 中国中医科学院望京医院, 北京 100102 
贾鹰珏 中国中医科学院望京医院, 北京 100102 
刘小鹏 中国中医科学院望京医院, 北京 100102 
张瑞丽 中国中医科学院望京医院, 北京 100102 
苏爽 中国中医科学院望京医院, 北京 100102 
刘权 中国中医科学院望京医院, 北京 100102 
基金项目:中国中医科学院望京医院院级课题(WJ2011-43)
中文摘要:目的 开发药品信息查询软件,解决纸质说明书药品信息更新速度慢、查阅不方便等实际问题,为临床提供快捷的药学信息服务。 方法 根据临床和医院药学实际需求,通过药品说明书收集、整理、扫描、图像处理、信息提取等步骤,利用Oracle 10G构建医院药品信息库,使用Java开发药品信息查询软件。 结果 本软件共收录药品1 201种,占我院药品目录品种数的98.85%。使用者可通过4种查询方式(通用名查询、商品名查询、模糊查询和关键词查询)获取药品说明书文字版信息和影印版信息。 结论 利用Oracle 、Java开发的药品信息查询软件可为临床提供实用快捷的药学信息服务。
中文关键词:药品信息查询  模糊查询  关键词查询  Oracle  影印版信息
 
Application of Oracle and Java for the development of medicine information search software in Wangjing Hospital
Abstract: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.
keywords:medicine information search  fuzzy search  key word search  Oracle  photographic information
查看全文  查看/发表评论  下载PDF阅读器
关闭

分享按钮