?? showvote.txt
字號:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<HTML>
<BODY>
<p> <font size=5> 投票情況表 </font>
<%
//加載橋接器
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{}
Connection con=null;
Statement sql=null;
ResultSet rs=null;
ResultSet rs2=null;
//顯示投票后的表中的記錄
try{
con=DriverManager.getConnection("jdbc:odbc:grade","","");
sql=con.createStatement();
rs2=sql.executeQuery("select sum(count) from candidate");
rs2.next();
int total=rs2.getInt(1);
rs=sql.executeQuery("SELECT * FROM candidate ");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"姓名"+"</th>");
out.print("<TH width=100>"+"得票數(shù)"+"</th>");
out.print("<TH width=100>"+"總票數(shù):"+total+"</th>");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
int count=rs.getInt("count");
out.print("<TD>"+count+"</TD>");
double b=(count*100)/total; //得票的百分比。
out.print("<TD>"+b+"%"+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
con.close();
}
catch(SQLException e)
{}
%>
</BODY>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -