view.jsp
来自「该源码为JSP的开发案例集锦」· JSP 代码 · 共 43 行
JSP
43 行
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="vote" scope="page" class="ch9.VoteConn"/>
<%!
int tot_num=0;
int tmp_num=0;
%>
<HTML>
<HEAD>
<link rel="stylesheet" type="text/css" href="style.css">
</HEAD>
<BODY>
<table width="90%" border="0" cellspacing="2" cellpadding="3">
<%
// 获取总票数
ResultSet tmpRs = vote.executeQuery("select sum(numb) As totalnum from vote");
tmpRs.next();
tot_num = tmpRs.getInt("totalnum");
tmpRs.close();
ResultSet rs = vote.executeQuery("select * from vote");
int i=1;
while(rs.next()) { %>
<tr bgcolor="#99CCFF">
<td>选项<%=i%>:<%=rs.getString("content")%></td>
</tr>
<tr>
<%
tmp_num = rs.getInt("numb");
%>
<td>投票率:<img src="back.gif" width="<%=Math.floor(tmp_num*200/tot_num)%>" height="8"> <%=Math.floor(tmp_num*100/tot_num)%>%
[得:<%=tmp_num%>票 共:<%=tot_num%>票]</td>
</tr>
<%
i++;
}
%>
</table>
<%
rs.close();
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?