I-CPP (aka C ++) + i-MySQL

Molweni nonke, apha ndiniphathela umzekelo wokuba unxibelelwano phakathi kwe-C++ kunye ne-MySQL lunokuba njani kwi-GNU/Linux, ngokuqinisekileyo lo ngumzekelo nje osisiseko. Okokuqala, ukuqokelela ndiza kusebenzisa i-G++ kwaye kufuneka ube neepakethe ezifakiwe libmysql++ y libmysql++-dev . Nanku umzekelo:

#zibandakanya #zibandakanya #zibandakanya usebenzisa isithuba segama std; #define SERVER "HOST" #define USER "USR" #define PASSWORD "PSWD" #define DATABASE "example" int main () {MYSQL *dibanisa; dibanisa=mysql_init(NULL); ukuba (!qhagamshela) { cout<<"Ukuqaliswa kweMySQL akuphumelelanga"; buyisela 1; } connect=mysql_real_connect(qhagamshela, "HOST", "USER", "PASWD" , "IDATA BASE" ,0,NULL,0); ukuba (qhagamshela) { cout<<"uqhagamshelwano luphumelele\n"; } enye { cout<<"uqhagamshelo aluphumelelanga\n"; } MYSQL_RES *seta kwakhona; MYSQL_ROW umqolo; mysql_query (qhagamshela,"khetha * kwidatha;"); ungasayinanga int i =0; res_set = mysql_store_result(dibanisa); ii-int numrows ezingatyikitywanga = mysql_num_rows(res_set); cout << endl; Cout <<"\t ------------------------------------------- ------------------------- \t"<< endl; ngelixa ((umqolo= mysql_fetch_row(res_set)) !=NULL )) { //cout<<" %s\n", umqolo[i] !=NULL?umqolo[i] : "NULL"; cout <<"\t | \t" << umqolo[i] << "\t | \t"<< umqolo[i+1] << "\t | \t"<< umqolo[i+2] << "\t | \t" << endl; Cout <<"\t ------------------------------------------- ------------------------- \t"<< endl; } mysql_vala (qhagamshela); buyisela i-0; }

Ewe, ukuba awuyazi indlela yokuqokelela kwi-G++, lo ngumzekelo:

g++ -o engundoqo.cpp -L/usr/bandakanya/mysql -lmysqlclient -I/usr/bandakanya/mysql

Emva koko uyayiqhuba kwaye iya kujongeka ngolu hlobo:

-------------------------------------- | 1 | UCarmen | 46 | -------------------------------------- | 2 | UYohane | 56 | --------------------------------------

Qaphela: unokuphinda uyiqulunqe usebenzisa i-MAKEFILE METHOD.