2023拉
使用lr_db_connect对数据库进行性能测试(转载)
上一篇 /
下一篇 2012-02-15 19:03:22
/ 个人分类:性能测试
我
们需要完成一个对Oracle数据库的连接,那么我们可以通过OLEDB的方式来完成,代码如下:
- int NumRows=0;
- int i;
- lr_db_connect("StepName=Connect",
- "ConnectionString=Provider=OraOLEDB.Oracle.1, Data Source=ORCL; Persist Security Info=True; User ID=cloudchen;Password=123456",
- "ConnectionName=db1",
- "ConnectionType=OLEDB",
- LAST );
- lr_start_transaction("SQL");
- NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",
- "ConnectionName=db1",
- "SQLStatement=select * from USERS",
- "DatasetName=MyDataset",
- LAST );
-
- lr_end_transaction("SQL", LR_AUTO);//获得查询记录所开销的时间
- lr_output_message("The query returned %d rows.", NumRows);
- while(i<NumRows) {
- lr_db_getvalue("StepName=GetValue",
- "DatasetName=MyDataset",
- "Column=USER_NAME",
- "Row=next",
- "OutParam=MyOutputParam",
- LAST);
- lr_output_message("The value is: %s", lr_eval_string("{MyOutputParam}") );
- i=i+1;
- }
- lr_db_disconnect("StepName=Disconnect",
- "ConnectionName=db1",
- LAST);
收藏
举报
TAG: