56,679
社区成员
发帖
与我相关
我的任务
分享
DROP PROCEDURE IF EXISTS insertIOVandPosData;
delimiter //
CREATE procedure insertIOVandPosData(
IN INtest_ID int,
IN INvelocity float,
IN INposition float)
begin
insert into iovandpos (test_ID,velocity,position) values (INtest_ID,INvelocity,INposition);
end
//
delimiter ;
IOVandPos data;
data.test_ID = 1;
data.position = 1;
data.velocity = 1;
char buf[200];
sprintf_s(buf, "CALL insertIOVandPosData(%d,%f,%f)", data.test_ID, data.position, data.velocity);
mysql_query(&mysql, "START TRANSACTION"); // 开启事务, 如果没有开启事务,那么效率会变得非常低下!
for (int i = 0; i < 1000; i++)
{
if (mysql_query(&mysql, buf)) //执行SQL语句
{
::MessageBox(NULL, _T("操作失败"), _T("提示"), NULL);
return 0;
}
}
mysql_query(&mysql, "COMMIT"); // 提交事务