📄 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>"+"得票数"+"</th>");
out.print("<TH width=100>"+"总票数:"+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 + -