基于VC_(++)的眼科数据库多种查询功能的实现

Achievement of a variety of ophthalmic electronic medical records based on VC_(++)

目的对眼科电子病历系统中多种查询功能的实现方法进行探讨。方法在Windows 7环境下,以SQL SERVER2008为测试数据库,通过ActiveX数据对象(Active Data Object,简称ADO),基于VC进行SQL语句的拼接来实现多种查询。结果系统可实现单表单条件、单表多条件和多表多条件的查询。结论 SQL语句的拼接实现多种查询,极大地提高了眼科电子病历系统数据库的操作效率和便捷性。

Objective ： To introduce the implementation of multiple query method in an electronic medical records sys- tem for ophthalmology. Methods ： Based on VC^- in Windows 7, multiple queries were achieved by SQL statement stitching method by means of Active Data Object, with SQL SERVER2008 as the tested database. Results： In the system, query was achieved by single condition in single table, multi-conditions in single table and multi-conditions in multi tables. Conclu- sions： Queries achieved by SQL statement stitching method can gready improve the efllcieney of the operation of the elec- tronic medical records system for ophthalmology.