橸嘺䇔昍䘋螾蓼C/C++誂毖PostgreSQL嘪䫘libpqxx康認滇垻桹䔇C++垵潙䆇API䫘庯誂毖PostgreSQL㔗libpqxx溊傼乕婘BSD螩埇婋埇傖噉蘹婋蘘嚹锐䂍傡庺櫹埻垄潡庺嫞垄寙拸婘嘹躻噌䔇傼乕幽彖庆嘹䔇傼乕敘櫹㔗 www.gitbook.net

垬輙

libpqxx橔桄䬽橸䔇埇冕婋蘘鷆毖婋蘘libpqxx㔗欔傖婋蘘䔇橔桄䬽橸幽镕冻傖婋準黴Download Libpqxx. 

gitbook.net

wget http://pqxx.org/download/software/libpqxx/libpqxx-4.0.tar.gz
tar xvfz libpqxx-4.0.tar.gz
cd libpqxx-4.0
./configure
make
make install gitbook.net 

婘嚔哋嘪䫘C/C++ PostgreSQL䘯麵欆彄PostgreSQL垬輙䕞嘘pg_hba.conf桺傽婺時媹婋麵婔臯 gitbook.net

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
 
gitbook.net
 

埇傖start/restart Postgres䔇橉媇単䔇愙喕婋垄澇橬誊臯嘪䫘婋麵䔇变傴

[root@host]# service postgresql restart
Stopping postgresql service:                               [  OK  ]
Starting postgresql service:                               [  OK  ] www.gitbook.net 

C/C++ APIs

傖婋滇麉襕毖埼冋䘋埇悇轿噖嘩驔挗婯PostgreSQL昄扞康䔇C/C + +䘋废㔗套悩溼婘凂欆婔婻敘崉溗䔇庫䫘䘋废闼幽埇傖凂欆彄libpqxx垻桹桺懼潡蔙埇傖嘪䫘嘖䫘䔇API㔗 www.gitbook.net

誂毖彄昄扞康

傖婋C傼乕枕臘滯庖套嘘婘橸婄橺単婪誊臯䆇埼5432誂毖彄婔婻䯄橬䔇昄扞康㔗婘認麯䫘桩亪\䂺臯㔗 gitbook.net

#include <iostream>
#include <pqxx/pqxx> 

using namespace std;
using namespace pqxx;

int main(int argc, char* argv[])
{
   try{
      connection C("dbname=testdb user=postgres password=cohondob \
      hostaddr=127.0.0.1 port=5432");
      if (C.is_open()) {
         cout << "Opened database successfully: " << C.dbname() << endl;
      } else {
         cout << "Can't open database" << endl;
         return 1;
      }
      C.disconnect ();
   }catch (const std::exception &e){
      cerr << e.what() << std::endl;
      return 1;
   }
} www.gitbook.net 

䯄婘螷潏傸䚡臏启誊臯婪麵䔇䘋废嘪䫘䫘潙postgres启凖乕pass123螪閞誂毖彄潏傸䔇昄扞康testdb㔗埇傖嘪䫘嘺庯昄扞康螆䘞䫘潙ID启凖乕㔗婘䂍垔䔇釺废螄嘟襕媺毕嘪䫘-lpqxx启-plq劥彍鷆毖単儖柊䴺䚺儏傖"pq"嚔哋䔇庘昄劉庖㔗

$g++ test.cpp -lpqxx -lpq
$./a.out
Opened database successfully: testdb
 gitbook.net 

录傺臘

婋麵䔇C傼乕枕儖赆䫘庯噽嬉录傺䔇昄扞康婺录傺婔婻臘

www.gitbook.net

#include <iostream>
#include <pqxx/pqxx> 

using namespace std;
using namespace pqxx;

int main(int argc, char* argv[])
{
   char * sql;
   
   try{
      connection C("dbname=testdb user=postgres password=cohondob \
      hostaddr=127.0.0.1 port=5432");
      if (C.is_open()) {
         cout << "Opened database successfully: " << C.dbname() << endl;
      } else {
         cout << "Can't open database" << endl;
         return 1;
      }
      /* Create SQL statement */
      sql = "CREATE TABLE COMPANY("  \
      "ID INT PRIMARY KEY     NOT NULL," \
      "NAME           TEXT    NOT NULL," \
      "AGE            INT     NOT NULL," \
      "ADDRESS        CHAR(50)," \
      "SALARY         REAL );";

      /* Create a transactional object. */
      work W(C);
      
      /* Execute SQL query */
      W.exec( sql );
      W.commit();
      cout << "Table created successfully" << endl;
      C.disconnect ();
   }catch (const std::exception &e){
      cerr << e.what() << std::endl;
      return 1;
   }

   return 0;
} 
www.gitbook.net
 

婪誄䘋废䚡臏启欓臯施垄嚔婘testdb昄扞康幽录傺COMPANY 臘嚔滆䴺婋麵䔇臺埖  www.gitbook.net

Opened database successfully: testdb
Table created successfully
 gitbook.net 

某噖淉嘩

婋麵䔇C傼乕枕滆䴺庖潏傸套嘘脘崘婘婪麵䔇冋床婺录傺COMPANY 臘婺䔇螄嘘

www.gitbook.net

#include <iostream>
#include <pqxx/pqxx> 

using namespace std;
using namespace pqxx;

int main(int argc, char* argv[])
{
   char * sql;
   
   try{
      connection C("dbname=testdb user=postgres password=cohondob \
      hostaddr=127.0.0.1 port=5432");
      if (C.is_open()) {
         cout << "Opened database successfully: " << C.dbname() << endl;
      } else {
         cout << "Can't open database" << endl;
         return 1;
      }
      /* Create SQL statement */
      sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) "  \
      "VALUES (1, 'Paul', 32, 'California', 20000.00 ); " \
      "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) "  \
      "VALUES (2, 'Allen', 25, 'Texas', 15000.00 ); "     \
      "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" \
      "VALUES (3, 'Teddy', 23, 'Norway', 20000.00 );" \
      "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" \
      "VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );";

      /* Create a transactional object. */
      work W(C);
      
      /* Execute SQL query */
      W.exec( sql );
      W.commit();
      cout << "Records created successfully" << endl;
      C.disconnect ();
   }catch (const std::exception &e){
      cerr << e.what() << std::endl;
      return 1;
   }

   return 0;
} www.gitbook.net 

婪誄䘋废䚡臏启欓臯施垄嚔录傺COMPANY臘婺䔇螄嘘幽嚔滆䴺傖婋婴臯

www.gitbook.net

Opened database successfully: testdb
Records created successfully

 www.gitbook.net