數(shù)據(jù)庫(kù)課程設(shè)計(jì)-學(xué)生宿舍管理系統(tǒng)(編輯修改稿)
2025-05-04 23:10 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 %d, %d, %d, %d, %d), thisdormitoryCat, thisbed, thiscabinet, thislight, thisfan, thistv)。 if(mysql_query(amp。thismy, query) != 0) { StringCchPrintfA(errMsg, 300, 添加宿舍物件信息錯(cuò)誤: %s\n, mysql_error(amp。thismy))。 return FALSE。 } return TRUE。}bool dbStruct::GetItem(char dormitoryCat[6]){ char query[300]。 StringCchPrintfA(query, 300, SELECT * FROM item WHERE dormitoryCat = \%s\, dormitoryCat)。 if(mysql_query(amp。thismy, query) != NULL) { StringCchPrintfA(errMsg, 300, 獲取寢室物件信息錯(cuò)誤: %s\n, mysql_error(amp。thismy))。 return FALSE。 } MYSQL_RES * res。 MYSQL_ROW row。 res = mysql_use_result(amp。thismy)。 while((row = mysql_fetch_row(res)) != NULL) { StringCchPrintfA(thisdormitoryCat, 6, row[0])。 thisbed = (atoi(row[3]) == 1? true: false)。 thiscabinet = (atof(row[4]) == 1? true: false)。 thislight = (atof(row[5]) == 1? true: false)。 thisfan = (atof(row[6]) == 1? true: false)。 thistv = (atof(row[7]) == 1? true: false)。 } mysql_free_result(res)。 return TRUE。}void dbStruct::ErrMB(){ MessageBoxA(GetActiveWindow(), thiserrMsg, 發(fā)生錯(cuò)誤!, MB_ICONERROR)。}//pragma onceinclude // Windows 頭文件:include include include include // C 運(yùn)行時(shí)頭文件include include include include include // TODO: 在此處引用程序需要的其他頭文件include pragma ment(lib, )pragma ment(lib, )//// : 只包括標(biāo)準(zhǔn)包含文件的源文件// 將作為預(yù)編譯頭// 將包含預(yù)編譯類型信息include //pragma onceinclude define MAX_LOADSTRING 100//(部分代碼)bool QueryStart(bool flag){ char query[300]。 if(flag == true)//查詢寢室信息 { GetWindowTextA(GetDlgItem(g_hWndQuery, IDC_EDITBUILD), , 3)。 GetWindowTextA(GetDlgItem(g_hWndQuery, IDC_EDITROOM), , 4)。 if(strcmp(, ) == 0 amp。amp。 strcmp(,) == 0) { StringCchCopyA(query, 300, SELECT ,dormitory, room, studentsNum, \ count(), water, electricity, waterCharge, \ electricityCharge FROM room LEFT JOIN student ON = \ GROUP BY )。 } else if(strcmp(, ) != 0 amp。amp。 strcmp(,) == 0) { StringCchPrintfA(query, 300, SELECT ,dormitory, room, studentsNum, \ count(), water, electricity, waterCharge, \ electricityCharge FROM room LEFT JOIN student ON = \ WHERE dormitory = \%s\ GROUP BY , )。 } else if(strcmp(, ) == 0 amp。amp。 strcmp(,) != 0) { StringCchPrintfA(query, 300, SELECT ,dormitory, room, studentsNum, \ count(), water, electricity, waterCharge, \ electricityCharge FROM room LEFT JOIN student ON = \ WHERE room = \%s\ GROUP BY , )。 } else { StringCchPrintfA(query, 300, SELECT ,dormitory, room, studentsNum, \ count(), water, electricity, waterCharge, \ electricityCharge FROM room LEFT JOIN student ON = \ WHERE dormitory = \%s\ AND room = \%s\ GROUP BY , , )。 } if(true != QueryInput(L, 9, query)) { ()。 } } else//查詢學(xué)生信息 { GetWindowTextA(GetDlgItem(g_hWndQuery, IDC_EDITSTUNO), , 9)。 GetWindowTextA(GetDlgItem(g_hWndQuery, IDC_EDITSTUNAME), , 20)。 if(strcmp(, ) == 0 amp。amp。 strcmp(, ) == 0) { StringCchCopyA(query, 300, SELECT num, name, dormitoryCat FROM student)。 } else if(strcmp(, ) != 0 amp。amp。 strcmp(, ) == 0) { StringCchPrintfA(query, 300, SELECT num, name, dormitoryCat FROM student WHERE num = \%s\, )。 } else if(strcmp(, ) == 0 amp。amp。 strcmp(, ) != 0) { StringCchPrintfA(query, 300, SELECT num, name, dormitoryCat FROM student WHERE name = \%s\, )。 } else { StringCchPrintfA(query, 300, SELECT num, name, dormitoryCat FROM student WHERE name = \%s\ AND num = \%s\, , )。 } if(true != QueryInput(L, 3, query)) { ()。 } } return TRUE。}LRESULT CALLBACK WndProc(HWND hWnd, UINT message, WPARAM wParam, LPARAM lParam){ int wmId, wmEvent。 PAINTSTRUCT ps。 HDC hdc。 switch (message) { case WM_CREATE: { if(!()) { ()。 //*********填寫錯(cuò)誤信息 break。 } //創(chuàng)建列表 CreateList(hWnd)。 //查詢填充 if(false == QueryInput(L, 9, SELECT ,dormitory, room, studentsNum,\ count(),water,electricity, waterCharge,\ electricityCharge FROM room LEFT JOIN student ON \ = GROUP BY )) { ()。 } } break。 case WM_NOTIFY: { LPNMITEMACTIVATE nc = (LPNMITEMACTIVATE)lParam。 if(nc == NM_RCLICK amp。amp。 nciSubItem != 0) { HMENU hMenu = CreatePopupMenu()。 InsertMenu(hMenu, 0, MF_ENABLED, 10023, _T(刪除))。 InsertMenu(hMenu, 0, MF_ENA
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1