📄 total.jsp

📁 这是一个个人网站台基本框架图有需要的可以下载去看看

💻 JSP

字号:

<%@ 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -