数据库课程设计14473.docVIP

数据库课程设计总结报告 目录 1 系统理论及技术基础·····································3 研究的目的及意义·································3 实现技术选择 ···································3 Java Swing简介 ······························3 MySQL 简介 ································3 2 系统需求及可行性分析 ···································4 2.1 需求分析··········································4 2.2 可行性分析········································4 3 系统总体设计············································5 3.1 设计思想···········································5 3.2 系统功能设计·······································5 3.2.1 系统功能分析································5 3.2.2 系统功能模块分析·····························6 3.3 数据库设计·········································8 3.3.1 数据库逻辑设计·······························8 3.3.2 数据库结果设计·······························9 4 系统功能实现············································11 4.1 登录模块设计·······································11 4.2 主演功能实现 ·······································13 4.2.1 更新数据界面 ································14 4.2.2 添加数据界面 ································15 4.2.3 查询信息界面 ································17 4.2.4 密码验证界面 ································19 5 总结 ···················································20 6 代码附录················································21 1 系统理论与技术基础 1.1 研究的目的及意义 作为高校的学生信息管理部门，承担着管理数量庞大的学生信息的工作。常规的人工管理方式存在诸多的弊端，如：管理人员工作量巨大，效率低下，安全性低下，出错率较高等，已难以满足高校发展的需求，极大的影响了学生信息管理的效率和安全。如何利用日趋先进的计算机与信息技术来提高高校的学生信息管理工作水平成为了我们所面临的巨大问题。 通过对高校学生信息管理的需要分析，根据目前信息管理的特点，结合信息管理系统目前的发展前景、技术水平，开发出一个更适合于高校的学生信息管理系统，从而提高高校学生信息管理工作的质量。 1.2 实验技术选择 1.2.1 Java Swing 简介 Swing是一个用于开发Java应用程序用户界面的开发工具包。它以抽象窗口工具包（AWT）为基础使跨平台应用程序可以使用任何可插拔的外观风格。Swing开发人员只用很少的代码就可以利用Swing丰富、灵活的功能和模块化组件来创建优雅的用户界面。兼容性可移植性可联结性高生产率开放性 2.1 需求分析 学生信息管理系统需要满足来自两个方面的需求，分别是学生用户和教师用户。 学生用户主要从事对学生信息的收集、整理、录入等相关的信息管理工作。教师用户可对学生信息（档案，选课，教师，成绩）进行查询，增加，修改，删除等操作，同时可对自己的用户角色相关信息进行操作（密码修改），该角色为该系统的主要使用者。 根据以上的综合考虑，该系统