detail.jsp~19~

来自「java方面的很好的运行环境,这是一个通票系统.」· JSP~19~ 代码 · 共 95 行

JSP~19~
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">&nbsp;</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">&nbsp;</td>
          <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>投票结果:</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td><table width="100%" border="1" cellspacing="0" cellpadding="0">
                    <tr>
                      <td width="40%">投票选项</td>
                      <td width="30%">票数</td>
                      <td>投票率</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><%= 1/2%></td>
                    </tr>

                    <%
                    }
                    %>

                  </table></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td align="center"><a href="index.jsp">返回投票</a></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
            </table></td>
          <td width="12%">&nbsp;</td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="90" background="images/S-mobile-small.jpg">&nbsp;</td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?