資源簡介
學生管理系統,按照說明建立數據庫,連接數據庫直接可以運行,用MFC實現,適合MFC,Mysql新學者看!

代碼片段和文件信息
#include????
#include????
#include????
#include????
#include???
#pragma?comment(lib?“libmysql.lib“)
#include?“stdafx.h“??
??
using?namespace?std;???
??
int?main(int?argc?_TCHAR*?argv[])???
{???
??
????char?*host?=?“localhost“;???
????char?*user?=?“root“;???
????char?*pass?=?“root“;???
????char?*db?=?“mysql“;???
???????
????MYSQL?*sock;???
????MYSQL_RES?*results;???
????MYSQL_ROW?record;???
????sock?=?mysql_init(0);???
????if?(sock)????
????????cout?<“sock?handle?ok!“?<????else????
????{???
????????cout?<“sock?handle?failed!“?<????}???
??
????//connection???
????if?(mysql_real_connect(sock?host?user?pass?db?0?NULL?0))???
????????cout?<“connection?ok!“?<????else????
????{???
????????cout?<“connection?fail:?“?<????}???
????mysql_set_character_set(sock“utf8“);???
???????
????//connection?character?set???
????cout?<“connection?character?set:?“?<??
????//wait?for?posibility?to?check?system/mysql?sockets???
????if(mysql_query(sock“select?*?from?user“))???
????{???
????????cout<<“very?good!“< ????}???
????results=mysql_store_result(sock);???
????printf(“主機\t用戶名\n“);???
????while(record?=?mysql_fetch_row(results))???
????{???
????????printf(“%s\t%s?\n“record[0]record[1]);???
????}???
????mysql_free_result(results);???
????//system(“PAUSE“);???
???????
????//closing?connection???
????mysql_close(sock);???
??
????return?EXIT_SUCCESS;???
????//return?0;???
}??
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1089??2009-11-15?09:52??uytre\uytre.clw
?????文件???????3561??2009-11-15?08:54??uytre\ReadMe.txt
?????文件???????1313??2009-11-15?08:54??uytre\uytre.h
?????文件???????2049??2009-11-15?08:54??uytre\uytre.cpp
?????文件???????1054??2009-11-15?08:54??uytre\StdAfx.h
?????文件????????207??2009-11-15?08:54??uytre\StdAfx.cpp
?????文件????????397??2009-11-15?08:54??uytre\res\uytre.rc2
?????文件???????1078??2009-11-15?08:54??uytre\res\uytre.ico
?????文件???????4255??2009-11-15?09:52??uytre\uytre.dsp
?????文件????????516??2009-11-15?08:54??uytre\uytre.dsw
?????文件?????295936??2009-11-15?09:28??uytre\Debug\vc60.idb
?????文件?????454656??2009-11-15?09:28??uytre\Debug\vc60.pdb
?????文件???????2484??2009-11-15?09:16??uytre\Debug\uytre.res
?????文件????5703756??2009-11-15?09:00??uytre\Debug\uytre.pch
?????文件?????105548??2009-11-15?09:00??uytre\Debug\StdAfx.obj
?????文件?????110644??2009-11-15?09:28??uytre\Debug\uytre.exe
?????文件?????394240??2009-11-15?09:28??uytre\Debug\uytre.pdb
?????文件??????29966??2009-11-15?09:07??uytre\Debug\rt.obj
?????文件??????23402??2009-11-15?09:16??uytre\Debug\uytre.obj
?????文件?????219804??2009-11-15?09:28??uytre\Debug\uytre.ilk
?????文件??????50953??2009-11-15?09:28??uytre\Debug\uytreDlg.obj
?????文件????????915??2009-11-15?09:28??uytre\uytre.plg
?????文件???????1680??2009-11-15?09:07??uytre\rt.cpp
?????文件???????1316??2009-11-15?09:14??uytre\uytreDlg.h
?????文件???????5227??2009-11-15?09:16??uytre\uytre.rc
?????文件????????683??2009-11-15?09:16??uytre\Resource.h
?????文件??????35384??2009-11-15?09:16??uytre\uytre.aps
?????文件???????5781??2009-11-15?09:28??uytre\uytreDlg.cpp
?????目錄??????????0??2009-11-15?08:54??uytre\res
?????目錄??????????0??2009-11-15?08:54??uytre\Debug
............此處省略7個文件信息
評論
共有 條評論