外来人员信息管理系统
合集下载
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
外来人员信息管理系统
摘要
该文旨在介绍外来人员信息管理系统的设计理念，该系统是针对地方管理机构开发是， 旨在提高相关部门的工作效率，降低管理成本。该系统适用于地方行政管理机构，同时也可 以用于关口登记处，还可以服务于地方的治安工作。通过使用该系统对外来人员信息的存储， 查询，相关部门就能更好的掌握信息，从而更好的规划、管理城市。Teachers HuangSh NhomakorabeaZhuan
Abstract
This paper aims to introduce the external personnel information management system design concept, the system is aimed at a local management organization development is, aiming at improving the related department to work efficiency, reduce the management cost. This system is suitable for the local administrative management institution, also can be used to pass registry, still can serve the local police work. Through the use of the system of nonnative personnel information store, retrieve, relevant departments can better to grasp the information, thereby better planning, managing city. This system is using Visual Basic 6.0 and SQL Server 2000 database joint exploration, to provide users with convenient data manipulation function, the convenient user processes the information. Keywords: nonnative personnel information management system, SQL Server 2000, Visual Basic 6.0.
该系统是利用 Visual Basic 6.0 和 SQL Server 2000 数据库共同开发的，为用户提供便捷 数据操纵功能，方便用户对信息进行处理。 关键词：外来人员信息管理系统、SQL Server 2000、Visual Basic 6.0。
The external personnel information management system Computer science and technology professional level. QinShiRong 2008
目录
1 引言.................................................................................................................................................. 2
1.1 现行业务简介...............................................................................................................................2 外来人员信息管理业务大致经过如个的管理流程：............................................................ 2 1.2 目标....................................................................................................................................... 2
3.1 系统功能分析......................................................................................................................4 3.2 系统功能模块设计..............................................................................................................4 4 数据库的设计..................................................................................................................................6 4.1 数据库概念结构..................................................................................................................6 4.2 数据库的创建......................................................................................................................7 4.3 触发器的设计.......................................................................................................................9 4.3.1 delete 触发器..............................................................................................................10 4.3.3 insert 触发器............................................................................................................10 4.4 视图和存储过程的设计....................................................................................................11 4.4.1 建立存储过程，用于查询注册信息表中类别为学生的信息.................................... 11 4.4.2 建立存储过程................................................................................................................. 11 查询注册信息表中证件号,姓名,性别,并且按年龄排序。................................................. 11 5 系统窗体的设计............................................................................................................................12 5.1 公共模块............................................................................................................................12 5.2 登录模块详细设计............................................................................................................13 5.3 主窗体”模块详细设计.....................................................................................................15 5.4 各项子模块详细设计.........................................................................................................15 5.4.1 系统管理模块...................................................................................................................15 5.4.2 外来人员登记信息管理模块.........................................................................................19 5.4.3 查询信息......................................................................................................................... 24 5.4.5 注销信息........................................................................................................................ 32 5.5 其他三个模块的设计........................................................................................................33 6 系统维护和改进............................................................................................................................34 6.1 运行维护.............................................................................................................................34 6.2 系统的改进与提高.............................................................................................................34 致谢................................................................................................................................................... 34 参考文献........................................................................................................................................... 35
2 数据库需求分析.............................................................................................................................3 3 系统设计.......................................................................................................................................... 4
摘要
该文旨在介绍外来人员信息管理系统的设计理念，该系统是针对地方管理机构开发是， 旨在提高相关部门的工作效率，降低管理成本。该系统适用于地方行政管理机构，同时也可 以用于关口登记处，还可以服务于地方的治安工作。通过使用该系统对外来人员信息的存储， 查询，相关部门就能更好的掌握信息，从而更好的规划、管理城市。Teachers HuangSh NhomakorabeaZhuan
Abstract
This paper aims to introduce the external personnel information management system design concept, the system is aimed at a local management organization development is, aiming at improving the related department to work efficiency, reduce the management cost. This system is suitable for the local administrative management institution, also can be used to pass registry, still can serve the local police work. Through the use of the system of nonnative personnel information store, retrieve, relevant departments can better to grasp the information, thereby better planning, managing city. This system is using Visual Basic 6.0 and SQL Server 2000 database joint exploration, to provide users with convenient data manipulation function, the convenient user processes the information. Keywords: nonnative personnel information management system, SQL Server 2000, Visual Basic 6.0.
该系统是利用 Visual Basic 6.0 和 SQL Server 2000 数据库共同开发的，为用户提供便捷 数据操纵功能，方便用户对信息进行处理。 关键词：外来人员信息管理系统、SQL Server 2000、Visual Basic 6.0。
The external personnel information management system Computer science and technology professional level. QinShiRong 2008
目录
1 引言.................................................................................................................................................. 2
1.1 现行业务简介...............................................................................................................................2 外来人员信息管理业务大致经过如个的管理流程：............................................................ 2 1.2 目标....................................................................................................................................... 2
3.1 系统功能分析......................................................................................................................4 3.2 系统功能模块设计..............................................................................................................4 4 数据库的设计..................................................................................................................................6 4.1 数据库概念结构..................................................................................................................6 4.2 数据库的创建......................................................................................................................7 4.3 触发器的设计.......................................................................................................................9 4.3.1 delete 触发器..............................................................................................................10 4.3.3 insert 触发器............................................................................................................10 4.4 视图和存储过程的设计....................................................................................................11 4.4.1 建立存储过程，用于查询注册信息表中类别为学生的信息.................................... 11 4.4.2 建立存储过程................................................................................................................. 11 查询注册信息表中证件号,姓名,性别,并且按年龄排序。................................................. 11 5 系统窗体的设计............................................................................................................................12 5.1 公共模块............................................................................................................................12 5.2 登录模块详细设计............................................................................................................13 5.3 主窗体”模块详细设计.....................................................................................................15 5.4 各项子模块详细设计.........................................................................................................15 5.4.1 系统管理模块...................................................................................................................15 5.4.2 外来人员登记信息管理模块.........................................................................................19 5.4.3 查询信息......................................................................................................................... 24 5.4.5 注销信息........................................................................................................................ 32 5.5 其他三个模块的设计........................................................................................................33 6 系统维护和改进............................................................................................................................34 6.1 运行维护.............................................................................................................................34 6.2 系统的改进与提高.............................................................................................................34 致谢................................................................................................................................................... 34 参考文献........................................................................................................................................... 35
2 数据库需求分析.............................................................................................................................3 3 系统设计.......................................................................................................................................... 4