Message Board

Respected readers, authors and reviewers, you can add comments to this page on any questions about the contribution, review,        editing and publication of this journal. We will give you an answer as soon as possible. Thank you for your support!

Name
E-mail
Phone
Title
Content
Verification Code
x Close Forever Close
Volume 33 Issue 3
. 
Turn off MathJax
Article Contents
Article Navigation >  Journal of Pharmaceutical Practice and Service  > 2015  >  33(3): 283-286

ZONG Zhiyong, JIA Yingjue, LIU Xiaopeng, ZHANG Ruili, SU Shuang, LIU Quan. Application of Oracle and Java for the development of medicine information search software in Wangjing Hospital[J]. Journal of Pharmaceutical Practice and Service, 2015, 33(3): 283-286. doi: 10.3969/j.issn.1006-0111.2015.03.025
Citation: ZONG Zhiyong, JIA Yingjue, LIU Xiaopeng, ZHANG Ruili, SU Shuang, LIU Quan. Application of Oracle and Java for the development of medicine information search software in Wangjing Hospital[J]. Journal of Pharmaceutical Practice and Service, 2015, 33(3): 283-286. doi: 10.3969/j.issn.1006-0111.2015.03.025
shu

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

doi: 10.3969/j.issn.1006-0111.2015.03.025

  • Wangjing Hospital, China Academy of Chinese Medical Sciences, Beijing 100102, China

  • Received Date: 2013-12-20
  • Rev Recd Date: 2014-05-17
  • 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.
  • [1] 刘 宏,汤 韧,张 宜.药学服务信息保障体系的构建[J].中国医院药学杂志,2010,30(10):867-869.
    [2] 郑锦坤,赖水招,高凌俊,等.基本用药说明书数据库的电子化与应用[J].今日药学,2009,19(7):63-65.
    [3] 陈 伟,穆秀珍,马金兰.使用Access2007管理药品说明书进行模糊查询[J].今日药学,2009,19(3):57-59.
    [4] 赵普军,郭瑞臣.合理用药咨询系统的开发与应用[J].药学服务与研究,2008,8(1):66-68.
    [5] 孙风栋. Oracle 10g数据库基础教程[M].2版.北京:电子工业出版社,2012.
    [6] 乔 彦.药学信息检索策略的探讨[J].中国执业药师,2011,8(5),21-24.
    [7] 徐明阳,王文华.浅谈数据库的模糊查询与优化查询[J].内肛科技,2010,6:145-149.
    [8] 刘兰茹,张丽军,孙志丹.药品信息与药品安全[J].中国医药指南,2008,6(3):151-152.
    [9] 赵 辉,张虹云.药品管理系统中处方审核、发药交代简明数据库的设计与应用[J].新疆医学,2010,40:128-129.
    [10] 王冶信,杨樟卫,胡晋红.药学服务和信息化背景下的新观点:构建医院药学信息系统[J].药学实践杂志,2007,25(3):170-173.
  • 加载中
通讯作者: 陈斌, bchen63@163.com
  • 1. 

    沈阳化工大学材料科学与工程学院 沈阳 110142

  1. 本站搜索
  2. 百度学术搜索
  3. 万方数据库搜索
  4. CNKI搜索
Get Citation
PDF
XML

Article Metrics

Article views(3146) PDF downloads(672) Cited by()

Related
Proportional views

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

doi: 10.3969/j.issn.1006-0111.2015.03.025
  • Wangjing Hospital, China Academy of Chinese Medical Sciences, Beijing 100102, China
  • Received Date: 2013-12-20
  • Rev Recd Date: 2014-05-17

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.

ZONG Zhiyong, JIA Yingjue, LIU Xiaopeng, ZHANG Ruili, SU Shuang, LIU Quan. Application of Oracle and Java for the development of medicine information search software in Wangjing Hospital[J]. Journal of Pharmaceutical Practice and Service, 2015, 33(3): 283-286. doi: 10.3969/j.issn.1006-0111.2015.03.025
Citation: ZONG Zhiyong, JIA Yingjue, LIU Xiaopeng, ZHANG Ruili, SU Shuang, LIU Quan. Application of Oracle and Java for the development of medicine information search software in Wangjing Hospital[J]. Journal of Pharmaceutical Practice and Service, 2015, 33(3): 283-286. doi: 10.3969/j.issn.1006-0111.2015.03.025
shu

    HTML

Reference (10)

Catalog

    版权所有：《药学实践与服务》编辑委员会

    Supervisor & Sponsors: Address: No 325 Guohe Road, ShanghaiPost Code: 200433

    Tel: （021）81871324,81871397 E-mail: yxsjzzs@163.com

    网站备案号 沪ICP备05003363号-1

    Supported by: Beijing Renhe Information Technology Co., Ltd.  

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return