?? details.jsp
字號:
<%@ page contentType="text/html;charset=ISO8859_1" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="connDbBean" scope="page" class="vote.VoteConn"/>
<%!
int tot_num=0;
int tmp_num=0;
%>
<HTML>
<HEAD>
<link rel="stylesheet" type="text/css" href="style.css">
<meta http-equiv="Expires" content="Tue, 09 Dec 1997 00:00:00 GMT">
<meta http-equiv="Pragma" content="no-cache">
</HEAD>
<BODY>
<table width="80%" border="0" cellspacing="2" cellpadding="3">
<%
// 獲取總票數
ResultSet tmpRs = connDbBean.executeQuery("select sum(c_num) As totalnum from vote");
tmpRs.next();
tot_num = tmpRs.getInt("totalnum");
tmpRs.close();
ResultSet rs = connDbBean.executeQuery("select * from vote");
int i=1;
while(rs.next()) { %>
<tr bgcolor="#99CCFF">
<td>選項<%=i%>：<%=rs.getString("note")%></td>
</tr>
<tr>
<%
tmp_num = rs.getInt("c_num");
%>
<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 + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -