Jmeter&mysql存储过程实现曾删改查

1、先在数据库中创建一个存储过程

DROP PROCEDURE IF EXISTS SQLoperation;

create PROCEDURE SQLoperation()

BEGIN

   insert into userinfo(userid,username,userpassword) values('6','cyt','cyt123');

   update userinfo set USERPASSWORD='123456' where USERID='6';

   select * from userinfo WHERE USERNAME='cyt';

   delete from userinfo where USERID='6';

END

 2、将之前写sql语句的地方改成cal  存储过程名就ok了

 

转载于:https://www.cnblogs.com/cyt456/p/4176098.html