info.jsp

jsp做的一个在线投票系统 管理员可以对投票内容进行设置

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="dbBean.DBBean" scope="session"/>
<center>
<h2>投票结果</h2>
<table border bordercolor="#0099FF">
<tr><th bgcolor='#CCFFFF'>选项</th><th bgcolor='#CCFFFF'>得票数</th><th bgcolor='#CCFFFF'>比例</th>
  <%
	int totalNum=0;
	ResultSet rs=db.executeQuery("select sum(count) from vote");
	if(rs.next())
		totalNum=rs.getInt(1);
	rs.close();
	rs=db.executeQuery("select * from vote");
	while(rs.next()&&totalNum!=0)
	{
		out.println("<tr>");
		int num=rs.getInt("count");
		out.println("<td>"+rs.getString("item")+"</td>");
		out.println("<td>得："+num+"票  共："+totalNum+"票</td>");
		out.println("<td>得票率：");
		out.println("<img src='back.gif' width='"+num*200/totalNum+"' height='8'>");
		out.println(num*100/totalNum+"%</td>");
	}
	rs.close();
	db.close();
%>
</table>
<p><a href="index.jsp">返回投票页面</a>
</center>