数据库课程设计报告-学生宿舍的管理系统

1、-. z数据库原理课程设计说明书学生宿舍管理系统学 院： 计算机与信息科学学院专 业： 网络工程 班 级： 网络1402*：吴琳琳1420210231 *：周岐浪1420210217指导教师： 高 职称 讲师完成时间：2021年12月1、管理系统设计的背景、意义及目标设计背景设计意义设计目标2、系统开发环境3、系统需求分析根本功能需求功能模块数据字典4、概念构造设计概念设计E_R模型设计5、逻辑构造设计将E_R图转换为关系模型各表关系模型图6、数据实施和维护功能实现代码系统实现效果7、个人实现的功能8、总结1、管理系统设计的背景、意义及目标设计背景随着IT事业的开展，如今，我们已经全面跨入信息

2、时代。计算机被广泛的应用于各个行业，人工战略已经转化为信息战略，如何在短时间获取大量信息并整合信息，成为立足于时代的关键。为了适应考生人数的急剧增长，当今社会各大高校都在进展扩招政策，学生数量的急剧增加带来信息量的成倍增长，由于信息管理的不善与疏忽，各大高校大小事故时有发生。进展正确的信息管理，对于信息及时处理和反响，能够最大程度的减少学校以及在校学生的损失，减小潜在危机。学生宿舍是学生生活的根本单位，是同学休息与学习的地方，为了保障同学入住学生宿舍的平安性，信息的处理和管理极为重要。据了解，本校的宿舍信息管理仍然使用传统的手工方式，主要方式是基于文本、表格等纸介质的手工处理，用人工手抄对男女

3、生信宿信息进展处理登记。数据信息处理工作量大，容易出错且不易修改；由于数据繁多，容易丧失，逐条查找记录的方式不易操作，浪费了大量的时间，效率极低。学校的宿舍管理缺乏系统，规的信息管理手段。建立学生宿舍管理系统，使宿舍管理工作系统化，规化，便捷化，程序化，防止宿舍管理的随意性，提高信息处理的速度和准确性，能够及时、准确、有效的查询和修改宿舍情况。设计的意义高校规模的扩大,在校学生的根本情况随之层次化、多样化、复杂化，相应的，学生管理工作面临严峻的挑战。高校学生信息日渐庞大，相应的宿舍管理工作变得复杂而困难。传统的账本化工作模式，手工记录学生信息并存档，这样的人工管理方式费时、费事、费力，信息获取

4、慢,更新滞后，查阅困难,容易出错。为了给学生提供一个平安舒适的工作、生活、学习环境，方便宿舍管理工作的同时为学生、教师提供准确实时的信息至关重要。本校的宿舍信息管理，主要方式是基于文本、表格等纸介质的手工处理，用人工手抄对男女生信宿信息进展处理登记。数据信息处理工作量大，容易出错且不易修改；由于数据繁多，容易丧失，逐条查找记录的方式不易操作，浪费了大量的时间，效率极低。以上的管理缺陷对学生宿舍管理造成了相当大的阻力，工作进展困难，问题解决的周期过长，资料整改工作量过大。为了改善学生宿舍管理情况，运用数据库技术对学生信息进展处理和统一管理，在校园实现宿舍无纸化办公。利用计算机的特点，利用互联网进

5、展远程操作，制定学生客户端，教师客户端，管理员客户端，实现有针对性信息化管理，充分发挥计算机的高效性、可靠性、性、大容量、低本钱等特点，建立学生宿舍管理系统，对宿舍相关信息进展统一管理。新型管理方式学生宿舍管理系统，将帮助宿舍管理人员提高工作效率，全面地掌握宿舍情况，提高宿舍平安系数，快速解决学生入住学生宿舍遇到的问题，帮助管理人员与教师及时掌握学生情况。设计目标开发设计学生宿舍管理系统，运用简单的计算机操作实现快速检索和快速查找，方便信息录入和更新，本系统仅针对管理员进展使用。实现信息查询、日常管理、宿舍管理、信息维护几个方面的系统化管理：1、信息查询：a宿舍信息：包括宿舍楼编号、寝室编号、

6、入住人数、寝室入住人员*、用水量、用电量、水费、电费。b学生信息：包括学生、*、宿舍号c宿舍根本配置：包括床、柜子、灯、风扇、电视机2、宿舍管理：学生管理入住、更换宿舍、；房间管理增加、删除、查询3、信息维护：学生个人信息更新、宿舍信息更新、宿舍设备信息更新。2、系统开发环境开发所使用数据库系统：MySql开发环境：windows 7开发工具：Microsoft VisualStudio 2021开发语言：C+、SQL3、系统需求分析根本功能需求学生宿舍管理系统为了更好的进展宿舍管理而设计。用户的需求具体表达在各种信息的输入、修改和查询。系统功能实现如下：1、提供学生的入住信息的录入，更换宿舍

7、信息登记。提供各宿舍的具体信息，如宿舍楼栋、宿舍号、水费、电费等。并可通过查询宿舍号得到宿舍的具体信息、入住的学生信息、宿舍的设备信息等。2、提供管理员增加、删除各信息的功能。功能模块本宿舍管理系统的主要功能为：学生管理、宿舍信息管理、宿舍设备信息管理、信息查询、息更新、信息维护。数据字典1宿舍设备情况数据字典2宿舍信息情况数据字典3学生信息情况数据字典4、概念构造设计概念设计1学生实体：用于显示学生的属性，包括、*、宿舍编号。2宿舍实体：用于显示宿舍的属性，包括楼号、宿舍号、入住学生*、可住人数、已住人数、用水量、水费、用电量、电费。3宿舍设备实体：用于显示宿舍设备的属性，包括床、柜子、风扇

8、、灯、电视机。E_R模型设计学生实体E_R图2宿舍实体E_R图3宿舍物品设备实体E_R图4各实体关系E_R图5、逻辑构造设计将E-R图转换为关系模型：1Student：num、name、dormitoryCat；2Room：dormitoryCat、dormitory、room、studentNum、water、waterCharge、electricity、electricityCharge;3Item：dormitoryCat、bed、cabinet、light、fan、tv各表关系模型图：Item表外键设计：Student表外键设计：各表之间的关系模型图，Item表与Student表通过

9、外键与Room联系：6、数据实施和维护功能实现的代码/dbstruct.h*pragma onceclass dbStructpublic:MYSQL my;char errMsg300;/学生表charStudentNum9;charStudentName20;/宿舍chardormitoryCat6;chardormitory3;charroom4;doublewater;doubleelectricity;doublewaterCharge;doubleelectricityCharge;unsigned int members;/物件boolbed;boolcabinet;boolli

