<% /* Page Name: strPageName variable *must* be declared and at least initialized to null before calling this page */ // QUERY STRING // ============ String strFQuery = "Select * From REF_MetricsMatrix " + "Where PageName = '" + strPageName + "'"; // CONNECTION STUFF // ================ Connection objFConn = null; String strFDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; String strFurl = "jdbc:microsoft:sqlserver://"; String strserverFName = "SQL-EVT-68"; String strFportNo = "49603"; String strFDBName = "SMMDev"; String strFuserID = "linksqlid"; String strFpwd = "linksqlpw"; String strFSelMethod = "cursor"; String strFConnUrl = strFurl + strserverFName + ":" + strFportNo + ";databaseName=" + strFDBName + ";selectMethod=" + strFSelMethod + ";"; // CONNECT // ======= try { Class.forName(strFDriver); objFConn = java.sql.DriverManager.getConnection (strFConnUrl,strFuserID,strFpwd); } catch(Exception e) { e.printStackTrace(); out.println("

Footer error: connection failed.\n " + e.getMessage() + ""); } // GET DATA // ======== Statement objFStmt1 = objFConn.createStatement(); Statement objFStmt2 = objFConn.createStatement(); ResultSet objFRS1 = null; ResultSet objFRS2 = null; try { /* I have to do it this way until I know what the scrollable cursor SelectMethod is for the Microsoft Driver. I have to instantiate *two* Statement objects, because the SQL Server 2000 for JDBC driver doesn't support Statement object pooling, so's I can use the same instance of the Statement object twice. */ objFRS1 = objFStmt1.executeQuery(strFQuery); objFRS2 = objFStmt2.executeQuery(strFQuery); } catch(Exception e) { e.printStackTrace(); out.println("

Footer error: query failed.\n " + e.getMessage() + ""); } // COUNT NUMBER OF RECORDS, DISPLAY ADDITIONAL INFO IF = 1 // ======================================================= int lngFRC = 0; while(objFRS1.next()) { lngFRC = lngFRC + 1; } objFRS1.close(); if(lngFRC > 0) { objFRS2.next(); %>
Chart Owner: "> <%=objFRS2.getObject("ChartOwnerName")%> Developer: "> <%=objFRS2.getObject("ProgrammerName")%> Source System: <%=objFRS2.getObject("SourceSystemName")%> (<%=objFRS2.getObject("SourceSystemType")%>) Data Provider: <% if(objFRS2.getInt("DataProviderBems") > 0) { out.println("" + objFRS2.getObject("DataProviderName") + ""); } else { out.println(objFRS2.getObject("DataProviderName")); } %>
<% } // End If %>
(Back to Root) <%=(new java.util.Date()).toLocaleString()%> <%=request.getRequestURL()%> Published by: Renton MMO Metrics