如何利用LoadRunner最高效的批量制造MySQL数据 - 51Testing软件测试论坛

<font size="4">/*
* LoadRunner Java script. (Build: _build_number_)
*
* Script Description:
*
*/
import lrapi.lr;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Actions
{
private Connection conn = null;
PreparedStatement statement = null;
// connect to MySQL
void connSQL() {
String url = "jdbc:mysql://172.16.1.67:3306/test?characterEncoding=UTF-8";
String username = "root";
String password = "123456"; // 加载驱动程序以连接数据库
try {
Class.forName("com.mysql.jdbc.Driver" );
conn = DriverManager.getConnection( url,username, password );
}
//捕获加载驱动程序异常
catch ( ClassNotFoundException cnfex ) {
System.err.println(
"装载 JDBC/ODBC 驱动程序失败。" );
cnfex.printStackTrace();
}
//捕获连接数据库异常
catch ( SQLException sqlex ) {
System.err.println( "无法连接数据库" );
sqlex.printStackTrace();
}
}
// disconnect to MySQL
void deconnSQL() {
try {
if (conn != null)
conn.close();
} catch (Exception e) {
System.out.println("关闭数据库问题：");
e.printStackTrace();
}
}
public int init() throws Throwable {
connSQL();
return 0;
}//end of init
public int action() throws Throwable {
String sql = "insert into MySqlTest(ID, DataName, InsertTime, UpdateTime, DataType,DataSet) values(REPLACE(uuid(), '-', ''),?,now(),null,1,'LoadRunner')";
conn.setAutoCommit(false);
statement = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
lr.start_transaction("Insert");
for(int i=0;i<1000;i++){//每1000条记录为一组事务，每个虚拟用户至少执行一组批量插入事务
statement.setString(1,"Test-A2B-<RadParam>");//用LoadRunner的方式设置随机数参数
statement.addBatch();
}
statement.executeBatch();
conn.commit();
lr.end_transaction("Insert", lr.AUTO);
return 0;
}//end of action
public int end() throws Throwable {
deconnSQL();
return 0;
}//end of end
} </font>

复制代码

<font size="4">public int init() throws Throwable {
connSQL();
String sql = "insert into MySqlTest(ID, DataName, InsertTime, UpdateTime, DataType,DataSet) values(REPLACE(uuid(), '-', ''),?,now(),null,1,'LoadRunner')";
conn.setAutoCommit(false);
statement = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
return 0;
}//end of init
public int action() throws Throwable {
lr.start_transaction("action");
statement.setString(1,"Test-A2B-<RadParam>");
statement.addBatch();
lr.end_transaction("action", lr.AUTO);
return 0;
}//end of action
public int end() throws Throwable {
statement.executeBatch();
conn.commit();
deconnSQL();
return 0;
}//end of end </font>

复制代码