📄 showresult.jsp

📁 这个主要是运用JAVA+JAVABEAN实现的网上投票调查系统
💻 JSP
字号:
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%!
 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>
<jsp:useBean id="MyBean" scope="session" class="myjsp.MyBean"/>
<jsp:setProperty name="MyBean" property="*"/>

<% Connection con = MyBean.getConnection(); 
  Statement smt = con.createStatement();
  ResultSet rs= null;
  %>
<%
 String question = null;
 String datetime = null;
 String sql =null;
 int questionid = 0;
 try{
 sql = "SELECT Question, Date1, QuestionID from Questions where IsVisable = 1 and IsOpen= 1";
 rs = smt.executeQuery(sql);
 }catch(Exception e){
  out.println(e.getMessage());
  }
 Statement _smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
 ResultSet _rs;
 Statement _smt_=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
 ResultSet _rs_;
try{
 while(rs.next())
 {%>
      <TABLE borderColor=#999999 cellSpacing=0 cellPadding=0 width=100% border=1>
      <TBODY>
      <TR bgColor=#999999>
        <TD colSpan=10>
<%

  question = rs.getString("Question");
  datetime = rs.getString("Date1");
  questionid = rs.getInt("QuestionID");
  out.print("<p align=center>"+datetime+"发布</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("</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.jpg width = "+Float.parseFloat(percent)*2+ " height = 10>"+ percent+"%");
	//<td><img src = "BAR.jpg" width = "+Float.parseFloat(percent)*2+ " height = 10>"+ percent+"%";
    out.print("</tr>");
   }
  }
%>
<%  
  smt.close(); //关闭Statement对象
  MyBean.close();  //关闭Connection对象	
%>
</table>
</table>
<p>
<%}
  }catch(Exception e){out.println(e.getMessage());}
%>
<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 + -