<%@ page language="java" %> <%@ page import="java.sql.*,oracle.jdbc.driver.*,java.util.*" %> <% Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@"+srvrNmStg+":"+portNoStg+":"+sidNmStg,usrNmStg,passWdStg); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@LarryServer:wind:1521", "wcuser", "wcuser"); Statement stmt = con.createStatement(); String queryStr = "select DISTINCT a.CLASSNAMEKEYB4 ckey, a.TASKURLPATHINFO,a.DESCRIPTION,b.name from workitem a, wfassignedactivity b where a.status='POTENTIAL' and a.ida3a2ownership='2006' and a.ida3a4 = b.ida2a2"; ResultSet rs = stmt.executeQuery(queryStr); while(rs.next()) { <%= rs.getInt("ckey") %> <%= rs.getString("b.name")%> <%= rs.getString("a.description")%> <% } // end while() // clean up. if (rs!=null) rs.close(); if (stmt!=null) stmt.close(); if (con!=null) con.close(); %>