<%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <% /* Unlike IIS VBScript, this variable *must* be declared and initialized before calling the Footer.inc include, even if it's supposed to be empty. */ String strPageName = ""; String strQuery="SELECT NVL(RTRIM(LTRIM(MODEL)), 'NONE') AS MODEL, " + "DECODE(DESCRIPTION, 'Engine', 'ENGINE', 'CUSTOMER') " + "AS EFFTYPE,NVL(RTRIM(LTRIM(MODEL || '-' || " + "DERIVATIVE_CODE || MINOR_MODEL)), 'NONE') AS LCONFIG, " + "NVL(RTRIM(LTRIM(BLOCK_START)), 'NONE') AS FROMEFF, " + "NVL(RTRIM(LTRIM(BLOCK_END)), 'NONE') AS THRUEFF, " + "NVL(RTRIM(LTRIM(CUSTOMER_CODE)), '---') AS CUS, " + "REPLACE(NVL(RTRIM(LTRIM(DESCRIPTION)), 'NONE'), ',', " + "'') AS DESCRIPTION " + "FROM FOS2000.VW_AUTOSURPLUS_TABBLOCKS " + "WHERE ROWNUM < 20"; %> MMO Metrics Solution Development - NetCharts Testbed Project - Oracle Connection Test

Oracle Firing Order Connection Test

Below is a query from the FOS2000 systems' Firing Order View.
<% Class.forName("oracle.jdbc.driver.OracleDriver"); Connection objConn=DriverManager.getConnection("jdbc:oracle:thin:@kgv1.ca.boeing.com:1552:RP80.WORLD", "userid", "password"); Statement objStmt = objConn.createStatement(); ResultSet objRS = objStmt.executeQuery(strQuery); ResultSetMetaData objRSMeta = objRS.getMetaData(); int intColCount = objRSMeta.getColumnCount(); out.println("

"); for(int i = 1; i <= intColCount; i++) { out.println(""); } out.println(""); while(objRS.next()) { out.println(""); for(int i = 1; i <= intColCount; i++) { out.println(""); } out.println(""); } out.println("
" + objRSMeta.getColumnName(i) + "
" + objRS.getObject(i) + "
"); objRS.close(); objConn.close(); %>