showresult.jsp

一个关于商业的网站

<%
/*
 *	showresult.jsp  Display the poll result .
 *	Written by Jack April 16th,2001
 *      All rights reserved by EVERSTAR COMPANY. 2001-2002.
 *  Notes:
 *       refered tables: THEMEINFO、THEMEOPINION
 *  Modified Records:
 *       $2001.04.16 Created.
 */
%>
<%@  page import="java.util.*,
                  java.sql.*,
                  java.lang.*,
                  java.* ,
                  javax.servlet.http.*"
          contentType="text/html;charset=gb2312"
%>

<jsp:useBean id="dbConn" scope="request" class="com.everstar.database.Database"/>
<jsp:include page="../header.jsp" flush="true"/>
<%  
         String sqlStr = "select THEMENO ,THEMEDETAIL from THEMEINFO where STATUS=1";  
          ResultSet rs = dbConn.select(sqlStr);
           int themeNo = 1,totalmen = 0;                
        //String[] color = {"#FF0000","#008000","#0000FF","#FFFF00"};
    String themeDetail = "";
        String showStr = "";
        String percent = "" ;                 
         
  if(rs.next())
  {
    themeNo = rs.getInt(1); 
    themeDetail = rs.getString(2); 
  }
  
  sqlStr = "select sum(SELECTCOUNT) from THEMEOPINION where THEMENO="+themeNo;
  rs = dbConn.select(sqlStr);
   if(rs.next())
  {
    totalmen = rs.getInt(1);
  }
  
  sqlStr = "select OPINTEXT,SELECTCOUNT from THEMEOPINION where THEMENO="+themeNo;
  rs = dbConn.select(sqlStr);   
  
  showStr = "<table border='1' width='100%'>";  
  if(rs.next())
  {
    if(rs.getInt(2)==0)
    {
      percent = "0%";
      showStr +="<tr><td WRAP width='35%'>"+rs.getString(1)
                +"</td><td width='50%'>0%</td><td width='15%' align=right>"
                +rs.getInt(2)+" men</td></tr>";
    }
    else
    {
      percent = (String.valueOf(((float)(rs.getInt(2))/totalmen)*100)).substring(0,4)+"%";
      showStr += "<tr><td WRAP width='35%'>"+rs.getString(1)
                 +"</td><td width='50%'><table BORDER=0 CELLSPACVING=0 CELLPADDING=0 width='100%'><tr><td  NOWRAP BGCOLOR=#FF0000 width='"
                 +percent+"'>&nbsp;</td><td NOWRAP>"+percent+"</td></tr></table></td><td width='15%' align=right>"
                 +rs.getInt(2)+" men</td></tr>";
    }        
  }  
  
  if(rs.next())
  {
    if(rs.getInt(2)==0)
    {
      percent = "0%";
      showStr +="<tr><td WRAP width='35%'>"+rs.getString(1)
                +"</td><td width='50%'>0%</td><td width='15%' align=right>"
                +rs.getInt(2)+" men</td></tr>";
    }
    else
    {
      percent = (String.valueOf(((float)(rs.getInt(2))/totalmen)*100)).substring(0,4)+"%";
      showStr += "<tr><td WRAP width='35%'>"+rs.getString(1)
                 +"</td><td width='50%'><table BORDER=0 CELLSPACVING=0 CELLPADDING=0 width='100%'><tr><td  NOWRAP BGCOLOR=#008000 width='"
                 +percent+"'>&nbsp;</td><td NOWRAP>"+percent+"</td></tr></table></td><td width='15%' align=right>"
                 +rs.getInt(2)+" men</td></tr>";
    }        
  }  
  if(rs.next())
  {
    if(rs.getInt(2)==0)
    {
      percent = "0%";
      showStr +="<tr><td WRAP width='35%'>"+rs.getString(1)
                +"</td><td width='50%'>0%</td><td width='15%' align=right>"
                +rs.getInt(2)+" men</td></tr>";
    }
    else
    {
      percent = (String.valueOf(((float)(rs.getInt(2))/totalmen)*100)).substring(0,4)+"%";
      showStr += "<tr><td WRAP width='35%'>"+rs.getString(1)
                 +"</td><td width='50%'><table BORDER=0 CELLSPACVING=0 CELLPADDING=0 width='100%'><tr><td  NOWRAP BGCOLOR=#0000FF width='"
                 +percent+"'>&nbsp;</td><td NOWRAP>"+percent+"</td></tr></table></td><td width='15%' align=right>"
                 +rs.getInt(2)+" men</td></tr>";
    }        
  }  
  if(rs.next())
  {
    if(rs.getInt(2)==0)
    {
      percent = "0%";
      showStr +="<tr><td WRAP width='35%'>"+rs.getString(1)
                +"</td><td width='50%'>0%</td><td width='15%' align=right>"
                +rs.getInt(2)+" men</td></tr>";
    }
    else
    {
      percent = (String.valueOf(((float)(rs.getInt(2))/totalmen)*100)).substring(0,4)+"%";
      showStr += "<tr><td WRAP width='35%'>"+rs.getString(1)
                 +"</td><td width='50%'><table BORDER=0 CELLSPACVING=0 CELLPADDING=0 width='100%'><tr><td  NOWRAP BGCOLOR=#FFFF00 width='"
                 +percent+"'>&nbsp;</td><td NOWRAP>"+percent+"</td></tr></table></td><td width='15%' align=right>"
                 +rs.getInt(2)+" men</td></tr>";
    }        
  }              
  showStr += "</table>";  
%>

<br><b>
<%=themeDetail%></b>
<%=showStr%>
<b>There are <%=totalmen%> men post their opinion.<b><br><br>
<jsp:include page="../footer.jsp" flush="true"/>