CPP (aka C ++) + MySQL

MySQL

Assalamu alaikum, a nan na kawo muku misalin yadda alaka tsakanin C ++ da MySQL zai kasance a cikin GNU / Linux, tabbas wannan misali ne na asali. Da farko dai zan tattara zanyi amfani da G ++ kuma dole ne a girka fakitin libmysql ++ y libmysql ++ - dev . To ga misali:

# hada # hada # hada ta amfani da sunan sararin samaniya std; #define SERVER "HOST" #define USER "USR" #define PASSWORD "PSWD" #define DATABASE "misali" int main () {MYSQL * haɗi; connect = mysql_init (NULL); idan (! haɗa) {cout << "MySQL Initialization bai yi nasara ba"; dawo 1; } haɗa = mysql_real_connect (haɗa, "HOST", "MAI AMFANI", "PASWD", "BAYANAN DATA", 0, NULL, 0); idan (haɗa) {cout << "haɗi Ya Ci nasara \ n"; } kuma {cout << "haɗi ya kasa \ n"; } MYSQL_RES * sake saitawa; Layin MYSQL_ROW; mysql_query (haɗa, "zaɓi * daga bayanai;"); mara sa hannu int i = 0; res_set = mysql_store_result (haɗa); rashin sa hannu int numrows = mysql_num_rows (res_set); aiki << endl; aiki << "\ t -------------------------------------------- ------------------------- \ t "<< endl; yayin (((jere = mysql_fetch_row (res_set))! = NULL)) {// cout << "% s \ n", jere [i]! = NULL? jere [i]: "NULL"; aiki << "\ t | \ t" << jere [i] << "\ t | \ t" << jere [i + 1] << "\ t | \ t" << jere [i + 2] << "\ t | \ t" << endl; aiki << "\ t -------------------------------------------- ------------------------- \ t "<< endl; } mysql_close (haɗa); dawo da 0; }

Da kyau, idan baku san yadda ake tarawa a cikin G ++ wannan misali bane:

g ++ -o main main.cpp -L / usr / sun hada da / mysql -lmysqlclient -I / usr / sun hada da / mysql

To kuna gudanar da shi kuma zai zama kamar haka:

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

Lura: zaka iya harhada shi ta hanyar MAKEFILE METHOD.


Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Wanda ke da alhakin bayanan: Miguel Ángel Gatón
  2. Manufar bayanan: Sarrafa SPAM, sarrafa sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.

  1.   kunun 92 m

    C ++ ... wancan yaren ne ya kayar dani tun tuni ...

    1.    lokacin3000 m

      Ina jin yunwa game da wannan yarukan shirye-shiryen (haske da damar da yake bayarwa ba za'a iya maye gurbinsu ba).

      1.    kunun 92 m

        Ba na ce a'a, kawai saboda yana da matukar wahala a gare ni, Python ko mono, da alama sun fi sauƙi a yi amfani da su.

        1.    giskar m

          Tsaya tare da Python. Ya sanya ku ƙara yawan aiki cikin kankanin lokaci.

        2.    lokacin3000 m

          Python na iya zama, don samun damar gyara kwari da ke rage shirye-shirye kamar cibiyar software ko Ubiquiti, amma Java, don kawai kashe lokaci.

          A zahiri, tare da C ++ Zan iya fahimtar lambobin sosai (kodayake yawancin suna ganin mahimman lambobin da ba za a iya karantawa ba) kuma zan iya samun cikakken ra'ayi game da abin da zai yi (kodayake Java ya fi sauƙin fahimtar lambar a karon farko, Na gan shi kamar dai BASIC ne kuma in faɗi gaskiya, Na fi so in yi aiki tare da OpenJDK maimakon Java JDK don tsoron kada Oracle ya sa ƙarin kwari don fuck).

    2.    nelson m

      ne ma

  2.   ƙarfe m

    Godiya aboki.

  3.   Eduardo m

    Misali na asali? To, zai zama na gargajiya:
    aji: 2 + 2 = 4
    aiki: 2 × 3 = 6
    Gwaji: idan Eduardo yana da lemu 20 kuma dole ne ya raba su tsakanin yara 4, menene nauyin jikin yaran?

    1.    lokacin3000 m

      1.- Warware matsalar (abu mafi mahimmanci kuma menene ainihin ɗaukar lokaci mai tsawo).
      2.- Fassara bayani zuwa C ++ (idan yaren ne, sababbi zasu daina a mafi yawan lokuta kuma ƙari idan suna amfani da GNU Emacs).
      3.- Yin kuskure a matsayin kariya da harhadawa (a zahiri shi ne akasin haka, amma kadan ne ke yin hakan).

      PS: Wannan gwajin yana maganin anti-smug / pedantic.

  4.   Eduardo m

    Gafarar shari'ar ga bayanin a cikin sau uku, amma shafin ya ba ni kuskuren sabar ciki kuma wataƙila saboda wannan, lokacin da aka sake gwadawa, an sake buga shi.
    Gaisuwa da godiya ga post din !!

    1.    lokacin3000 m

      Babu matsala. Koyaya, Ina yin tsokaci ne akan Chromium da dare na Windows kuma ban sami matsala irin wannan ba lokacin da nake yin tsokaci (kodayake ina ba ku shawarar ku yi rajista don tsarin sharhi zai jefa muku kurakurai fiye da Windows Millenium).

      1.    lokacin3000 m

        Na so na ce: "duk da cewa ina ba da shawarar da ka yi rajista ta yadda tsarin tsokaci zai jefa maka kurakurai kasa da na Windows Millenium" [errare humanum est].

        1.    kunun 92 m

          muryarta LOL

  5.   lokacin3000 m

    Wannan lambar ita ce mafi kyawun C ++ Na gani (mai kallo bayanan KISS-style).

    Yanzu, idan za'a iya haɗa wannan lambar akan Windows ta amfani da GNU Emacs tare da GCC akan Windows (tare da MySQL / MariaDB haɗe), zai zama babban ci gaba.

  6.   kashe bera m

    Babu shakka c ++ shine mafi kyawun abin da muke da shi, Na yi gwaje-gwaje marasa iyaka game da aikin da damar da yake ba mu kuma ba tare da wata shakka ba abin da ya wuce shi hakika na san cewa zai iya zama ciwon kai ga wasu

    1.    lokacin3000 m

      Ina sha'awar wannan yaren, amma banda aikin (kuma ya isa) don iya mallake shi kwata-kwata kuma don haka in sami damar hada aikace-aikacen gani da Qt.

  7.   jamin samuel m

    Huy ba

    Na fi son Python

    😀

    1.    kashe bera m

      To kowane mahaukaci tare da taken gaisuwarsa

    2.    giskar m

      Kyakkyawan zaɓi.

    3.    lokacin3000 m

      [son kai] Raggo [/ son kai].

  8.   julian m

    Na fi son VB.NET, ya fi sauƙi kuma yana da kyakkyawan tallafi ga SQL Server. Baya ga kasancewa mai fa'ida fiye da sauran harsuna kuma ɗayan mafi yawan buƙata yayin neman aiki. Bana son bata lokacina da C ++

    1.    kunun 92 m

      Idan muka sanya shi kamar haka, mafi yawan buƙata galibi abin ƙyamar Java ne.

      1.    lokacin3000 m

        Daidai yake da VB.NET, amma yafi zana hoto kuma ba shi da amfani a yi aiki akan GNU / Linux.

  9.   kashe bera m

    Ina kawai bayar da shawarar C ++ bc bincike ƙirƙirar sauƙi sayar a c ++, python da qt da shinge mamaki:
    Python-> 7.6 mb
    Qt -> 27 mb (XD)
    C ++ -> 2.4 mb

    Da kyau kowa ya zana nashi gaisuwa

    1.    giskar m

      Python 7.6MB ??? Babu hanya! Ba shi yiwuwa. Idan basu zama komai ba sai rubutu. Ko kuna da hotuna? Raba lambar. Wannan shine yadda duk muke ganinsa da kwatanta shi. Ka shawo mana.

      1.    kashe bera m

        Kuna da gaskiya karamin bugun tsutsotsi bai cinye 7.6 mb ba amma idan 6.2 mb don haka ku gaya mani yanzu ...
        Wannan lambar ce kuma ina tsammanin ba za a iya inganta shi ba:
        #! / usr / bin / Python
        daga gi.idan ajiya shigo da Gtk

        win = Gtk.Window (())
        win.connect ("share-taron", Gtk.main_quit)
        win_kashi_daga ()
        Gtk.main ()

        1.    giskar m

          Ina tsammanin kuna nufin amfani da RAM. Abinda yake shine, a cikin Python kuma a kusan kowane yare, kuna da girman sifar asymptotic yayin da kuke rikitar da lambar. Kawai don gwaji na gudanar da wasan da nake haɓakawa tare da PyGame. Sauti + sauti na bango + don abubuwan da suka faru da ƙyar ya isa 14MB. Kamar yadda a fili shirinku ba zai zama mai sauƙi kamar taga ba amma zai fi rikitarwa, zaku ga a ƙarshe cewa, lokacin da kuka sami wadatacciyar lambar, manyan gyare-gyare a ciki ba zasu kawo muku ƙaruwar amfani da RAM ba.

        2.    giskar m

          Don sauƙaƙa abin da nake bayani kaɗan: Ba za ku iya yin bayanin lokaci ba idan ba ku tafiyar da ɓangaren lambar a cikin thousandan dubunnan sau, ko? Da kyau, a daidai wannan hanyar ba za ku iya sanin ko yare yana cinyewa mai yawa ko kaɗan kawai ta hanyar duban mafi sauƙin misali ba. A zahiri, dabarar ita ce duba mafi rikitarwa da zaku iya.

          1.    kashe bera m

            Da kyau a fahimtata a matakin shirye-shirye wannan 01010111, mai haɗawa sannan kuma c, don haka ba zai yuwu ba cewa da babban yare kamar Python ya zarce ac / c ++ wajen aiwatarwa (ta kowane fanni) kuma da kyau, menene mafi kyau fiye da sauƙin misali kamar na ƙirƙirar taga don ganin bambanci na 3.8 mb a kawai nuna taga mai sauƙi, lokacin da kuka ƙara kaya a cikin shirin ku (babban shiri, wanda ke da nauyi mai kyau tare da fom sama da 5, kuma kuna amfani da azuzuwan, gado, polymorphism, ayyuka na kamala, alamomi da ƙari don bada misali) Ina baku tabbacin cewa zaku canza ra'ayin ku, Ina so in bayyana cewa bana kushe wasu yarukan shirye-shirye kuma mafi ƙarancin Python ga cantrario, Ina yin tsokaci ne kawai kuma gwada tare da jarabawa fa'idodi da rashin amfanin da nake gani da ido ba tare da ƙarfafa zurfafa gaisuwa ba

          2.    giskar m

            Duba wannan:

            http://www.youtube.com/watch?v=cPVlYWxcu18

            Amma kalli cikakken bidiyon. Kada ku yaudare cewa in ba haka ba zaku ba da ra'ayi kawai bisa son zuciya.

          3.    giskar m

            A kowane hali ba ku fahimce ni ba. Yayin da kuke wahalar da lamarin, duka biyun zasuyi nauyi ko ƙasa da nauyi ɗaya. A shafin Li'azaru suna ba da hoto game da hakan ta hanya, kwatanta Li'azaru da C.
            A ƙarshe komai aboki ne na dangi. Domin mutum baya rayuwa akan RAM shi kadai.

    2.    lokacin3000 m

      Aƙalla QT ya dace da Aqua, Win32 (da nau'ikan Aero da Metro ɗin su) musaya da sauran hanyoyin musaya banda LXDE (yana kama da Windows 95 mai gaskiya).

      1.    kunun 92 m

        gtk2 a cikin ruwa yana da kyau ...