public class Database {
public static void main(String arg[]) throws Throwable
{
Database db=new Database();
db.execute();
}
public static Connection getOracleConnection() throws Exception {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "dbc:oracle:thin:@10.118.0.22:1521:DEVCENO3";
String username = "cenevo";
String password = "cenevo";
System.out.println("Connected");
Class.forName(driver); // load Oracle driver
Connection conn = DriverManager.getConnection(url, username, password);
System.out.println("Connected");
return conn;
}
public void execute() throws Exception{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int output=0;
conn = getOracleConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT DISTINCT BUSID FROM LNKBUSEXEC WHERE EXECID =8");
System.out.println(rs.getInt(0));
while (rs.next()) {
ArrayList ret=new ArrayList();
Connection conn1 = null;
Statement stmt1 = null;
ResultSet rs1 = null;
int output1=0;
conn1 = getOracleConnection();
stmt1 = conn.createStatement();
rs1 = stmt.executeQuery("SELECT AWSWSDL FROM ASPWEBSERVICE WHERE AWSIDENT = (SELECT ATSWISDENT FROM ASPTRANSACTION WHERE ATSCINT = (SELECT APACINT FROM ASPLNKPANELACTION WHERE (APACINA = (SELECT APACINA FROM LNKBUSTRAPAACT WHERE BUSID = (SELECT BUSID FROM BUSINESSSCENARIO WHERE BUSID = '"+rs.getInt(1)+"' ))) AND (APACINT = (SELECT APACINT FROM LNKBUSTRAPAACT WHERE BUSID = (SELECT BUSID FROM BUSINESSSCENARIO WHERE BUSID = '"+rs.getInt(1)+"' ))) AND (APACINP = (SELECT APACINP FROM LNKBUSTRAPAACT WHERE BUSID = (SELECT BUSID FROM BUSINESSSCENARIO WHERE BUSID = '"+rs.getInt(1)+"' )))))");
System.out.println(rs1.getString(1));
}
}
}