数据库课程设计--体育项目管理系统VIP

1、目录2222系统需求分析与设计32.1 E-R图32.2数据流程图总图:42.3用户界面举例：52.3.1主界面：52.3.2运发动：52.3.3裁判员：62.3.4赛程管理：62.3.5效劳人员：73数据结构描述73.1运动器材器材名，器材来源等：73.2赛程管理比赛工程，比赛人数，比赛时间等：83.3裁判员姓名，年龄等级等：83.4运发动学号，姓名，比赛工程及得分等93.5救护人员:93.6效劳人员表：104软件设计流程图和功能模块图114.1赛程管理图:114.2.运发动个人管理:125程序模块汇总12121313141415156主要代码167本软件所能实现的功能综述及分析168课程设

2、计体会和总结16课程设计的目的数据库系统原理是计算机及其相关学科的一门重要的软件根底课程，也是计算机软件科学与技术、信息科学与技术的重要学科分支。本课程设计旨在通过对一个小型数据库管理系统DBMS的综合设计过程，强化学生对计算机系统软件的设计能力，提高学生的综合素质，并通过课程设计进一步加强学生对所学知识的理解，以及对数据库的全面、深刻认识。 1. 了解DBMS的设计过程；2. 掌握关系型DBMS的结构及实现；3. 掌握系统程序设计的根底知识；4. 深化理解并掌握?数据库系统原理?课程的相关内容；强化软件开发的团队意识，提高合作能力。2系统需求分析与设计2.1 E-R图数据流程图总图:2.3用

3、户界面举例：2.3.1主界面：2.3.2运发动：2.3.3裁判员：2.3.4赛程管理：2.3.5效劳人员：3数据结构描述3.1运动器材器材名，器材来源等：3.2赛程管理比赛工程，比赛人数，比赛时间等： 3.3裁判员姓名，年龄等级等： 3.4运发动学号，姓名，比赛工程及得分等 3.5救护人员: 3.6效劳人员表： 4软件设计流程图和功能模块图4.1赛程管理图:4.2.运发动个人管理:5程序模块汇总sporter:sporter(CWnd* pParent /*=NULL*/): CDialog(sporter:IDD, pParent) m_code = _T("");m_n

4、ame = _T("");m_sex = _T("");m_project = _T("");m_score = _T("");m_safe = _T("");void sporter:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_code);DDX_Text(pDX, IDC_EDIT2, m_name);DDX_Text(pDX, IDC_EDIT3, m_s

5、ex);DDX_Text(pDX, IDC_EDIT4, m_project);DDX_Text(pDX, IDC_EDIT5, m_score);DDX_Text(pDX, IDC_EDIT6, m_safe);judgement:judgement(CWnd* pParent /*=NULL*/): CDialog(judgement:IDD, pParent) m_manage = _T("");m_age = _T("");m_sex = _T("");m_from = _T("");m_left = _T

6、("");void judgement:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_manage);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_from);DDX_Text(pDX, IDC_EDIT5, m_left);control:control(CWnd* pParent /*=NULL*/):

7、CDialog(control:IDD, pParent) m_project = _T("");m_equipment = _T("");m_number = _T("");m_time = _T("");m_winer = _T("");void control:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_project);DDX_Text(pDX, IDC

8、_EDIT2, m_equipment);DDX_Text(pDX, IDC_EDIT3, m_number);DDX_Text(pDX, IDC_EDIT4, m_time);DDX_Text(pDX, IDC_EDIT5, m_winer);server:server(CWnd* pParent /*=NULL*/): CDialog(server:IDD, pParent)m_name = _T("");m_age = _T("");m_sex = _T("");m_class = _T("");void s

9、erver:DoDataExchange(CDataExchange* pDX)CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_name);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_class);doctor:doctor(CWnd* pParent /*=NULL*/): CDialog(doctor:IDD, pParent)m_name = _T("");m_age =

