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

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

阐述了组态王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.