10、ght;boolfan;booltv;dbStruct();dbStruct();bool Init();bool GetStruct();/添加学生表一项bool InsertStudentTable();/改变一项bool SetStudentTable(char num9);/主键为num, vachar(8)/获取一项bool GetStudent(char num9);/*删除一项bool DeleteStudent(char num9);/添加宿舍表一项bool InsertDormitoryTable();/改变一项bool SetDormitoryTable(char dorm

11、itoryCat6);/主键为dormitoryCat, varchar(6)/获得一项bool GetDormitory(char dormitoryCat6);/删除一项bool DeleteDormitory(char dormitoryCat6);/添加物品表一项bool InsertItemTable();/改变一项bool SetItemTable(char dormitoryCat6);/主键为dormitoryCat, varchar(6)/获得一项bool GetItem(char dormitoryCat6);/*删除一项bool DeleteItem(char dormi

12、toryCat6);void ErrMB();/dbStruct.cpp*include stdaf*.hdbStruct:dbStruct()this-water = 0.0;this-electricity = 0.0;this-waterCharge = 0.0;this-electricityCharge = 0.0;this-members = 4;this-bed = TRUE;this-cabinet = TRUE;this-light = TRUE;this-fan = TRUE;this-tv = TRUE;dbStruct:dbStruct()mysql_close(&my

13、);bool dbStruct:Init()mysql_init(&this-my);if(!mysql_real_connect(&this-my, localhost, root, fast, dormitory, 0, NULL, 0)StringCchPrintfA(errMsg, 300, 获取寝室物件信息错误: %sn, mysql_error(&this-my);return false;mysql_query(&this-my, SET NAMES gbk);return true;/bool dbStruct:InsertStudentTable()if(this-dormi

14、toryCat = NULL |this-StudentName = NULL | this-StudentNum = NULL)StringCchPrintfA(errMsg, 100, 添加学生信息错误: 值不完整n);return FALSE;char query300;/获得该寝室已住人数数StringCchPrintfA(query, 300, SELECT count(dormitoryCat) FROM student WHERE dormitoryCat = 19425,this-dormitoryCat);mysql_query(&this-my, query);/可以确保在

15、数据库工作正常的情况下,能够查询到惟一的一条数据MYSQL_RES * res;res = mysql_use_result(&this-my);MYSQL_ROW row;int i; /i为已住人数while(row = mysql_fetch_row(res) != NULL)i = row00 - 0;mysql_free_result(res);if(+i 4)/超过了寝室最大人员数量StringCchPrintfA(errMsg, 300, 添加学生信息错误: 此寝室已满n);/*是否自动添加宿舍信息return FALSE;/可以添加学生信息StringCchPrintfA(qu

16、ery, 300,INSERT INTO student(num, name, dormitoryCat) VALUES(%s, %s, %s),this-StudentNum, this-StudentName, this-dormitoryCat);if(mysql_query(&this-my, query) != 0)StringCchPrintfA(errMsg, 300, 添加学生信息错误: %sn, mysql_error(&this-my);/*是否需要自动添加宿舍信息return FALSE;return TRUE;bool dbStruct:DeleteStudent(ch

17、ar num9)char query300;StringCchPrintfA(query, 300, DELETE FROM student WHERE num = %s, num);if(mysql_query(&this-my, query) != 0)StringCchPrintfA(errMsg, 300, 删除学生信息错误: %sn, mysql_error(&this-my);/*是否需要自动添加宿舍信息return FALSE;return TRUE;bool dbStruct:GetStudent(char num9)char query300;StringCchPrintfA

18、(query, 300, SELECT * FROM student WHERE num = %s, num);if(mysql_query(&this-my, query) != NULL)StringCchPrintfA(errMsg, 300, 获取学生信息错误: %sn, mysql_error(&this-my);return FALSE;MYSQL_RES * res;MYSQL_ROW row;res = mysql_use_result(&this-my);while(row = mysql_fetch_row(res) != NULL)StringCchPrintfA(thi

19、s-StudentNum, 9, row0);StringCchPrintfA(this-StudentName, 20, row1);StringCchPrintfA(this-dormitoryCat, 6, row2);mysql_free_result(res);return TRUE;/bool dbStruct:InsertDormitoryTable()if(this-dormitoryCat = NULL | this-room = NULL | this-dormitory = NULL)StringCchPrintfA(errMsg, 300, 添加宿舍信息错误: 值不完整

20、n);return FALSE;char query300;StringCchPrintfA(query, 300,INSERT INTO room(dormitoryCat, dormitory, room, studentsNum, water, electricity, waterCharge, electricityCharge) VALUES(%s, %s, %s, %d, %.2lf, %.2lf, %.2lf, %.2lf),this-dormitoryCat, this-dormitory, this-room,this-members, this-water, this-el

21、ectricity, this-waterCharge, this-electricityCharge);if(mysql_query(&this-my, query) != 0)StringCchPrintfA(errMsg, 300, 添加宿舍信息错误: %sn, mysql_error(&this-my);return FALSE;this-InsertItemTable();return TRUE;bool dbStruct:DeleteDormitory(char dormitoryCat6)/由于外键约束,删除此寝室时,相应的student和item表中的此寝室信息自动删除.cha

22、r query300;StringCchPrintfA(query, 300, DELETE FROM room WHERE dormitoryCat = %s, dormitoryCat);if(mysql_query(&this-my, query) != 0)StringCchPrintfA(errMsg, 300, 删除宿舍信息错误: %sn, mysql_error(&this-my);return FALSE;return TRUE;bool dbStruct:GetDormitory(char dormitoryCat6)char query300;StringCchPrintf

23、A(query, 300, SELECT * FROM room WHERE dormitoryCat = %s, dormitoryCat);if(mysql_query(&this-my, query) != NULL)StringCchPrintfA(errMsg, 300, 获取寝室信息错误: %sn, mysql_error(&this-my);return FALSE;MYSQL_RES * res;MYSQL_ROW row;res = mysql_use_result(&this-my);while(row = mysql_fetch_row(res) != NULL)Stri

24、ngCchPrintfA(this-dormitoryCat, 6, row0);StringCchPrintfA(this-dormitory, 3, row1);StringCchPrintfA(this-room, 4, row2);this-members = atoi(row3);this-water = atof(row4);this-electricity = atof(row5);this-waterCharge = atof(row6);this-electricityCharge = atof(row7);mysql_free_result(res);return TRUE

25、;/bool dbStruct:InsertItemTable()if(this-dormitoryCat = NULL)StringCchPrintfA(errMsg, 300, 添加宿舍信息错误: 值不完整n);return FALSE;char query300;StringCchPrintfA(query, 300,INSERT INTO item(dormitoryCat,bed, cabinet, light, fan, tv) VALUES(%s, %d, %d, %d, %d, %d),this-dormitoryCat, this-bed, this-cabinet, thi

26、s-light,this-fan, this-tv);if(mysql_query(&this-my, query) != 0)StringCchPrintfA(errMsg, 300, 添加宿舍物件信息错误: %sn, mysql_error(&this-my);return FALSE;return TRUE;bool dbStruct:GetItem(char dormitoryCat6)char query300;StringCchPrintfA(query, 300, SELECT * FROM item WHERE dormitoryCat = %s, dormitoryCat);

27、if(mysql_query(&this-my, query) != NULL)StringCchPrintfA(errMsg, 300, 获取寝室物件信息错误: %sn, mysql_error(&this-my);return FALSE;MYSQL_RES * res;MYSQL_ROW row;res = mysql_use_result(&this-my);while(row = mysql_fetch_row(res) != NULL)StringCchPrintfA(this-dormitoryCat, 6, row0);this-bed = (atoi(row3) = 1 tr

28、ue: false);this-cabinet = (atof(row4) = 1 true: false);this-light = (atof(row5) = 1 true: false);this-fan = (atof(row6) = 1 true: false);this-tv = (atof(row7) = 1 true: false);mysql_free_result(res);return TRUE;void dbStruct:ErrMB()MessageBo*A(GetActiveWindow(), this-errMsg, 发生错误!, MB_ICONERROR);/st

29、daf*.h*pragma once*include targetver.h/ Windows 头文件:*include *include *include *include / C 运行时头文件*include *include *include *include *include / TODO: 在此处引用程序需要的其他头文件*include dbStruct.h*pragma ment(lib, libmysql.lib)*pragma ment(lib, ctl32.lib)/stdaf*.cpp/ stdaf*.cpp : 只包括标准包含文件的源文件/ DormitoryMng.pc

30、h 将作为预编译头/ stdaf*.obj 将包含预编译类型信息*include stdaf*.h/dormitoryMng.h*pragma once*include resource.h*define MA*_LOADSTRING 100/dormitoryMng.cpp(局部代码)bool QueryStart(bool flag)char query300;if(flag = true)/查询寝室信息GetWindowTe*tA(GetDlgItem(g_hWndQuery, IDC_EDITBUILD), m_db.dormitory, 3);GetWindowTe*tA(GetDl

31、gItem(g_hWndQuery, IDC_EDITROOM), m_db.room, 4);if(strcmp(m_db.dormitory, ) = 0 & strcmp(m_db.room,) = 0)StringCchCopyA(query, 300,SELECT room.dormitoryCat,dormitory, room, studentsNum, count(student.dormitoryCat), water, electricity, waterCharge, electricityCharge FROM room LEFT JOIN student ON roo

32、m.dormitoryCat = student.dormitoryCat GROUP BY room.dormitoryCat);else if(strcmp(m_db.dormitory, ) != 0 & strcmp(m_db.room,) = 0)StringCchPrintfA(query, 300,SELECT room.dormitoryCat,dormitory, room, studentsNum, count(student.dormitoryCat), water, electricity, waterCharge, electricityCharge FROM roo

33、m LEFT JOIN student ON room.dormitoryCat = student.dormitoryCat WHERE dormitory = %s GROUP BY room.dormitoryCat,m_db.dormitory);else if(strcmp(m_db.dormitory, ) = 0 & strcmp(m_db.room,) != 0)StringCchPrintfA(query, 300,SELECT room.dormitoryCat,dormitory, room, studentsNum, count(student.dormitoryCat

34、), water, electricity, waterCharge, electricityCharge FROM room LEFT JOIN student ON room.dormitoryCat = student.dormitoryCat WHERE room = %s GROUP BY room.dormitoryCat,m_db.room);elseStringCchPrintfA(query, 300,SELECT room.dormitoryCat,dormitory, room, studentsNum, count(student.dormitoryCat), wate

35、r, electricity, waterCharge, electricityCharge FROM room LEFT JOIN student ON room.dormitoryCat = student.dormitoryCat WHERE dormitory = %s AND room = %s GROUP BY room.dormitoryCat,m_db.dormitory, m_db.room);if(true != QueryInput(L寝室号.楼栋号.寝室号.可住人数.当前人数.用水量.用电量.水费.电费, 9, query)m_db.ErrMB();else/查询学生信

36、息GetWindowTe*tA(GetDlgItem(g_hWndQuery, IDC_EDITSTUNO), m_db.StudentNum, 9);GetWindowTe*tA(GetDlgItem(g_hWndQuery, IDC_EDITSTUNAME), m_db.StudentName, 20);if(strcmp(m_db.StudentNum, ) = 0 & strcmp(m_db.StudentName, ) = 0)StringCchCopyA(query, 300,SELECT num, name, dormitoryCat FROM student);else if(

37、strcmp(m_db.StudentNum, ) != 0 & strcmp(m_db.StudentName, ) = 0)StringCchPrintfA(query, 300,SELECT num, name, dormitoryCat FROM student WHERE num = %s,m_db.StudentNum);else if(strcmp(m_db.StudentNum, ) = 0 & strcmp(m_db.StudentName, ) != 0)StringCchPrintfA(query, 300,SELECT num, name, dormitoryCat F

38、ROM student WHERE name = %s,m_db.StudentName);elseStringCchPrintfA(query, 300,SELECT num, name, dormitoryCat FROM student WHERE name = %s AND num = %s,m_db.StudentName, m_db.StudentNum);if(true != QueryInput(L*.所住寝室, 3, query)m_db.ErrMB();return TRUE;LRESULT CALLBACK WndProc(HWND hWnd, UINT message,

39、 WPARAM wParam, LPARAM lParam)int wmId, wmEvent;PAINTSTRUCT ps;HDC hdc;switch (message)case WM_CREATE:if(!m_db.Init()m_db.ErrMB();/*填写错误信息break;/创立列表CreateList(hWnd);/查询填充if(false = QueryInput(L寝室号.楼栋号.寝室号.可住人数.当前人数.用水量.用电量.水费.电费, 9,SELECT room.dormitoryCat,dormitory, room, studentsNum,count(student

40、.dormitoryCat),water,electricity, waterCharge,electricityCharge FROM room LEFT JOIN student ON room.dormitoryCat = student.dormitoryCat GROUP BY room.dormitoryCat)m_db.ErrMB();break;case WM_NOTIFY:LPNMITEMACTIVATE nc = (LPNMITEMACTIVATE)lParam;if(nc-hdr.code = NM_RCLICK & nc-iSubItem != 0)HMENU hMen

41、u = CreatePopupMenu();InsertMenu(hMenu, 0, MF_ENABLED, 10023, _T(删除);InsertMenu(hMenu, 0, MF_ENABLED, 10024, _T(详细信息);ClientToScreen(hWnd, &nc-ptAction);int result = TrackPopupMenu(hMenu, TPM_RETURNCMD | TPM_LEFTBUTTON| TPM_NOANIMATION,nc-ptAction.* + 5, nc-ptAction.y + 30, 0, hWnd, NULL);if(result

42、= 10023)wchar_t str9;ListView_GetItemTe*t(g_hWndList, nc-iItem, 2, str, 9);int iSize;char * szMultiByte;/宽字符转换成多字节型iSize = WideCharToMultiByte(CP_ACP, 0, str, -1, NULL, 0, NULL, NULL);szMultiByte = new chariSize;WideCharToMultiByte(CP_ACP, 0, str, -1, szMultiByte, iSize, NULL, NULL);if(iSize = 6)if(

43、!m_db.DeleteDormitory(szMultiByte)m_db.ErrMB();delete szMultiByte;break;/刷新ListView_DeleteAllItems(g_hWndList);while(ListView_DeleteColumn(g_hWndList, 1)if(true != QueryInput(L寝室号.楼栋号.寝室号.可住人数.当前人数.用水量.用电量.水费.电费, 9,SELECT room.dormitoryCat,dormitory, room, studentsNum,count(student.dormitoryCat),wat

44、er,electricity, waterCharge,electricityCharge FROM room LEFT JOIN student ON room.dormitoryCat = student.dormitoryCat GROUP BY room.dormitoryCat)m_db.ErrMB();elseif(!m_db.DeleteStudent(szMultiByte)m_db.ErrMB();delete szMultiByte;break;/刷新ListView_DeleteAllItems(g_hWndList);while(ListView_DeleteColum

45、n(g_hWndList, 1)if(true != QueryInput(L*.所住寝室, 3, SELECT * FROM student)m_db.ErrMB();delete szMultiByte;RedrawWindow(g_hWnd, NULL, NULL, RDW_INVALIDATE);break;case WM_MAND:wmId = LOWORD(wParam);wmEvent = HIWORD(wParam);/ 分析菜单项选择择:switch (wmId)case IDC_REFRESH:/刷新ListView_DeleteAllItems(g_hWndList);w

46、hile(ListView_DeleteColumn(g_hWndList, 1)if(true != QueryInput(L寝室号.楼栋号.寝室号.可住人数.当前人数.用水量.用电量.水费.电费, 9,SELECT room.dormitoryCat,dormitory, room, studentsNum,count(student.dormitoryCat),water,electricity, waterCharge,electricityCharge FROM room LEFT JOIN student ON room.dormitoryCat = student.dormito

47、ryCat GROUP BY room.dormitoryCat)m_db.ErrMB();RedrawWindow(g_hWnd, NULL, NULL, RDW_INVALIDATE);break;case IDC_DELETE:int itemCount;itemCount = ListView_GetItemCount(g_hWndList);for(int i = 0; i itemCount; i+)if(ListView_GetCheckState(g_hWndList, i)wchar_t str9;ListView_GetItemTe*t(g_hWndList, i, 2,

48、str, 9);int iSize;char * szMultiByte;/宽字符转换成多字节型iSize = WideCharToMultiByte(CP_ACP, 0, str, -1, NULL, 0, NULL, NULL);szMultiByte = new chariSize;WideCharToMultiByte(CP_ACP, 0, str, -1, szMultiByte, iSize, NULL, NULL);if(iSize = 6)if(!m_db.DeleteDormitory(szMultiByte)m_db.ErrMB();delete szMultiByte;b

49、reak;/刷新ListView_DeleteAllItems(g_hWndList);while(ListView_DeleteColumn(g_hWndList, 1)if(true != QueryInput(L寝室号.楼栋号.寝室号.可住人数.当前人数.用水量.用电量.水费.电费, 9,SELECT room.dormitoryCat,dormitory, room, studentsNum,count(student.dormitoryCat),water,electricity, waterCharge,electricityCharge FROM room LEFT JOIN s

50、tudent ON room.dormitoryCat = student.dormitoryCat GROUP BY room.dormitoryCat)m_db.ErrMB();elseif(!m_db.DeleteStudent(szMultiByte)m_db.ErrMB();delete szMultiByte;break;/刷新ListView_DeleteAllItems(g_hWndList);while(ListView_DeleteColumn(g_hWndList, 1)if(true != QueryInput(L*.所住寝室, 3, SELECT * FROM stu

51、dent)m_db.ErrMB();delete szMultiByte;break;break;case IDC_DELETESOME:int itemCount;int iSize;int i = 0;while(i (itemCount = ListView_GetItemCount(g_hWndList)if(ListView_GetCheckState(g_hWndList, i)wchar_t str9;ListView_GetItemTe*t(g_hWndList, i, 2, str, 9);char * szMultiByte;/宽字符转换成多字节型iSize = WideC

52、harToMultiByte(CP_ACP, 0, str, -1, NULL, 0, NULL, NULL);szMultiByte = new chariSize;WideCharToMultiByte(CP_ACP, 0, str, -1, szMultiByte, iSize, NULL, NULL);if(iSize = 6)if(!m_db.DeleteDormitory(szMultiByte)m_db.ErrMB();delete szMultiByte;return 0;elseif(!m_db.DeleteStudent(szMultiByte)m_db.ErrMB();d

53、elete szMultiByte;return 0;delete szMultiByte;break;elsei+;if(iSize = 6)/刷新ListView_DeleteAllItems(g_hWndList);while(ListView_DeleteColumn(g_hWndList, 1)if(true != QueryInput(L寝室号.楼栋号.寝室号.可住人数.当前人数.用水量.用电量.水费.电费, 9,SELECT room.dormitoryCat,dormitory, room, studentsNum,count(student.dormitoryCat),wat

54、er,electricity, waterCharge,electricityCharge FROM room LEFT JOIN student ON room.dormitoryCat = student.dormitoryCat GROUP BY room.dormitoryCat)m_db.ErrMB();else/刷新ListView_DeleteAllItems(g_hWndList);while(ListView_DeleteColumn(g_hWndList, 1)if(true != QueryInput(L*.所住寝室, 3, SELECT * FROM student)m

55、_db.ErrMB();break;case IDM_ABOUT:DialogBo*(g_hInst, MAKEINTRESOURCE(IDD_ABOUTBO*), hWnd, About);break;case IDM_E*IT:DestroyWindow(g_hWndQuery);DestroyWindow(g_hWndAddStu);DestroyWindow(g_hWndAddRoom);DestroyWindow(hWnd);break;case IDM_QUERY:if(firstQuery)g_hWndQuery = CreateDialog(g_hInst, MAKEINTRE

56、SOURCE(IDD_DLGQUERY), hWnd, Query);firstQuery = false;elseShowWindow(g_hWndQuery, SW_NORMAL);break;case IDM_ADDSTU:if(firstAddStu)g_hWndAddStu = CreateDialog(g_hInst, MAKEINTRESOURCE(IDD_STU), hWnd, AddStu);firstAddStu = false;elseShowWindow(g_hWndAddStu, SW_NORMAL);break;case IDM_ADDROOM:if(firstAd

57、dRoom)g_hWndAddRoom = CreateDialog(g_hInst, MAKEINTRESOURCE(IDD_ROOM), hWnd, AddRoom);firstAddRoom = false;elseShowWindow(g_hWndAddRoom, SW_NORMAL);break;default:return DefWindowProc(hWnd, message, wParam, lParam);break;case WM_PAINT:hdc = BeginPaint(hWnd, &ps);/ TODO: 在此添加任意绘图代码.HFONT guiFont = (HF

58、ONT)GetStockObject(DEFAULT_GUI_FONT);SelectObject(hdc, guiFont);SetBkMode(hdc, TRANSPARENT);SendDlgItemMessage(hWnd, IDC_DELETE, WM_SETFONT,(WPARAM)guiFont, TRUE);SendDlgItemMessage(hWnd, IDC_DELETESOME, WM_SETFONT,(WPARAM)guiFont, TRUE);SendDlgItemMessage(hWnd, IDC_REFRESH, WM_SETFONT,(WPARAM)guiFont, TRUE);char m6,n6;mysql_query(&m_db.my, SELECT count(do