10、 _T("");m_sex = _T("");m_unit = _T("");void doctor:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_name);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_unit);doctor:doctor(CWnd* pParen

11、t /*=NULL*/): CDialog(doctor:IDD, pParent)m_name = _T("");m_age = _T("");m_sex = _T("");m_unit = _T("");void doctor:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_name);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(pDX, ID

12、C_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_unit);sportequipment:sportequipment(CWnd* pParent /*=NULL*/): CDialog(sportequipment:IDD, pParent)m_equipment = _T("");m_unit = _T("");m_firsttime = _T("");m_lasttime = _T("");m_value = _T("");void sportequi

13、pment:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_equipment);DDX_Text(pDX, IDC_EDIT2, m_unit);DDX_Text(pDX, IDC_EDIT3, m_firsttime);DDX_Text(pDX, IDC_EDIT4, m_lasttime);DDX_Text(pDX, IDC_EDIT5, m_value);6主要代码/运发动*sporter:sporter(CWnd* pParent /*=NULL*/):

14、 CDialog(sporter:IDD, pParent) m_code = _T("");m_name = _T("");m_sex = _T("");m_project = _T("");m_score = _T("");m_safe = _T("");void sporter:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_code);D

15、DX_Text(pDX, IDC_EDIT2, m_name);DDX_Text(pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_project);DDX_Text(pDX, IDC_EDIT5, m_score);DDX_Text(pDX, IDC_EDIT6, m_safe);裁判员*judgement:judgement(CWnd* pParent /*=NULL*/): CDialog(judgement:IDD, pParent) m_manage = _T("");m_age = _T(""

16、);m_sex = _T("");m_from = _T("");m_left = _T("");void judgement:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_manage);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_from);DDX_Text(pD

17、X, IDC_EDIT5, m_left);/赛程控制*control:control(CWnd* pParent /*=NULL*/): CDialog(control:IDD, pParent) m_project = _T("");m_equipment = _T("");m_number = _T("");m_time = _T("");m_winer = _T("");void control:DoDataExchange(CDataExchange* pDX) CDialog:DoD

18、ataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_project);DDX_Text(pDX, IDC_EDIT2, m_equipment);DDX_Text(pDX, IDC_EDIT3, m_number);DDX_Text(pDX, IDC_EDIT4, m_time);DDX_Text(pDX, IDC_EDIT5, m_winer);/效劳人员*server:server(CWnd* pParent /*=NULL*/): CDialog(server:IDD, pParent)m_name = _T("");m_age =

19、 _T("");m_sex = _T("");m_class = _T("");void server:DoDataExchange(CDataExchange* pDX)CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_name);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_class);/医疗人员*doctor:doctor(CWnd*

20、 pParent /*=NULL*/): CDialog(doctor:IDD, pParent)m_name = _T("");m_age = _T("");m_sex = _T("");m_unit = _T("");void doctor:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_name);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(

21、pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_unit);doctor:doctor(CWnd* pParent /*=NULL*/): CDialog(doctor:IDD, pParent)m_name = _T("");m_age = _T("");m_sex = _T("");m_unit = _T("");void doctor:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX)

22、;DDX_Text(pDX, IDC_EDIT1, m_name);DDX_Text(pDX, IDC_EDIT2, m_age);DDX_Text(pDX, IDC_EDIT3, m_sex);DDX_Text(pDX, IDC_EDIT4, m_unit);/体育器材模块*sportequipment:sportequipment(CWnd* pParent /*=NULL*/): CDialog(sportequipment:IDD, pParent)m_equipment = _T("");m_unit = _T("");m_firsttime

23、= _T("");m_lasttime = _T("");m_value = _T("");void sportequipment:DoDataExchange(CDataExchange* pDX) CDialog:DoDataExchange(pDX);DDX_Text(pDX, IDC_EDIT1, m_equipment);DDX_Text(pDX, IDC_EDIT2, m_unit);DDX_Text(pDX, IDC_EDIT3, m_firsttime);DDX_Text(pDX, IDC_EDIT4, m_lasttime);DDX_Text(pDX, IDC_EDIT