当前位置:Gxlcms > mysql > 调用Mysql存储过程输入输出参数

调用Mysql存储过程输入输出参数

时间:2021-07-01 10:21:17 帮助过:62人阅读

欢迎进入Linux社区论坛,与200万技术人员互动交流 >>进入 nID = 0; nUserID = 0; nFeaLen = 0; memset(szFea,0,sizeof(szFea)); memset(szUrl,0,sizeof(szUrl)); nType1 = 0; nType2 = 0; nType3 = 0; memset(szType4,0,sizeof(szType4)); me

欢迎进入Linux社区论坛,与200万技术人员互动交流 >>进入

  nID = 0;

  nUserID = 0;

  nFeaLen = 0;

  memset(szFea,0,sizeof(szFea));

  memset(szUrl,0,sizeof(szUrl));

  nType1 = 0;

  nType2 = 0;

  nType3 = 0;

  memset(szType4,0,sizeof(szType4));

  memset(szStamp,0,sizeof(szStamp));

  memset(szRemarks,0,sizeof(szRemarks));

  }

  }FACE_INFO, *PFACE_INFO;

  //调研代码如下

  HRESULT CFaceDB::RegFaceP(FACE_INFO info,ULONGLONG & nID)

  {

  MYSQL_STMT * stmt_mysql = mysql_stmt_init(m_pMysql);

  try

  {

  MYSQL_BIND bind[11];

  memset(bind, 0, sizeof(bind));

  bind[0].buffer_type = MYSQL_TYPE_LONGLONG;

  bind[0].buffer = (unsigned char*)&nID;

  bind[0].buffer_length = (unsigned long)sizeof(nID);

  bind[0].length = 0;

  bind[1].buffer_type = MYSQL_TYPE_LONGLONG;

  bind[1].buffer = (unsigned char*)&info.nUserID;

  bind[1].buffer_length = (unsigned long)sizeof(info.nUserID);

  bind[1].length = 0;

  bind[2].buffer_type = MYSQL_TYPE_SHORT;

  bind[2].buffer = (unsigned char*)&info.nFeaLen;

  bind[2].buffer_length = (unsigned long)sizeof(info.nFeaLen);

  bind[2].length = 0;

  unsigned long nFeaLen = info.nFeaLen;

  bind[3].buffer_type = MYSQL_TYPE_BLOB; //特征值

  bind[3].buffer = (unsigned char*)info.szFea;

  bind[3].buffer_length = (unsigned long)nFeaLen;

  bind[3].length = &nFeaLen;

  unsigned long nUrlLen = strlen(info.szUrl);

  bind[4].buffer_type = MYSQL_TYPE_STRING; //ImgUrl

  bind[4].buffer = (char*)info.szUrl;

  bind[4].buffer_length = 64;

  bind[4].length = &nUrlLen;

  bind[5].buffer_type = MYSQL_TYPE_LONG; //type1

  bind[5].buffer = (unsigned char*)&info.nType1;

  bind[5].buffer_length = (unsigned long)sizeof(info.nType1);

  bind[5].length = 0;

  bind[6].buffer_type = MYSQL_TYPE_LONG; //type2

  bind[6].buffer = (unsigned char*)&info.nType2;

  bind[6].buffer_length = (unsigned long)sizeof(info.nType2);

  bind[6].length = 0;

  bind[7].buffer_type = MYSQL_TYPE_LONG; //type3

  bind[7].buffer = (unsigned char*)&info.nType3;

  bind[7].buffer_length = (unsigned long)sizeof(info.nType3);

  bind[7].length = 0;

  unsigned long nType4Len = strlen(info.szType4);

  bind[8].buffer_type = MYSQL_TYPE_STRING; //typ4

  bind[8].buffer = (char*)info.szType4;

  bind[8].buffer_length = 32;

  bind[8].length = &nType4Len;

  unsigned long nRemarksLen = strlen(info.szRemarks);

  bind[9].buffer_type = MYSQL_TYPE_STRING; //remarks

  bind[9].buffer = (char*)info.szRemarks;

  bind[9].buffer_length = 64;

  //bind[9].is_null = 0;

[1] [2] [3]

人气教程排行