loadrunner連接配接mysql_Loadrunner連接配接Mysql資料庫

#define MYSQLSERVER "192.168.1.106"

#define MYSQLUSERNAME "root"

#define MYSQLPASSWORD "123456"

#define MYSQLDB "test"

#define MYSQLPORT "3306"

#include "Ptt_Mysql.h"

vuser_init()

{

return 0;

}

3.Action

Action()

{

char sqQuery[512]; //定義一個字元數組存儲查詢的sql語句

int i;

MYSQL *Mconn; //mysql連接配接字元串

lr_load_dll("libmysql.dll");

Mconn = lr_mysql_connect(MYSQLSERVER, MYSQLUSERNAME, MYSQLPASSWORD, MYSQLDB, atoi(MYSQLPORT));//建立連接配接

sprintf(sqQuery, "SELECT * FROM test1; ");//查詢test1表資料

lr_mysql_query(Mconn, sqQuery);//執行sql語句

sprintf(sqQuery,"INSERT INTO test1 VALUES(2,‘bb‘,‘222222‘);");//插入資料

lr_mysql_query(Mconn, sqQuery);

sprintf(sqQuery,"UPDATE test1 SET uname=‘aaa‘ WHERE id=1; ");//更改使用者名aa為aaa

lr_mysql_query(Mconn, sqQuery);

sprintf(sqQuery,"DELETE FROM test1 WHERE id=1;");//删除

lr_mysql_query(Mconn, sqQuery);

//斷開資料庫連接配接

lr_mysql_disconnect(Mconn);

return 0;

}

4.Vuser_end

vuser_end()

{

return 0;

}