C/C++ SDK 快速入门

当前版本:v3.0, 更新时间:2020-09-16

在项目中引入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. }