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 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 .