<%@ page language="java" %> <%@ page import="java.sql.*,oracle.jdbc.driver.*,java.util.*" %> Oracle / Windchill / Intralink - JSP/Oracle Query

<% String srvrNmStg = (request.getParameter("srvrNm")); String portNoStg = (request.getParameter("portNo")); String sidNmStg = (request.getParameter("sidNm")); String usrNmStg = (request.getParameter("usrNm")); String passWdStg = (request.getParameter("passWd")); String sqlQueryStg = (request.getParameter("sqlQuery")); out.println( sqlQueryStg + "

" ); Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@"+srvrNmStg+":"+portNoStg+":"+sidNmStg,usrNmStg,passWdStg); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sqlQueryStg); ResultSetMetaData rm = rs.getMetaData(); int cols = rm.getColumnCount(); out.println(""); out.println(""); for(int j=1; j<=cols; j++) { out.print(""); } out.println(""); while(rs.next()){ out.println(""); for(int i=1; i<=cols;i++){ out.println(""); } out.println(""); } out.println("

" + rm.getColumnName(j) + "

" + rs.getString(i) + "

"); } catch(SQLException e) { out.println("SQLException: " + e.getMessage() + "
"); while((e = e.getNextException()) != null) out.println(e.getMessage() + "
"); } catch(ClassNotFoundException e){ out.println("ClassNotFoundException: " + e.getMessage() + "
"); } finally { if(conn != null){ try { conn.close(); } catch (Exception ignored) {} } } %>