?? showresult.jsp
字號:
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%@include file="opendata.jsp"%>
<%@include file="check.jsp"%>
<%!
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 = null;
String date = null;
int questionid = 0;
sql = "SELECT Question, Date, QuestionID from questions ";
rs = smt.executeQuery(sql);
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 borderColor=#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 bordercolor="#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>
<%
sql = "SELECT ItemCount From Items Where QuestionID ="+questionid;
_rs = _smt.executeQuery(sql);
int totalcount = 0;
while(_rs.next())
{
totalcount += _rs.getInt(1);
}
if(totalcount==0)
{
out.print("暫時還沒有人參加本題投票");
sql = "SELECT Item, ItemCount FROM Items where QuestionID ="+questionid;
_rs_ = _smt_.executeQuery(sql);
String item;
int itemcount;
String percent;
while(_rs_.next())
{
item = _rs_.getString(1);
itemcount = _rs_.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+"人參加本題投票");
sql = "SELECT Item, ItemCount FROM Items where QuestionID ="+questionid;
_rs_ = _smt_.executeQuery(sql);
String item;
int itemcount;
String percent;
while(_rs_.next())
{
item = _rs_.getString(1);
itemcount = _rs_.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.gif 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 + -