【lr】mysql增删改查脚本

vuser_init：

#define MYSQLSERVER "mysql所在服务器ip"

#define MYSQLUSERNAME "root"
#define MYSQLPASSWORD "123456"
#define MYSQLDB "test"
#define MYSQLPORT "3306"


#include "Ptt_Mysql.h"

vuser_init()
{
return 0;

}

Action()
{


char ch1[128],ch2[128],ch3[128],ch4[128];
MYSQL *Mconn;


lr_load_dll("libmysql.dll"); //MySQL LoadRunner libraries解压后的bin和include放于loadrunner目录下对应的bin和include下
//连接数据库
Mconn = lr_mysql_connect(MYSQLSERVER, MYSQLUSERNAME, MYSQLPASSWORD, MYSQLDB, atoi(MYSQLPORT));


//准备数据并赋值
lr_save_string(lr_eval_string("{id}"),"id1");
lr_save_string(lr_eval_string("{name}"),"name1");
// lr_save_datetime("%D:%H:%M:%S", DATE_NOW, "time1");
lr_save_datetime("%H:%M:%S",TIME_NOW, "time1");




//插入数据
sprintf(ch1, "insert into test.name (id, name,time) values ('%s','%s','%s');",
lr_eval_string("{id1}"),
lr_eval_string("{name1}"),
    lr_eval_string("{time1}"));
//执行插入语句
lr_mysql_query(Mconn, ch1);
//查询数据
sprintf(ch2,"select id,name,time from test.name");
//执行查询语句
lr_mysql_query(Mconn, ch2);


lr_save_string(row[0][0].cell, "id2");
lr_save_string(row[1][0].cell, "name2");
lr_save_string(row[2][0].cell, "time2");


lr_output_message(lr_eval_string("id: {id2}; name: {name2}; time:{time2}"));
//修改数据
sprintf(ch3,"UPDATE test.name SET name = 'wangxin9' WHERE id = '%s';",lr_eval_string("{id}"));
lr_mysql_query(Mconn, ch3);
//杀出数据
sprintf(ch4,"delete from test.name where id='%s';",lr_eval_string("{id}"));
lr_mysql_query(Mconn, ch4);


//关闭连接
lr_mysql_disconnect(Mconn);


return 0;

}

#ifndef _GLOBALS_H
#define _GLOBALS_H


//--------------------------------------------------------------------
// Include Files
#include "lrun.h"
#include "web_api.h"
#include "lrw_custom_body.h"


//--------------------------------------------------------------------
// Global Variables


#endif // _GLOBALS_H