<%@ page language="java" %>
<%@ page import="java.sql.*,oracle.jdbc.driver.*,java.util.*" %>

<HTML><HEAD><TITLE> Oracle / Windchill / Intralink - JSP/Oracle Query Example </TITLE></HEAD>
<BODY BGCOLOR="#FFFFFF">
<CENTER><B> Oracle / Windchill / Intralink - JSP/Oracle Query </B><BR><BR>
<%
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 + "<br><br>" );

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("<TABLE CELLSPACING=\"2\" CELLPADDING=\"5\" BORDER=\"1\">");
	
	out.println("<TR>");
	for(int j=1; j<=cols; j++) { out.print("<TD>" + rm.getColumnName(j) + "</TD>"); }
	out.println("</TR>");

	while(rs.next()){
		out.println("<TR>");
		for(int i=1; i<=cols;i++){
			out.println("<TD>" + rs.getString(i) + "</TD>");
		}
		out.println("</TR>");
	}
	out.println("</TABLE>");
}
catch(SQLException e) {
	out.println("SQLException: " + e.getMessage() + "<BR>");
	while((e = e.getNextException()) != null)
	out.println(e.getMessage() + "<BR>");
}
catch(ClassNotFoundException e){
	out.println("ClassNotFoundException: " + e.getMessage() + "<BR>");
}
finally {
	if(conn != null){
		try {
			conn.close();
		}
		catch (Exception ignored) {}
	}
}

%>
</CENTER></BODY></HTML>
