基于组态王的节水型便器检测系统数据库的配置与管理  

Configuration and Management of the Database for Toilet Capability Testing System Based on KingView 6.51

作　　者：肖胜然[1] 何孟珂[1] 周浩敏[1] 

机构地区：[1]北京航空航天大学仪器科学与光电工程学院,北京100083

出　　处：《工业控制计算机》2007年第6期47-49,共3页Industrial Control Computer

摘　　要：阐述了组态王KingView6.51环境下,以SQLServer为服务器的节水型便器检测系统数据库的配置与管理。其中包括系统数据库的建立,ODBC数据源的配置,采用组态王建立人机交互界面实现对数据库中记录的查询、添加、更新、删除等操作,改进了组态王KVDBGrid控件在显示方面的劣势,同时实现检测报告的生成与打印,数据库的安全设置等功能。TCTS is a toilet capability testing system based on KingView6.51,and using SQL Server as its database server.This paper describes the configuration and management of the database for TCTS in detail.The contents mainly include the structure of the dababase,configuration of ODBC for the database,buildup of the controlling interface based on KJngVJew6.51 to perform all operations on the database,including insert,update,quire,delete of records,creation of test report, and the measurements taken to keep the database in security,which has inhanced KVDBGrid ＇s ability in data display.

关 键 词：组态王 数据库 ODBC SQL SERVER 

分 类 号：TP274[自动化与计算机技术—检测技术与自动化装置]