基于Delphi警用装备管理系统的开发
摘要
随着全国公安自动化信息网络的建成,各级公安机关也相继建成了各自的局域网,传统的纸页式、抄送式、传阅式的办公模式正在逐渐被取代,资源共享逐步实现,机关办公效率大大增强。但是在警用装备库的管理方面,还没能实现能够利用网络系统实行自动化管理。各单位管理方法与模式纷繁复杂,没有一套规范的制式的管理系统,造成了资源浪费,办公效率低下,已不能适应未来信息化建设和执行任务的需要,使信息化时代的网络未能有效地发挥效能。
本文对整个系统功能模块及数据库进行需求分析,提出了一套基于Delphi的警用装备信息管理系统,集出库、入库、财会统计为一体的多功能、通用化信息管理系统的设计与实现方法,并详细阐述了开发过程中几个关键技术的设计实现方法,如Delphi中实现三层C/S数据库应用系统的方法、用DELPHI实现数据访问等,本系统在设计时注重系统的实用性,在关注数据安全性及数据表单规范化设计要求的同时,特别注重了数据录入界面的录入便利性设计,提供了一套高效的警用装备数据录入解决方案。
系统实现上采用三层客户/服务器模式,三层客户服务器结构将系统的表示逻辑、业务逻辑和数据逻辑分开,从而使系统具有良好的性能和安全性。系统后台数据库采用SQL Server2000,Delphi作为前台应用开发工具,中间层与数据库采用ODBC连接。本系统的实现为单位部门提供了一套高效、通用的门市销售、财会统计及物资基础信息管理为一体综合化的管理平台,提高了部门管理警用装备数据的效率,具有广泛的实际应用前景。
With the automation of the national police information network completed, the public security organs at all levels have also built their own local area network, the traditional paper page of type, copy type, circulation-style office model is gradually being replaced by the progressive realization of the sharing of resources, authority office efficiency has been greatly enhanced. However, in Police Equipment library management, yet be able to use the Internet to achieve the implementation of automated management systems. Units complicated the management methods and models, there is no standard set of standardized management system, resulting in waste of resources, office inefficiencies have been unable to meet the future information needs of the construction and implementation of the mandate, so that the information age of the network is not yet effective play performance.
In this paper, the entire system function modules and the database needs analysis, proposed a set of Police Equipment information management system based on Delphi, set out the library, storage, accounting and statistics as one multi-purpose, universal information management system design and implementation of method and detailed development process Design and implementation of several key technology methods, such as Delphi, to achieve the three-tier C / S database application system approach, using Delphi data and interviews, this system is designed to focus on the system's utility , in the interest of data security and data forms, while standardized design requirements with special emphasis on the data entry interface for entry to facilitate the design, providing a highly efficient Police Equipment data entry solutions.
System implementation on a three-tier client / server model, three-tier client-server architecture, said the system's logic, business logic and data logic of separation, so that the system has good performance and security. System back-end database using SQL Server2000, Delphi application development tool as a front, the middle layer and the database using ODBC connection. Realization of this system as a unit provides a highly efficient department, general store sales, accounting statistics and material basis for an integrated approach to information management, integrated management platform to improve the efficiency of the data sector management Police Equipment, has a broad prospect of practical application .
本文对整个系统功能模块及数据库进行需求分析,提出了一套基于Delphi的警用装备信息管理系统,集出库、入库、财会统计为一体的多功能、通用化信息管理系统的设计与实现方法,并详细阐述了开发过程中几个关键技术的设计实现方法,如Delphi中实现三层C/S数据库应用系统的方法、用DELPHI实现数据访问等,本系统在设计时注重系统的实用性,在关注数据安全性及数据表单规范化设计要求的同时,特别注重了数据录入界面的录入便利性设计,提供了一套高效的警用装备数据录入解决方案。
系统实现上采用三层客户/服务器模式,三层客户服务器结构将系统的表示逻辑、业务逻辑和数据逻辑分开,从而使系统具有良好的性能和安全性。系统后台数据库采用SQL Server2000,Delphi作为前台应用开发工具,中间层与数据库采用ODBC连接。本系统的实现为单位部门提供了一套高效、通用的门市销售、财会统计及物资基础信息管理为一体综合化的管理平台,提高了部门管理警用装备数据的效率,具有广泛的实际应用前景。
With the automation of the national police information network completed, the public security organs at all levels have also built their own local area network, the traditional paper page of type, copy type, circulation-style office model is gradually being replaced by the progressive realization of the sharing of resources, authority office efficiency has been greatly enhanced. However, in Police Equipment library management, yet be able to use the Internet to achieve the implementation of automated management systems. Units complicated the management methods and models, there is no standard set of standardized management system, resulting in waste of resources, office inefficiencies have been unable to meet the future information needs of the construction and implementation of the mandate, so that the information age of the network is not yet effective play performance.
In this paper, the entire system function modules and the database needs analysis, proposed a set of Police Equipment information management system based on Delphi, set out the library, storage, accounting and statistics as one multi-purpose, universal information management system design and implementation of method and detailed development process Design and implementation of several key technology methods, such as Delphi, to achieve the three-tier C / S database application system approach, using Delphi data and interviews, this system is designed to focus on the system's utility , in the interest of data security and data forms, while standardized design requirements with special emphasis on the data entry interface for entry to facilitate the design, providing a highly efficient Police Equipment data entry solutions.
System implementation on a three-tier client / server model, three-tier client-server architecture, said the system's logic, business logic and data logic of separation, so that the system has good performance and security. System back-end database using SQL Server2000, Delphi application development tool as a front, the middle layer and the database using ODBC connection. Realization of this system as a unit provides a highly efficient department, general store sales, accounting statistics and material basis for an integrated approach to information management, integrated management platform to improve the efficiency of the data sector management Police Equipment, has a broad prospect of practical application .
引文
[1]池雅庆,贾小敏.Delphi数据库应用项目开发实践.北京:中国铁道出版社,2005.11.
[2]雷颖杰,陈锦辉.精通Delphi6数据库程序设计.北京:中国铁道出版社,2002.
[3]静海.深入Delphi6网络编程.北京:中国铁道出版社,2001.10.
[4]Steve Teixeira,Xavier Pacheco.Delphi6 Developer's Guide.Sams press U.S.A,2006.1.
[5]方盈.SQL Server 2000彻底研究.北京:中国铁道出版社,2001.
[6]网冠科技.数据库系统工程师一SQL Server 2000.北京:机械工业出版社,2001.7.
[7]林福泉,江高举.SQL Server 2000中小企业实务应用.北京:中国铁道出版社,2001.11.
[8]James R.Groff,Paul N.Weinberg.SQL:The Complete Reference(Second Edition).The McGrow-Hill Companies Inc.2006.2.
[9]长城工作室数据组.SQL Server2000高级应用.北京:人民邮电出版社,2001.8.
[10]Rob Hawthorne.Microsoft SQL Server 2000 Datebase Development from Scratch.Que.Inc.,2001.8.
[11]刘晓华.SQL Server 2000数据库应用开发.北京:电子工业出版社,2003.1.
[12]夏邦贵,刘凡馨.SQL Server数据库开发经典实例精解.北京:机械工业出版社,2006.1.
[13]余金山,周敏龙.SQL Server 2000编程指南.北京:希望电子出版社,2001.6.
[14]段钢.加密与解密.第二版.北京:电子工业出版社,2003.
[15]戈德赖克(以色列).密码学基础(第二卷)-基础应用(英文版).北京:电子工业出版社,2005.
[16]吴志坚,顾洪.数据库原理与开发应用技术.北京:国防工业出版社,2004.
[17]栗松涛,李春文,孙政顺.一种新的B/S系统权限控制方法计算机工程与应用,2002,(01).
[18]刘中兵,李伯华,邹晨.JSP数据库项目案例导航.北京:清华大学出版社,2006.
[19]金爱.仓库库存计算机信息管理系统.上海电机学院学报,2002,(8):12-35.
[20]Roman E,Scott A,Tyler J.Computer Publishing.New York:Mastering Enterprise JavaBeans,2002,(4):13-88.
[21]孙文新.仓库安全管理综合信息系统煤矿现代化,2005,(10):101-105.
[22]周晓光.自动化立体仓库管理信息系统模型电子测量技术2003,(6):67-69.
[23]Ferraiolo D,Barkley F,Kuhn D R.A Role Based Access Control Modeland Reference Implementation within a Corporate Intranet.ACMTransactions on Information Systems Security,1999,1(2):13-38.
[24]韩伯棠.管理运筹学.北京:高等教育出版社,2000.
[25]刘忠.自动化仓库动态信息管理系统研究与实施.物流技术与应用,2006.6.
[26]刘志成.SQL Server 2005实例教程[M].北京:电子工业出版社2008.
[27]叶核亚.Delphi程序设计,人民邮电出版社,2008.
[28]郑阿奇.SQL Server实用教程.北京:电子工业出版社,2007:7-8.
[2]雷颖杰,陈锦辉.精通Delphi6数据库程序设计.北京:中国铁道出版社,2002.
[3]静海.深入Delphi6网络编程.北京:中国铁道出版社,2001.10.
[4]Steve Teixeira,Xavier Pacheco.Delphi6 Developer's Guide.Sams press U.S.A,2006.1.
[5]方盈.SQL Server 2000彻底研究.北京:中国铁道出版社,2001.
[6]网冠科技.数据库系统工程师一SQL Server 2000.北京:机械工业出版社,2001.7.
[7]林福泉,江高举.SQL Server 2000中小企业实务应用.北京:中国铁道出版社,2001.11.
[8]James R.Groff,Paul N.Weinberg.SQL:The Complete Reference(Second Edition).The McGrow-Hill Companies Inc.2006.2.
[9]长城工作室数据组.SQL Server2000高级应用.北京:人民邮电出版社,2001.8.
[10]Rob Hawthorne.Microsoft SQL Server 2000 Datebase Development from Scratch.Que.Inc.,2001.8.
[11]刘晓华.SQL Server 2000数据库应用开发.北京:电子工业出版社,2003.1.
[12]夏邦贵,刘凡馨.SQL Server数据库开发经典实例精解.北京:机械工业出版社,2006.1.
[13]余金山,周敏龙.SQL Server 2000编程指南.北京:希望电子出版社,2001.6.
[14]段钢.加密与解密.第二版.北京:电子工业出版社,2003.
[15]戈德赖克(以色列).密码学基础(第二卷)-基础应用(英文版).北京:电子工业出版社,2005.
[16]吴志坚,顾洪.数据库原理与开发应用技术.北京:国防工业出版社,2004.
[17]栗松涛,李春文,孙政顺.一种新的B/S系统权限控制方法计算机工程与应用,2002,(01).
[18]刘中兵,李伯华,邹晨.JSP数据库项目案例导航.北京:清华大学出版社,2006.
[19]金爱.仓库库存计算机信息管理系统.上海电机学院学报,2002,(8):12-35.
[20]Roman E,Scott A,Tyler J.Computer Publishing.New York:Mastering Enterprise JavaBeans,2002,(4):13-88.
[21]孙文新.仓库安全管理综合信息系统煤矿现代化,2005,(10):101-105.
[22]周晓光.自动化立体仓库管理信息系统模型电子测量技术2003,(6):67-69.
[23]Ferraiolo D,Barkley F,Kuhn D R.A Role Based Access Control Modeland Reference Implementation within a Corporate Intranet.ACMTransactions on Information Systems Security,1999,1(2):13-38.
[24]韩伯棠.管理运筹学.北京:高等教育出版社,2000.
[25]刘忠.自动化仓库动态信息管理系统研究与实施.物流技术与应用,2006.6.
[26]刘志成.SQL Server 2005实例教程[M].北京:电子工业出版社2008.
[27]叶核亚.Delphi程序设计,人民邮电出版社,2008.
[28]郑阿奇.SQL Server实用教程.北京:电子工业出版社,2007:7-8.