<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <% int sum=0; ResultSet rs_sum=connDB.executeQuery("select sum(poll) as sumpoll from tb_poll"); if (rs_sum.next()){ sum=rs_sum.getInt("sumpoll"); } ResultSet rs=connDB.executeQuery("select * from tb_poll"); String optionname=""; int poll=0; float percent=0; %>

<%rs.last(); int rowsize=rs.getRow(); rs.first(); do{ optionname=rs.getString("optionName"); poll=rs.getInt("poll"); percent=(float)poll/sum*100; //此处必需进行强制类型转换 %> <%}while(rs.next());%> <%=optionname%> <%rs.first(); do{ optionname=rs.getString("optionName"); poll=rs.getInt("poll"); percent=(float)poll/sum*100; //此处必需进行强制类型转换 %> <%} while(rs.next());%>  <%=rs.getString("optionName")%> 共有[<%=rs.getInt("poll")%>]人投票 占 <%=percent%>%