📄 info.jsp
字号:
<%@page contentType="text/html;charset=gb2312" import="java.sql.*"%><jsp:useBean id="db" class="mybean.DBBean" scope="session"></jsp:useBean><html> <head> <title>JSP Page</title> </head> <body bgcolor="#CCFFFF"> <center> <h1>投票结果</h1> <table border="1"> <tr><th>选项</th><th>票数</th><th>比例</th> </tr> <% int totalNum=0; ResultSet rs=db.executeQuery("select sum(count) from vote"); if(rs.next()){ totalNum=rs.getInt(1); } rs.close(); rs=db.executeQuery("select * from vote"); while(rs.next()){ out.println("<tr>"); int num=rs.getInt("count"); out.println("<td>"+rs.getString("item")+"</td>"); out.println("<td>得："+num+"票 共："+totalNum+"票</td>"); out.println("<td>得票率:"); out.println("<img src=nav.jpg width='"+num*200/totalNum+"' height='8'>"); out.println(num*100/totalNum+"%</td></tr>"); } rs.close(); db.close(); %> </table> <p><a href="index.jsp">返回投票页面</a></p> </center> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -