先编译poco
然后连接库
ln -s /usr/lib/libPocoData.so.16 /usr/lib64/libPocoData.so.16
 ln -s /usr/lib/libPocoDataSQLite.so.16 /usr/lib64/libPocoDataSQLite.so.16
ln -s /usr/lib/libPocoFoundation.so.16 /usr/lib64/libPocoFoundation.so.16

例子程序

点击(此处)折叠或打开

  1. #include <iostream>
  2. #include <string>
  3. #include "Poco/Data/Common.h"
  4. #include "Poco/Data/SQLite/Connector.h"
  5. using namespace Poco::Data;
  6. using namespace std;
  7. int main()
  8. {
  9.     std::string caseno="CNO1311";
  10.     SQLite::Connector::registerConnector();
  11.     int count = 0;
  12.     Session ses("SQLite","/tmp/hongrui.db");
  13.     ses << "DROP TABLE IF EXISTS Simpsons", now;
  14.     ses << "CREATE TABLE IF NOT EXISTS Simpsons (LastName VARCHAR(30), FirstName VARCHAR, Address VARCHAR, Age INTEGER(3))", now;
  15.     ses << "SELECT COUNT(*) FROM Simpsons ", into(count), now;
  16.     std::cout << "People in Simpsons " << count;
  17.     SQLite::Connector::unregisterConnector();
  18.     return 0;
  19. }

编译
gcc test1.cpp  -lPocoData  -lPocoDataSQLite -L/usr/lib
12-11 08:05
查看更多