📄 vote.jsp
字号:
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>
<%@page import="java.io.*" %>
<BODY bgcolor=cyan><Font size=6>
<%! int total=0;
synchronized void countTotal()
{total++;}
%>
<%
String id=request.getParameter("name");
if(id==null) id="?";
byte b[]=id.getBytes("ISO-8859-1");
id=new String(b);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try
{
con=DriverManager.getConnection("jdbc:odbc:shuiguo","","");
sql=con.createStatement();
}catch(SQLException e1){out.print("error");}
if(id.equals("?"))out.print("您没有投票");
else
{
try
{ countTotal();
rs=sql.executeQuery("SELECT * FROM form WHERE id="+"'"+id+"'");
rs.next();
int count=rs.getInt("count");
count++;
String condition="UPDATE form SET count="+count+" WHERE id="+"'"+id+"'";
sql.executeUpdate(condition);
}catch(SQLException e1){out.print(""+e1);}
try
{ rs=sql.executeQuery("SELECT * FROM form");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"<FONT size=6>"+"名称");
out.print("<TH width=150>"+"<FONT size=6>"+"得票数");
out.print("<TH width=150>"+"<FONT size=6>"+"总票数："+total);
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+"<FONT size=6>"+rs.getString(2)+"</TD>");
int count1=rs.getInt("count");
out.print("<TD>"+"<FONT size=6>"+count1+"</TD>");
double b1=(count1*100)/total;
out.print("<TD>"+"<FONT size=6>"+b1+"%"+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
con.close();
}catch(SQLException e1){out.print("error2");}
}
%>
<BR><A href="exer4.jsp">返回</A>
</FONT>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -