Application of Oracle and Java for the development of medicine information search software in Wangjing Hospital
10.3969/j.issn.1006-0111.2015.03.025
- VernacularTitle:利用Oracle、Java开发我院药品信息查询软件
- Author:
Zhiyong ZONG
1
;
Yingjue JIA
;
Xiaopeng LIU
;
Ruili ZHANG
;
Shuang SU
;
Quan LIU
Author Information
1. 中国中医科学院望京医院,北京100102
- Keywords:
medicine information search;
fuzzy search;
key word search;
Oracle;
photographic information
- From:
Journal of Pharmaceutical Practice
2015;(3):283-286
- CountryChina
- Language:Chinese
-
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 clini-cal 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 .
