C/C++ SDK 快速入门

在项目中引入pdb_csdk.lib 并包含 pdb_api.h 文件，将pdb_csdk.dll 放到执行文件的目录中即可（注意：PinusDB提供的c sdk 为64位版本）。

一个简单的示例：

  1. #include <time.h>
  2. #include <stdio.h>
  3. #include "pdb_api.h"
  5. int main(int argc, char* argv[])
  6. {
  7.   PdbErr_t retVal = PdbE_OK;
  8.   int handle = 0;
  9.   size_t sucessCnt = 0;
  10.   char sqlBuf[1024];
  12.   retVal = pdb_connect("127.0.0.1", 8105, &handle);
  13.   if (retVal != PdbE_OK)
  14.   {
  15.     std::cout << "连接数据库失败:" << pdb_get_error_msg(retVal) << std::endl;
  16.     return 0;
  17.   }
  19.   do {
  20.     retVal = pdb_login(handle, "sa", "pinusdb");
  21.     if (retVal != PdbE_OK)
  22.     {
  23.       std::cout << "登录失败:" << pdb_get_error_msg(retVal) << std::endl;
  24.       break;
  25.     }
  27.     //创建表
  28.     retVal = pdb_execute_non_query(handle,
  29.       "create table tab01(
  30.        devid bigint,
  31.     tstamp datetime,
  32.     val01 bigint,
  33.     val02 float)");
  35.     if (retVal != PdbE_OK)
  36.     {
  37.       std::cout << "创建表失败:" << pdb_get_error_msg(retVal) << std::endl;
  38.       break;
  39.     }
  41.     //创建设备
  42.     retVal = pdb_execute_insert(handle,
  43.       "insert into sys_dev(tabname, devid, devname)
  44.        values('tab01', 1, 'dev_01'), ('tab01', 2, 'dev_02')", 
  45.        &sucessCnt, nullptr);
  46.     if (retVal != PdbE_OK)
  47.     {
  48.       std::cout << "创建设备失败:" << pdb_get_error_msg(retVal) << std::endl;
  49.       break;
  50.     }
  52.     sprintf_s(sqlBuf,
  53.       "insert into tab01(devid, tstamp, val01, val02) 
  54.       values(1, now(), 1023, 57.35),(2, now(), 10, 32.337)",
  55.       timeBuf, timeBuf);
  57.     retVal = pdb_execute_insert(handle, sqlBuf, &sucessCnt, nullptr);
  58.     if (retVal != PdbE_OK)
  59.     {
  60.       std::cout << "插入数据失败:" << pdb_get_error_msg(retVal) << std::endl;
  61.       break;
  62.     }
  64.   } while (false);
  66.   pdb_disconnect(handle);
  67.   return 0;
  68. }