loadrunner之oracle性能测试脚本

上一篇 / 下一篇  2016-03-04 16:17:24 / 个人分类:loadrunner

1.OLEDB,协议webservice

lr_db_connect("StepName=aaaa", 
//connextionSring中,data source 是在oracle中配置的oracle网路服务名称,userid:用户名,passowrd:密码
"ConnectionString=Provider=OraOLEDB.Oracle.1;Data Source=TEST211; Persist Security Info=True; User ID=test; Password=test",
"ConnectionName=db1", 
"ConnectionType=OLEDB", LAST );
//此部分可以单独放到init中

lr_db_executeSQLStatement("StepName=PerformQuery", 
//connectionName与lr_db_connect中要相同
"ConnectionName=db1", 
"SQLStatement=select * from table",
 "DatasetName=ORCL",//所连接的oracle的示例名称 
    LAST ); 

2.java vuser,jdbc链接,oci8
/*
 * LoadRunner Java script. (Build: _build_number_)
 * 
 * Script. Description: 
 *                     
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.UUID;

import lrapi.lr;

public class Actions
{

private Connection conn;
public int init() throws Throwable {
     Class.forName("oracle.jdbc.driver.OracleDriver");
     //jdbc链接 classes12-10.2.0.1.0.jar//this.conn = DriverManager.getConnection("jdbc:oracle:thin:@172.16.13.228:1521:orcl", "test", "test");
//oci8链接方式ojdbc5.jar
     this.conn = DriverManager.getConnection("jdbc:oracle:oci8:@test228", "test", "test");
     return 0;
}//end of init


public int action() throws Throwable {

insert(this.conn);

return 0;
}//end of action


public int end() throws Throwable {
   conn.close();
   return 0;
}//end of end

public static void insert(Connection conn) throws SQLException{
   long begin = System.currentTimeMillis();
   PreparedStatement psmt = null;
   try{
   psmt = conn.prepareStatement("insert into t_cert (CERTSN ,subject,notbefore,notafter,ctml_name,CERTSTATUS,OLDCERTSN,ENCCERTSN, signCertEntity,encCertEntity) values (?,?,?,?,?,?,?,?,?,?)");
   psmt.setString(1, "<NO1>-<NO2>-<time>-<NO2>");
   psmt.setString(2, "subject");
   psmt.setTimestamp(3, new Timestamp(System.currentTimeMillis()));
   psmt.setTimestamp(4, new Timestamp(System.currentTimeMillis()));
   psmt.setString(5, "ctml_name");
   psmt.setString(6, "CERTSTATUS");
   psmt.setString(7, "OLDCERTSN");
   psmt.setString(8, "ENCCERTSN");
   psmt.setString(9, "signCertEntity");
   psmt.setString(10, "encCertEntity");
   psmt.executeUpdate();
   System.out.println( (System.currentTimeMillis() - begin));
   }finally{
   if(psmt != null){
   try{
   psmt.close();
   }catch(SQLException ex){

   }
   }
   }

}

}

3.ODBC
include "lrd.h"


    static LRD_INIT_INFO InitInfo = {LRD_INIT_INFO_EYECAT};  
static LRD_DEFAULT_DB_VERSION DBTypeVersion[] =  
{  
{LRD_DBTYPE_ODBC, LRD_DBVERSION_ODBC_30},  
{LRD_DBTYPE_NONE, LRD_DBVERSION_NONE}  
};  
static LRD_CONTEXT FAR * Ctx1;  
static LRD_CONNECTION FAR * Con1;  
static LRD_CURSOR FAR *     Csr1; 

unsigned long row_count=0;
vuser_init()
{



lrd_init(&InitInfo,DBTypeVersion);

lrd_open_context(&Ctx1,LRD_DBTYPE_ODBC,0,0,0);

lrd_alloc_connection(&Con1,LRD_DBTYPE_ODBC,Ctx1,0,0);

lrd_open_connection(&Con1,LRD_DBTYPE_ODBC,"","","","DRIVER=Microsoft ODBC for Oracle;Server=test228;Uid=test;Pwd=test;",Ctx1,1,0);

//lrd_open_connection(&Con1,LRD_DBTYPE_ODBC,"","","","DRIVER=Oracle in OraDb11g_home2;Server=test2282;Uid=test;Pwd=test;",Ctx1,1,0);

lrd_open_cursor(&Csr1,Con1,0);


}
#include "lrd.h"
Action()
{

    
lr_start_transaction("aa");


//lrd_stmt(Csr1,"insert into t_cert values('rrere5456445fdsfdsfdsfd','CN=TES856618673095919436C=CN',sysdate,sysdate,'default','success','2cabb715-043a-41dd-8d4a-6abed92d3068','2cabb715-043a-41dd-8d4a-6abed92d3068','MIIBczCCARegAwIBAgIISSld5b7TQwwDAYIKoEcz1UBg3UFADA','MIIBczCCARegAwIBAgIISSld5b7T')",-1,1,0,0);

lrd_stmt(Csr1,"insert into t_cert values('{NO1}-{NO2}-{time}-{NO2}','CN=TEST_-856618673095919436 C=CN',sysdate,sysdate,'default','success','2cabb715-043a-41dd-8d4a-6abed92d3068','2cabb715-043a-41dd-8d4a-6abed92d3068','MIIBczCCARegAwIBAgIISSld5b7TQ/wwDAYIKoEcz1UBg3UFADAsMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMQ8wDQYDVQQDDAZERU1PQ0EwHhcNMTYwMjI5MTE0OTE4WhcNMTYwMzAzMTE0OTE4WjAwMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMRMwEQYDVQQDDAp0ZXN0MDIyOTA1MFkwEwYHKoZIzj0CAQYIKoEcz1UBgi0DQgAECA4SOo81KDSpuCG3wE4osvH6eH8R6WaxO3+d2j6bxbH8gQz2ViW64TLMHbHkpMBdMY78LSf8qXIy0mOuB/S5bqMdMBswDAYDVR0TBAUwAwEB/zALBgNVHQ8EBAMCB4AwDAYIKoEcz1UBg3UFAANIADBFAiEAj5XssZojUro/Yjn4Gc+dtc/49TgQcmQEwDZ3M15WhgUCIACq2VtGeYKTrS6JicTvu2i1Qyp1rzzemmxT14UkoToR','MIIBczCCARegAwIBAgIISSld5b7TQ/wwDAYIKoEcz1UBg3UFADAsMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMQ8wDQYDVQQDDAZERU1PQ0EwHhcNMTYwMjI5MTE0OTE4WhcNMTYwMzAzMTE0OTE4WjAwMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMRMwEQYDVQQDDAp0ZXN0MDIyOTA1MFkwEwYHKoZIzj0CAQYIKoEcz1UBgi0DQgAECA4SOo81KDSpuCG3wE4osvH6eH8R6WaxO3+d2j6bxbH8gQz2ViW64TLMHbHkpMBdMY78LSf8qXIy0mOuB/S5bqMdMBswDAYDVR0TBAUwAwEB/zALBgNVHQ8EBAMCB4AwDAYIKoEcz1UBg3UFAANIADBFAiEAj5XssZojUro/Yjn4Gc+dtc/49TgQcmQEwDZ3M15WhgUCIACq2VtGeYKTrS6JicTvu2i1Qyp1rzzemmxT14UkoToR')",-1,1,0,0);

//lrd_stmt(Csr1,"insert into aaa values('aadfd','dfsdfs')",-1,1,0,0);
//lrd_row_count(Csr1,&row_count,0);

//lr_output_message("row_count= %d",row_count);

    
lr_end_transaction("aa", LR_AUTO);



}
#include "lrd.h"
vuser_end()
{

lrd_close_cursor(&Csr1,0);

lrd_close_connection(&Con1,0,0);

lrd_free_connection(&Con1,0,0);

lrd_close_context(&Ctx1,0,0);

}



TAG: Oracle oracle

 

评分:0

我来说两句

Open Toolbar