⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 showresult.jsp~2~

📁 JSP 在线投票系统.附加数据库。附加D: omcat5.0webappschap17目录下的questionnaire_Data.MDF数据库文件。 运行。启动Tomcat
💻 JSP~2~
字号:
🔍 
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="sqltest" class="database.opendata" scope="page">
</jsp:useBean>
<%!
 String printf(String str)  //转换百分比格式
 {
  int index=0;
  if((index=str.indexOf(".")) != -1)
   str = str.substring(0,index) +"."+ str.substring(index+1,index+3);
  return(str);
 }
%>

<html>
<head>
<title>查看结果</title>
<LINK href="style.css" rel=stylesheet>
</head>
<body>

<%
 String question,date,Sqlstring;
 ResultSet rs=null;
 ResultSet rs1=null;
 ResultSet rs2=null;

 int questionid = 0;
 Sqlstring = "SELECT Question, Date, QuestionID from questions where IsVisable = 1 and IsOpen= 1";
 rs=sqltest.executeQuery(Sqlstring);
 /*
 Statement _smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
 ResultSet _rs;
 Statement _smt_=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
 ResultSet _rs_;
*/
 while(rs.next())
 {%>
      <TABLE bgcolor=#999999 cellSpacing=0 cellPadding=0 width=100% border=1>
      <TBODY>
      <TR bgColor=#999999>
        <TD colSpan=10>
<%

  question = rs.getString(1);
  date = rs.getString(2);
  questionid = rs.getInt(3);
  out.print("<p align=center>"+date+"发布</td></tr>");
  out.print("<TR bgColor=#999999><TD colSpan=10>"+question+"</td></tr>");
%>
  <TABLE cellSpacing=0 cellPadding=0 width=100% align=center border=1 bgcolor="#999999">
            <TBODY>
            <TR>

            <TD width="45%">
              <div align="center">选项</div>
                </TD>

            <TD width="4%">
              <div align="center">记数</div>
            </TD>

            <TD width="51%">
              <div align="center">图示</div>
            </TD>
            </TR>
<%
  Sqlstring = "SELECT ItemCount From Items Where QuestionID ="+questionid;
  rs1 = sqltest.executeQuery(Sqlstring);
  int totalcount = 0;
  while(rs1.next())
  {
   totalcount += rs1.getInt(1);
  }
  if(totalcount==0)
  {
   out.print("暂时还没有人参加本题投票");
   Sqlstring = "SELECT Item, ItemCount FROM Items where QuestionID ="+questionid;
   rs2 = sqltest.executeQuery(Sqlstring);
   String item;
   int itemcount;
   String percent;
   while(rs2.next())
   {
    item = rs2.getString(1);
    itemcount = rs2.getInt(2);
    percent = printf(String.valueOf((double)itemcount/totalcount*100)+"0");
    out.print("<tr><td>"+item+"</td>");
    out.print("<td align=center>"+itemcount+"</td>");
    out.print("</tr>");
   }
  }
  else
  {
   out.print("共有"+totalcount+"人参加本题投票");
   Sqlstring = "SELECT Item, ItemCount FROM Items where QuestionID ="+questionid;
   rs2 = sqltest.executeQuery(Sqlstring);
   String item;
   int itemcount;
   String percent;
   while(rs2.next())
   {
    item = rs2.getString(1);
    itemcount = rs2.getInt(2);
    percent = printf(String.valueOf((double)itemcount/totalcount*100)+"0");
    out.print("<tr><td>"+item+"</td>");
    out.print("<td align=center>"+itemcount+"</td>");
    out.print("<td><img src = bar.jpg width = "+Float.parseFloat(percent)*2+ " height = 10>"+ percent+"%");
    out.print("</tr>");
   }
  }

%>
</table>
</table>
<p>
<%}%>
<p>
<hr>
<p>
<div align="center"><a href="Javascript:window.close();">关闭窗口</a></div>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -