失眠网,内容丰富有趣,生活中的好帮手!
失眠网 > 调用Mysql存储过程输入输出参数

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

时间:2024-03-17 06:02:31

相关推荐

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

数据库|mysql教程

调用,Mysql,存储,过程,输入,输出,参数,欢迎,进入,

数据库-mysql教程

足球平台源码,vscode怎么运行程序,ubuntu 快捷键,tomcat jre,连接 sqlite,个人网页设计作品中文,织梦数据库表dede_member_feed,全能型服务器,jquery旋转木马3d插件,游戏前端框架,ajax 爬虫,php返回,seo外链,springboot和springcloud,html标签中写js代码,网站输入密码访问,易语言 彗星网页框,程氏cms v4模板,html5网站后台模板怎么调用前台,js获取当前页面html,外卖送单管理系统,程序代码对比器lzw

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

在线培训网源码,ubuntu中自带vim,苹果手机怎么爬虫,php相片,定边seo公司lzw

易语言电话源码,vscode所有函数,ubuntu查看线程状态命令,c 与tomcat,sqlite显示字段类型,weiphp插件下载,汽车前端框架工艺,js怎么阻止爬虫,php的转义字符,seo分析报告案例,马克思网站源码,网页地图效果,投票调查问卷模板,手机页面选择日期代码,php企业信息化管理系统,企业建站系统支持小程序lzw

欢迎进入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存储过程输入输出参数》对你有帮助,请点赞、收藏,并留下你的观点哦!

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。