Sanibonani nonke, lapha nginiphathela isibonelo sokuthi ukuxhumana phakathi kwe-C ++ ne-MySQL kuzoba kanjani ku-GNU / Linux, impela lesi yisibonelo nje. Okokuqala ukuhlanganisa ngizosebenzisa i-G ++ futhi kufanele babe namaphakeji afakiwe libmysql ++ y libmysql ++ - dev . Nasi isibonelo:
#hlanganisa #hlanganisa #hlanganisa usebenzisa i-namespace std; # chaza i-SERVER "HOST" # chaza USER "USR" # chaza i-PASSWORD "PSWD" #define DATABASE "example" int main () {MYSQL * connect; xhuma = mysql_init (NULL); uma (! xhuma) {cout << "Ukuqalisa kwe-MySQL kwehlulekile"; buyela 1; } connect = mysql_real_connect (xhuma, "HOST", "USER", "PASWD", "DATA BASE", 0, NULL, 0); uma (xhuma) {cout << "uxhumano Luphumelele \ n"; } okunye {cout << "ukuxhumeka kwehlulekile \ n"; } I-MYSQL_RES * isethi kabusha; MYSQL_ROW umugqa; i-mysql_query (xhuma, "khetha * kusuka kudatha;"); unsigned int i = 0; res_set = mysql_store_result (xhuma); unsigned int numrows = mysql_num_rows (res_set); cout << endl; cout << "\ t ---------------------------------------------- ------------------------- \ t "<< endlunkulu; ngenkathi (((row = mysql_fetch_row (res_set))! = NULL)) {// cout << "% s \ n", umugqa [i]! = NULL? umugqa [i]: "NULL"; cout << "\ t | \ t" << umugqa [i] << "\ t | \ t" << umugqa [i + 1] << "\ t | \ t" << umugqa [i + 2] << "\ t | \ t" << endl; cout << "\ t ---------------------------------------------- ------------------------- \ t "<< endlunkulu; } i-mysql_ vala (xhuma); buyela 0; }
Yebo, uma ungazi ukuthi ungahlanganisa kanjani ku-G ++ lesi yisibonelo:
g ++ -o main main.cpp -L / usr / include / mysql -lmysqlclient -I / usr / include / mysql
Ngemuva kwalokho uyayigijima futhi ibukeke kanjena:
------------------------------------- | 1 | UCarmen | 46 | --------------------------------- | 2 | UJuan | 56 | --------------------------------------
Qaphela: ungayihlanganisa futhi usebenzisa i-MAKEFILE METHOD.