lr_db_connect mysql_lr_db_connect连接数据库--转

在Loadrunner中也提供了C对数据库操作的相关功能函数，以下这些数据库功能函数只能用于Web Services协议。

各函数语法如下：

lr_db_connect("StepName", "ConnectionString=",

"ConnectionName=",

"ConnectionType=", LAST);

lr_db_disconnect("StepName=",

"ConnectionName=", LAST);

lr_db_executeSQLStatement("StepName=",

"ConnectionName=", "SQLStatement=",

["DatasetName=",] LAST);

lr_db_dataset_action("StepName=",

"DatasetName=", "Action=", LAST);

lr_db_getValue("StepName=",

"DatasetName=", "Column=", "Row=",

"OutParam=", LAST);

下面以oracle数据库为例：

Action()

{

int NumRows=0;

int i=1;

//建立数据库连接

lr_db_connect("StepName=DatabaseConnection",

"ConnectionString=Provider=OraOLEDB.Oracle.1;Password = test ;Persist Security Info=True; User ID  = test ; Data Source = betadb ; Server = 172.19.188.191",

"ConnectionName=InvDatabaseConnection",

"ConnectionType=OLEDB",

LAST);

//执行SQL语句

NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",

"ConnectionName=InvDatabaseConnection",

"SQLStatement=SELECT cons_no,cons_id FROM c_cons where rownum<10",

"DatasetName=MyDataset",

LAST);

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

//打印出结果

lr_db_dataset_action("StepName=PrintDataset",

"DatasetName=MyDataset",

"Action=PRINT",

LAST);

//利用循环检索数据值

while (i<10) {

lr_db_getvalue("StepName=GetValue",

"DatasetName=MyDataset",

"Column=CONS_NO",

"Row=next",

"OutParam=MyOutputParam",

LAST);

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

i=i+1; }

//释放结果

lr_db_dataset_action("StepName=RemoveDataset",

"DatasetName=MyDataset",

"Action=REMOVE",

LAST);

//断开数据库连接

lr_db_disconnect("StepName=Disconnect",

"ConnectionName=InvDatabaseConnection",

LAST);

return 0;

}