CPP (aka C ++) + MySQL

Mhoro munhu wese, pano ndinokuunzira muenzaniso wekuti kubatana pakati peC ++ neMySQL kwaizove kuri muGNU / Linux, zvirokwazvo uyu unongova muenzaniso wekutanga. Chekutanga pane zvese kuumbiridza ndiri kuzoshandisa G ++ uye ivo vanofanirwa kunge vaine mapakeji akaiswa libmysql ++ y libmysql ++ - dev . Zvakanaka heino muenzaniso:

#zvinosanganisira #zvinosanganisira #zvinosanganisira uchishandisa namespace std; # tsanangura SERVER "HOST" # tsanangura USER "USR" # tsanangura PASSWORD "PSWD" #define DATABASE "example" int main () {MYSQL * connect; batanidza = mysql_init (NULL); kana (! batanidza) {cout << "MySQL Initialization yakundikana"; dzoka 1; } batanidza = mysql_real_connect (batanidza, "HOST", "USER", "PASWD", "DATA BASE", 0, NULL, 0); kana (batanidza) {cout << "chinongedzo Chabudirira \ n"; } zvimwe {cout << "kubatana kwakundikana \ n"; } MYSQL_RES * res_set; MYSQL_ROW mutsara; mysql_query (batanidza, "sarudza * kubva kudata;"); isina kuiswa int i = 0; res_set = mysql_store_result (batanidza); unsigned int numrows = mysql_num_rows (res_set); cout << dzimba; cout << "\ t ---------------------------------------------------- ------------------------- \ t "<< dzimba; apo ((((row = mysql_fetch_row (res_set))! = NULL)) {// cout << "% s \ n", mutsara [i]! = NULL? mutsara [i]: "NULL"; cout << "\ t | \ t" << mutsara [i] << "\ t | \ t" << mutsara [i + 1] << "\ t | \ t" << mutsara [i + 2] << "\ t | \ t" << dzimba; cout << "\ t ---------------------------------------------------- --------------------- } mysql_vhara (batanidza); dzoka 0; }

Zvakanaka, kana iwe usinga zive kuumbiridza muG ++ uyu muenzaniso:

g ++ -o main main.cpp -L / usr / include / mysql -lmysqlclient -I / usr / inosanganisira / mysql

Ipapo iwe unomhanya uye zvaizoita seizvi:

--------------------------------- | 1 | Carmen | 46 | --------------------------------- | 2 | Juan | 56 | --------------------------------------

Tarira: iwe unogona zvakare kuumbiridza uchishandisa MAKEFILE METHOD.