| 保险代理管理系统中机构树的设计与实现 |
| |
| 引用本文： | 栗觅,魏海平,宋晓君,石元博.保险代理管理系统中机构树的设计与实现[J].辽宁石油化工大学学报,2007,27(2):72-75,79. |
| |
| 作者姓名： | 栗觅 魏海平 宋晓君 石元博 |
| |
| 作者单位： | 辽宁石油化工大学计算机与通信工程学院,辽宁抚顺,113001;辽宁石油化工大学计算机与通信工程学院,辽宁抚顺,113001;辽宁石油化工大学计算机与通信工程学院,辽宁抚顺,113001;辽宁石油化工大学计算机与通信工程学院,辽宁抚顺,113001 |
| |
| 摘 要： | 分析了人员管理机构树的特点、功能及其结构设计思想,介绍了在MS SQL SERVER2000中实现动态机构树的方法。针对机构树动态生成中应用程序对数据库进行频繁操作而降低系统执行效率的问题,详细给出了在VC++6.0中应用后台数据库存储过程和触发器技术的解决方案。系统实际运行结果表明,该系统具有稳定、计帐准确和查询速度快等特点。
|
| 关 键 词： | 机构树 存储过程 触发器 |
| 文章编号： | 1672-6952（2007）02-0072-04 |
| 收稿时间： | 2006-10-23 |
| 修稿时间： | 2007-03-30 |
Design and Implementation of the Organization-Tree in the Insurance Agency MIS |
| |
| LI Mi,WEI Hai-ping,SONG Xiao-jun,SHI Yuan-bo.Design and Implementation of the Organization-Tree in the Insurance Agency MIS[J].Journal of Liaoning University of Petroleum & Chemical Technology,2007,27(2):72-75,79. |
| |
| Authors: | LI Mi WEI Hai-ping SONG Xiao-jun SHI Yuan-bo |
| |
| Abstract: | The characteristics,the function,and the structural design of the organization-tree were analyzed.The method of implementing the dynamic organization-tree in MS SQL SERVER2000 was introduced.Aiming at the problem that,in the process of dynamically generating organization-tree,the application program manipulates the database frequently and leads to the low efficiency of the system running,a detailed solution scheme for applying the storage process of background database and trigger technique with VC++6.0 was given. The practical running results show that the system is of stability,keeps business records accurately,and polls information quickly. |
| |
| Keywords: | Organization- tree Storage process Trigger |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
