/*
* LoadRunner Java script. (Build: _build_number_)
*
* Script Description:
*
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.sun.org.apache.xpath.internal.operations.String;
import lrapi.lr;
public class Actions
{
public int init() throws Throwable {
Class.forName("com.mysql.jdbc.Driver");// 加载驱动程序
String url = "jdbc:mysql://10.10.10.10:36001/message";// URL指向要访问的数据库名message_old
String user = "root";// MySQL配置时的用户名
String password = "############";// MySQL配置时的密码
Connection connection = DriverManager.getConnection(url, user,password);// 连续数据库
if (!connection.isClosed()){
System.out.println("Succeeded connecting to the Database!");
}
Statement statement = connection.createStatement();// statement用来执行SQL语句
System.out.println("initial_id" + "\t" + "user_id1"+ "\t" + "user_id2");
return 0;
}//end of init
public int action() throws Throwable {
while (rs.next()) {
System.out.println(rs.getString("initi_id") + "\t"+ rs.getString("user_id1")+"\t"+rs.getString("user_id2"));
}
return 0;
}
public int end() throws Throwable {
rs.close();//关闭果集
connection.close();//数据库连接
return 0;
}//end of end
}
* LoadRunner Java script. (Build: _build_number_)
*
* Script Description:
*
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.sun.org.apache.xpath.internal.operations.String;
import lrapi.lr;
public class Actions
{
public int init() throws Throwable {
Class.forName("com.mysql.jdbc.Driver");// 加载驱动程序
String url = "jdbc:mysql://10.10.10.10:36001/message";// URL指向要访问的数据库名message_old
String user = "root";// MySQL配置时的用户名
String password = "############";// MySQL配置时的密码
Connection connection = DriverManager.getConnection(url, user,password);// 连续数据库
if (!connection.isClosed()){
System.out.println("Succeeded connecting to the Database!");
}
Statement statement = connection.createStatement();// statement用来执行SQL语句
System.out.println("initial_id" + "\t" + "user_id1"+ "\t" + "user_id2");
return 0;
}//end of init
public int action() throws Throwable {
String sql ="SELECT * from user WHERE user_id1=238 group by user_id1";
ResultSet rs = statement.executeQuery(sql);// 执行SQL语句并返回结果集while (rs.next()) {
System.out.println(rs.getString("initi_id") + "\t"+ rs.getString("user_id1")+"\t"+rs.getString("user_id2"));
}
return 0;
}
public int end() throws Throwable {
rs.close();//关闭果集
connection.close();//数据库连接
return 0;
}//end of end
}