loadrunner 测试sql server

测试工具：loadrunner    数据库：sql server 2008

/*

查询数据库方法

*/

sql()

{

int NumRows=0;

int i;

lr_db_connect("StepName=DatabaseConnection",

"ConnectionString=Data Source=127.0.0.1;Initial Catalog=waimai;Persist Security Info=True;User ID=sa;Password=123456",

"ConnectionName=MeCon",

"ConnectionType=SQL",

LAST );

//执行SQL

NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",

"ConnectionName=MeCon",

// 数据库语句

//"SQLStatement=update dbo.yun_waimaibill set billstate=1,billremark='接单成功'where orderid=371218",

 "SQLStatement=select orderid from dbo.yun_waimaibill where billstate=0",

"DatasetName=waimai",

  LAST );

 lr_output_message("The query returned %d rows.", NumRows);

//输出每一行的数据

 while(i<NumRows) { 

lr_db_getvalue("StepName=GetValue", 

   "DatasetName=waimai", 

   "Column=orderid", 

   "Row=next", 

   "OutParam=OrderId", 

   LAST); 

lr_output_message("The value is: %s", lr_eval_string("{OrderId}") ); 

i=i+1; 

   } 

//关闭链接

lr_db_disconnect("stepname=Disconnect","connectionname=MeCon",LAST);

}

/*

数据库更新方法

*/

select()

{

int NumRows=0;

int i;

lr_db_connect("StepName=DatabaseConnection",

"ConnectionString=Data Source=127.0.0.1;Initial Catalog=waimai;Persist Security Info=True;User ID=sa;Password=123456",

"ConnectionName=MeCon",

"ConnectionType=SQL",

LAST );

//执行SQL

NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",

"ConnectionName=MeCon",

// 数据库语句

"SQLStatement=update dbo.yun_waimaibill set billstate=1,billremark='接单成功'where orderid={OrderId}",

"DatasetName=waimai",

  LAST );

lr_output_message("<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<:%s",lr_eval_string("{OrderId}"));

//关闭链接

lr_db_disconnect("stepname=Disconnect","connectionname=MeCon",LAST);

}