<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%@ include file="Connections/cn.jsp" %> <% Driver DriverrsData = (Driver)Class.forName(MM_cn_DRIVER).newInstance(); Connection ConnrsData = DriverManager.getConnection(MM_cn_STRING,MM_cn_USERNAME,MM_cn_PASSWORD); PreparedStatement StatementrsData = ConnrsData.prepareStatement("SELECT game.Pr1, game.Pr2, game.Pr3, game.Pr4, winners.ID, GameID, GoldWinner, GoldPoints, SilverWinner, SilverPoints, BronzeWinner, BronzePoints, DrawWinner, DrawPoints FROM winners, game WHERE GameID = game.ID ORDER BY winners.ID Desc",ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); StatementrsData.setFetchSize(1); StatementrsData.setQueryTimeout(0); ResultSet rsData = StatementrsData.executeQuery(); boolean rsData_isEmpty = !rsData.next(); boolean rsData_hasData = !rsData_isEmpty; Object rsData_data; int rsData_numRows = 0; %> <% String t; int i; int ii; String Prize1=(((t = rsData.getString("Pr1"))==null || rsData.wasNull())?"":t); String Prize2=(((t = rsData.getString("Pr2"))==null || rsData.wasNull())?"":t); String Prize3=(((t = rsData.getString("Pr3"))==null || rsData.wasNull())?"":t); String Prize4=(((t = rsData.getString("Pr4"))==null || rsData.wasNull())?"":t); String WinnerName1 = "Nobody"; String WinnerName2 = "Nobody"; String WinnerName3 = "Nobody"; String WinnerName4 = "Nobody"; String WinnerPoints1 = ""; String WinnerPoints2 = ""; String WinnerPoints3 = ""; String WinnerPoints4 = ""; int Winner1= rsData.getInt("GoldWinner"); if (Winner1 != -1) { PreparedStatement Winner1Data = ConnrsData.prepareStatement("SELECT FName, LName from account where ID = " + Winner1,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); Winner1Data.setFetchSize(1); Winner1Data.setQueryTimeout(0); ResultSet rsData1 = Winner1Data.executeQuery(); rsData1.next(); try { WinnerPoints1 = ""+rsData.getInt("GoldPoints"); } catch (NumberFormatException e1) { WinnerPoints1 = ""; } try { WinnerName1 = (((t = rsData1.getString("FName"))==null || rsData1.wasNull())?"":t) + " " + (((t = rsData1.getString("LName"))==null || rsData1.wasNull())?"":t); } catch (Exception e11) { } } int Winner2=rsData.getInt("SilverWinner"); if (Winner2 != -1) { PreparedStatement Winner2Data = ConnrsData.prepareStatement("SELECT FName, LName from account where ID = " + Winner2,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); Winner2Data.setFetchSize(1); Winner2Data.setQueryTimeout(0); ResultSet rsData2 = Winner2Data.executeQuery(); rsData2.next(); try { ii = rsData.getInt("SilverPoints"); WinnerPoints2 = "" + ii; } catch (NumberFormatException e2) { WinnerPoints2 = ""; } try{ WinnerName2 = (((t = rsData2.getString("FName"))==null || rsData2.wasNull())?"":t) + " " + (((t = rsData2.getString("LName"))==null || rsData2.wasNull())?"":t); } catch (Exception e21) { } } int Winner3=rsData.getInt("BronzeWinner"); if (Winner3 != -1) { PreparedStatement Winner3Data = ConnrsData.prepareStatement("SELECT FName, LName from account where ID = " + Winner3,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); Winner3Data.setFetchSize(1); Winner3Data.setQueryTimeout(0); ResultSet rsData3 = Winner3Data.executeQuery(); rsData3.next(); try { ii = rsData.getInt("BronzePoints"); WinnerPoints3 = "" + ii; } catch (NumberFormatException e3) { WinnerPoints3 = ""; } try{ WinnerName3 = (((t = rsData3.getString("FName"))==null || rsData3.wasNull())?"":t) + " " + (((t = rsData3.getString("LName"))==null || rsData3.wasNull())?"":t); } catch (Exception e31){ } } int Winner4=rsData.getInt("DrawWinner"); if (Winner4 != -1) { PreparedStatement Winner4Data = ConnrsData.prepareStatement("SELECT FName, LName from account where ID = " + Winner4); ResultSet rsData4 = Winner4Data.executeQuery(); rsData4.next(); try { ii = rsData.getInt("DrawPoints"); WinnerPoints4 = "" + ii; } catch (NumberFormatException e4) { WinnerPoints4 = ""; } try{ WinnerName4 = (((t = rsData4.getString("FName"))==null || rsData4.wasNull())?"":t) + " " + (((t = rsData4.getString("LName"))==null || rsData4.wasNull())?"":t); } catch (Exception e41){ } } %>

	<%=WinnerName1%> Epoints : <%=WinnerPoints1%> <%=Prize1%> <%=WinnerName4%> Epoints : <%=WinnerPoints4%> <%=Prize4%>     <%=WinnerName2%> Epoints : <%=WinnerPoints2%> <%=Prize2%>       <%=WinnerName3%> Epoints : <%=WinnerPoints3%> <%=Prize3%>             March 17, 2003   There was no Gold Level Champion for this game. Draw Prize Champion: Sean Faulkner     There was no Silver Level Champion for this game.       Bronze Level Champion: Gladys Wong

<% rsData.close(); ConnrsData.close(); %>