detail.jsp~23~
来自「java方面的很好的运行环境,这是一个通票系统.」· JSP~23~ 代码 · 共 95 行
JSP~23~
95 行
<%@ page contentType="text/html; charset=GBK" import="java.sql.*"%>
<%
request.setCharacterEncoding("GBK");
%>
<jsp:useBean id="oracleBean" scope="page" class="votesystem.OracleBean"/>
<html>
<%
ResultSet rs=oracleBean.query("select content,counter from vote");
ResultSet rs2=oracleBean.query("select sum(counter) from vote");
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>投票系统</title>
</head>
<body leftmargin="0" topmargin="0">
<table width="800" border="0">
<tr>
<td height="45" background="images/sprint.gif" bgcolor="#3333FF"> </td>
</tr>
<tr>
<td height="35" align="center" bgcolor="#33CCFF"><strong><font color="#000099" size="6"><em>在线投票系统</em></font></strong></td>
</tr>
<tr>
<td><table width="100%" border="0">
<tr>
<td width="12%" height="400"> </td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>投票结果:</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="40%"><font color="#0000CC">投票选项</font></td>
<td width="30%"><font color="#0000CC">票数</font></td>
<td><font color="#0000CC">投票率</font></td>
</tr>
<%
rs2.next();
int x=rs2.getInt(1);
out.print("总票数:");
out.print(x);
while(rs.next())
{
%>
<tr>
<td><%= rs.getString(1)%></td>
<td><%= rs.getInt(2)%></td>
<td><%= Math.floor(rs.getInt(2)*100/x)+"%"%></td>
</tr>
<%
}
%>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><a href="index.jsp">返回投票</a></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
<td width="12%"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="90" background="images/S-mobile-small.jpg"> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?