大家可能都知道 ODBC 协议是可以录制下来,SQL SERVER 2000 但是这个协议是底层的协议,所以好多东西是我们不想要的,也有好多东西,是我们不知道的.所以参数化,及维护脚本太难度了..由于这样的原因,所以本要用JAVA代码来写了一个测试SQL的程序.
/*
*
LoadRunner Java scrīpt. (Build: 873)
* Writer fangtiesui
* scrīpt Descrīption: sql 查询
性能测试脚本
* DATE : 2008-09-19
*/
import java.io.*;
import lrapi.lr;
import java.sql.*;
public class Actions
{
int sum = 0;
public int init() throws Throwable {
return 0;
}//end of init
public int action() throws Throwable {
try{
String sqldriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(sqldriver);
System.out.println("
数据库驱动程序注册成功!");
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school";
String user = "sa";
String password = "sa";
String sel = "select * from student where id >950";
Connection conn = DriverManager.getConnection(url,user,password);
System.out.println("数据库连接成功");
lr.start_transaction("查询学生表");
Statement sta = conn.createStatement();
ResultSet rs = sta.executeQuery(sel);
System.out.print("/t"+"id"+"/t"+"name" + "/t"+"addr"+"/t"+"tel"+"/n");
while(rs.next())
{
System.out.print("/t"+rs.getInt(1));
System.out.print("/t"+rs.getString(2));
System.out.print("/t"+rs.getString(3));
System.out.println("/t"+rs.getString(4));
sum = sum + 1 ;
}
rs.close();
sta.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
System.out.println("Test Failed");
}
lr.message("Sum = "+sum);
lr.end_transaction("查询学生表", lr.AUTO);
return 0;
}//end of action
public int end() throws Throwable {
return 0;
}//end of end
}