使用Loadrunner测试应用很多。我自己编写了一个访问mysql数据库的程序,通过这个程序来学习如何编写java语言脚本。
1、建议你在Java的开发环境下调试通过纯JAVA的测试代码。
2、然后在Runtime setting的Class path设置页面,把你的测试代码中需要的包一一加上。比如你所要测试的后台程序的包,还有所要用到的各类方法等的包。
3、最后在LR中调试运行该程序。在vugen中新建脚本,选择javavuser协议就可以了。
具体样本:
import lrapi.lr;
import java.sql.*;
import java.io.*;
public class
Actions
{
private Statement stmt = null;
private ResultSet rs = null;
private Connection conn = null;
String sql;
String strurl;
public int init() throws Throwable {
return 0;
}//end of init
public int action() throws Throwable {
//------------begin
db
class DBConfigure {
/**
*缺省的构造函数
*/
public DBConfigure() {
}
/**
*连接数据库
*/
public void OpenConn() {
try {
//驱动的名称
Class.forName("com.mysql.jdbc.Driver");
String user = "root";
String passwd = "root";
String strDBname = "test";
conn = DriverManager
.getConnection("jdbc:mysql://192.168.1.88:3306/"+strDBname+"?user="
+ user
+
"&password=" + passwd + "");//访问的数据库的帐号密码
} catch (Exception
e) {
System.out.println("OpenConnection:"
+ e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
stmt = null;
rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
System.err.println("executeQuery:"
+ e.getMessage());
}
return rs;
}
public void
executeUpdate(String sql) {
stmt = null;
try {
stmt = conn.createStatement();
stmt.executeUpdate(sql);
} catch (SQLException e) {
System.out.println("executeUpdate:"
+ e.getMessage());
}
}
public void closeStmt() {
try {
stmt.close();
} catch
(SQLException e) {
System.err.println("closeStmt:"
+ e.getMessage());
}
}
public void closeConn() {
try {
conn.close();
} catch
(SQLException ex) {
System.err.println("aq.closeConn:"
+ ex.getMessage());
}
}
//自定义类DBconfiger的结束
}
//end db
//begin test code
try {
DBConfigure db=new DBConfigure();
ResultSet rs=null;
db.OpenConn();
lr.start_transaction("selecttime");
String sql="SELECT * FROM
test.componetinfo c";
rs=db.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString("type"));
}
db.closeStmt();
} catch (Exception e) {
e.printStackTrace();
}
lr.end_transaction("selecttime",
lr.AUTO);
//end test code
return 0;
}//end of action
public int end() throws Throwable {
return 0;
}//end of end
}