total.jsp

来自「这是一个个人网站台基本框架图 有需要的可以下载去看看」· JSP 代码 · 共 70 行

JSP
70
字号
<%@ page import="java.util.*, java.sql.*"	contentType="text/html;charset=GB2312" %>
<HTML>
<BODY  bgcolor="#00FFFF">
<jsp:useBean id="pool" scope="application" class="chapter10.ConnPool"/>
<div align="center">
  <p>&nbsp;  </p>
  <p>&nbsp;</p>
  <p>
    <%@ include file="conn.jsp"%>  
<%
 String but=new String(request.getParameter("result"));
 sql="update Total set "+but+"="+but+"+1" ;
 statement.executeUpdate(sql) ;
 sql="update Total set Num=Num+1" ;
 statement.executeUpdate(sql) ;
 float a,b,c,d;
 int all;
 
 sql="select Best from Total" ;
 ResultSet rs=statement.executeQuery(sql) ;
 rs.next();
 a=rs.getInt(1);
 
 sql="select Better from Total" ;
 rs=statement.executeQuery(sql) ;
 rs.next();
 b=rs.getInt(1);
 
 sql="select Good from Total" ;
 rs=statement.executeQuery(sql) ;
 rs.next();
 c=rs.getInt(1);
 
 sql="select Soso from Total" ;
 rs=statement.executeQuery(sql) ;
 rs.next();
 d=rs.getInt(1);
 
 sql="select Num from Total" ;
 rs=statement.executeQuery(sql) ;
 rs.next();
 all=rs.getInt(1);
 
 a = a/all*100 ;
 b = b/all*100 ;
 c = c/all*100 ;
 d = d/all*100 ;
 
%>
    
   
    历史总投票数&nbsp;&nbsp;<%=all%><br>
    <br>
    <br>
    觉得本网页做的很好&nbsp;&nbsp;<%=a%>%<br>
    <br>
    觉得本网页做的较好&nbsp;&nbsp;<%=b%>%<br>
    <br>
    觉得本网页做的一般&nbsp;&nbsp;<%=c%>%<br>
    <br>
    觉得本网页做的很差&nbsp;&nbsp;<%=d%>%<br>
    <br>
   
    <%@ include file="disconn.jsp"%>
         </p>
  <p ><a href="total.htm">返回</a></p>
</div>
</body>
</html>

⌨️ 快捷键说明

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