Loadrunner 如何访问数据库
来源:互联网 发布:java压力测试代码 编辑:程序博客网 时间:2024/06/05 02:09
在Loadrunner中也提供了C对数据库操作的相关功能函数,以下这些数据库功能函数只能用于Web Services协议。
lr_db_connect
连接数据库
lr_db_disconnect
断开数据库的连接
lr_db_executeSQLStatement
执行SQL语句
lr_db_dataset_action
对数据库执行操作
lr_db_getValue
从数据集中检索值
各函数语法如下:
lr_db_connect("StepName", "ConnectionString=<connection_string>", "ConnectionName=<connection_name>", "ConnectionType=<connection_type>", LAST);
lr_db_disconnect("StepName=<step_name>", "ConnectionName=<connection_name>", LAST);
lr_db_executeSQLStatement("StepName=<step_name>", "ConnectionName=<connection_name>", "SQLStatement=<statement>", ["DatasetName=<dataset_name>",] LAST);
lr_db_dataset_action("StepName=<step_name>", "DatasetName=<dataset_name>", "Action=<action>", LAST);
lr_db_getValue("StepName=<step_name>", "DatasetName=<dataset_name>", "Column=<column>", "Row=<row>", "OutParam=<output_parm>", 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;
}
运行后,输出信息如下:
Virtual User Script started
Starting action vuser_init.
Ending action vuser_init.
Running Vuser...
Starting iteration 1.
Starting action Action.
Action.c(6): DB Connection "DatabaseConnection" started ... Wait ....
Action.c(6): DB connection was successful
Action.c(13): SQL Statement execution "PerformQuery" started
Action.c(13): SQL Statement execution was successful
Action.c(13): ================================================
Action.c(18): The query returned 9 rows.
Action.c(20): Dataset action "PrintDataset" started
Action.c(20):
Action.c(20): ******** Start printing ***********
Action.c(20): Number of records in dataset = 9
Action.c(20): Num. CONS_NO CONS_ID
Action.c(20): =========================================================
Action.c(20): 1 3096451321 310306247
Action.c(20): 2 3097730300 3376536
Action.c(20): 3 0000265443 3376537
Action.c(20): 4 0000265456 3376538
Action.c(20): 5 0000265469 3376539
Action.c(20): 6 0000265472 3376540
Action.c(20): 7 3098976354 314348099
Action.c(20): 8 0000265498 3376542
Action.c(20): 9 0000265502 3376543
Action.c(20): ********End printing ***********
Action.c(20):
Action.c(20): Dataset action was successful
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 3096451321
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 3097730300
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 0000265443
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 0000265456
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 0000265469
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 0000265472
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 3098976354
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 0000265498
Action.c(27): Get db value "GetValue" started
Action.c(27): Get db value was successful
Action.c(27): ================================================
Action.c(33): The value is: 0000265502
Action.c(36): Dataset action "RemoveDataset" started
Action.c(36): Dataset action was successful
Action.c(41): DB disconnect "Disconnect" started
Action.c(41): DB disconnect was successful
Action.c(41): ================================================
Ending action Action.
Ending iteration 1.
Ending Vuser...
Starting action vuser_end.
Ending action vuser_end.
Vuser Terminated.
- Loadrunner 如何访问数据库
- LoadRunner访问 Mysql数据库
- LoadRunner访问Mysql数据库
- LoadRunner中访问mysql数据库
- 如何在LoadRunner中监控Oracle数据库
- 如何在LoadRunner中监控oracle数据库
- 如何在LoadRunner中监控Oracle数据库
- java如何访问数据库
- JDBC如何访问数据库
- Servelet 如何访问数据库
- LoadRunner动态访问Oracle数据库+多协议录制解决方案[转载]
- 如何解决LoadRunner监控Windows资源拒绝访问的错误
- 如何在LoadRunner中监控oracle数据库-Zee
- 【转】如何在LoadRunner中监控oracle数据库
- 如何在LoadRunner中监控oracle数据库(四)
- loadrunner如何测试sqlserver数据库性能思路分享
- 如何限定IP访问数据库
- DotNet如何访问mySQL数据库
- 使用UC浏览器调试手机网页
- NSDate (nsdate) 时间 (time )比较
- LeetCode Anagrams
- 基本一
- VC 修改IE代理服务器
- Loadrunner 如何访问数据库
- 基于libevent的http server
- 泛型
- 极大似然估计的相关治疗
- linux中atime mtime ctime
- template class
- Struts1.X 和 Struts2.X中文乱码解决方法
- 快速把web项目部署到weblogic上
- C++程序设计 模板