Home >Database >Mysql Tutorial >调用Mysql存储过程输入输出参数

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

WBOY
WBOYOriginal
2016-06-07 15:13:341995browse

欢迎进入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] 

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn