📄 result.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>
<TABLE borderColor=#999999 cellSpacing=0 cellPadding=0 width=100% border=1>
<TBODY>
<TR bgColor=#999999>
<TD colSpan=10>
<%
int questionid = Integer.parseInt(request.getParameter("questionid"));
sql = "SELECT Question, Date from questions where QuestionID ="+questionid;
rs = smt.executeQuery(sql);
while(rs.next())
{
String question = rs.getString(1);
String date = rs.getString(2);
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("<td><img src = bar.jpg width = "+Float.parseFloat(percent)+ " height = 10>"+ percent+"%");
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 + -