/*
* LoadRunner Java script. (Build: _build_number_)
*
* Script Description:
*
*/
import lrapi.lr;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Actions
{
Connection conn = null;
public int init() throws Throwable {
try {
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection("jdbc:postgresql://192.168.160.2:5432/csbsys","postgres","dragon123456");
if (conn == null) {
lr.abort();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (Exception e) {
e.printStackTrace();
}
return 0;
}//end of init
public int action() throws Throwable {
Statement st = conn.createStatement();
ResultSet rs = null;
// 场景SQL
String exsql = "select reltuples from pg_class where relname = 'm_wb_swjl';";
// String exsql = "select * from m_wb_swjl where mid = '*****' and zjhm = '******';";//MID精确查询
try {
lr.start_transaction("多个条件精确查询");
rs = st.executeQuery(exsql);
if(rs!=null){
lr.end_transaction("多个条件精确查询", lr.PASS);
}else{
lr.end_transaction("多个条件精确查询", lr.FAIL);
}
// 结果输出 while(rs.next()){ System.out.println(rs.getString(1));}
}catch (Exception e) {
e.printStackTrace();
}
rs.close();
st.close();
return 0;
}//end of action
public int end() throws Throwable {
conn.close();
return 0;
}//end of end
}