import java.sql.*;
import lrapi.lr;
public class Actions {
public int init() throws Throwable {
return 0;
}// end of init
public int action() throws Throwable {
// Class.forName("com.mysql.jdbc.Driver");// 加载驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");// 加载驱动程序
// String url = "jdbc:mysql://10.10.10.10:36001/message";// URL指向要访问的数据库名message_old
// String url = "jdbc:oracle:thin:@1.1.1.1:1521:emarrac.emar";// URL指向要访问的数据库名message_old
String url = "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL =TCP)(HOST = 11.116.1.1)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = emarrac.emar)))";// URL指向要访问的数据库名message_old
String user = "aaaaaa";// MySQL配置时的用户名
String password = "aaaaaa";// MySQL配置时的密码
Connection connection = DriverManager
.getConnection(url, user, password);// 连续数据库
if (!connection.isClosed()) {
System.out.println("成功链接!");
}
Statement statement = connection.createStatement();// statement用来执行SQL语句
// System.out
// .println("initial_id" + "\t" + "user_id1" + "\t" + "user_id2");
// String sql = "SELECT * "
// + "FROM (SELECT /*+leading(score reg) use_nl(score reg)*/"+
// "score.PRIZE_NAME ,"+
// "reg.NICK_NAME"+
// " FROM (select USER_ID,PRIZE_NAME from SCORE_EXCHANGE_LOG ORDER BY CREATE_TIME DESC) score,"+ "REG_USER reg"+
// " WHERE score.USER_ID = reg.ID"+") WHERE rownum <= 3";
// String sql = "SELECT * "
// + "FROM (SELECT score.PRIZE_NAME , reg.NICK_NAME FROM yiqifa_bs_pro.SCORE_EXCHANGE_LOG score,"
// + "yiqifa_bs_pro.REG_USER reg WHERE score.USER_ID = reg.ID"
// + " ORDER BY score.CREATE_TIME DESC) WHERE rownum <= 3";
String sql = "SELECT * "
+ " FROM (SELECT/*+use_nl(score reg)*/ score.PRIZE_NAME, reg.NICK_NAME"
+ " FROM yiqifa_bs_pro.SCORE_EXCHANGE_LOG score,"
+ " yiqifa_bs_pro.REG_USER reg"
+ " WHERE score.USER_ID = reg.ID"
+ " ORDER BY score.CREATE_TIME DESC)" + " WHERE rownum <= 3";
lr.rendezvous("Start");
lr.start_transaction("Searcher");
ResultSet rs = statement.executeQuery(sql);// 执行SQL语句并返回结果集
lr.end_transaction("Searcher", lr.AUTO);
lr.think_time(1/1000);
System.out.println(sql);
// while (rs.next()) {
//
// System.out.println(rs.getString("initi_id") + "\t"
// + rs.getString("user_id1") + "\t"
// + rs.getString("user_id2"));
rs.close();// 关闭果集
connection.close();// 数据库连接
return 0;
}
public int end() throws Throwable {
return 0;
}// end of end
public static void main(String[] args) {
Actions actions=new Actions();
try {
actions.action();
} catch (Throwable e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import lrapi.lr;
public class Actions {
public int init() throws Throwable {
return 0;
}// end of init
public int action() throws Throwable {
// Class.forName("com.mysql.jdbc.Driver");// 加载驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");// 加载驱动程序
// String url = "jdbc:mysql://10.10.10.10:36001/message";// URL指向要访问的数据库名message_old
// String url = "jdbc:oracle:thin:@1.1.1.1:1521:emarrac.emar";// URL指向要访问的数据库名message_old
String url = "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL =TCP)(HOST = 11.116.1.1)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = emarrac.emar)))";// URL指向要访问的数据库名message_old
String user = "aaaaaa";// MySQL配置时的用户名
String password = "aaaaaa";// MySQL配置时的密码
Connection connection = DriverManager
.getConnection(url, user, password);// 连续数据库
if (!connection.isClosed()) {
System.out.println("成功链接!");
}
Statement statement = connection.createStatement();// statement用来执行SQL语句
// System.out
// .println("initial_id" + "\t" + "user_id1" + "\t" + "user_id2");
// String sql = "SELECT * "
// + "FROM (SELECT /*+leading(score reg) use_nl(score reg)*/"+
// "score.PRIZE_NAME ,"+
// "reg.NICK_NAME"+
// " FROM (select USER_ID,PRIZE_NAME from SCORE_EXCHANGE_LOG ORDER BY CREATE_TIME DESC) score,"+ "REG_USER reg"+
// " WHERE score.USER_ID = reg.ID"+") WHERE rownum <= 3";
// String sql = "SELECT * "
// + "FROM (SELECT score.PRIZE_NAME , reg.NICK_NAME FROM yiqifa_bs_pro.SCORE_EXCHANGE_LOG score,"
// + "yiqifa_bs_pro.REG_USER reg WHERE score.USER_ID = reg.ID"
// + " ORDER BY score.CREATE_TIME DESC) WHERE rownum <= 3";
String sql = "SELECT * "
+ " FROM (SELECT/*+use_nl(score reg)*/ score.PRIZE_NAME, reg.NICK_NAME"
+ " FROM yiqifa_bs_pro.SCORE_EXCHANGE_LOG score,"
+ " yiqifa_bs_pro.REG_USER reg"
+ " WHERE score.USER_ID = reg.ID"
+ " ORDER BY score.CREATE_TIME DESC)" + " WHERE rownum <= 3";
lr.rendezvous("Start");
lr.start_transaction("Searcher");
ResultSet rs = statement.executeQuery(sql);// 执行SQL语句并返回结果集
lr.end_transaction("Searcher", lr.AUTO);
lr.think_time(1/1000);
System.out.println(sql);
// while (rs.next()) {
//
// System.out.println(rs.getString("initi_id") + "\t"
// + rs.getString("user_id1") + "\t"
// + rs.getString("user_id2"));
rs.close();// 关闭果集
connection.close();// 数据库连接
return 0;
}
public int end() throws Throwable {
return 0;
}// end of end
public static void main(String[] args) {
Actions actions=new Actions();
try {
actions.action();
} catch (Throwable e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}