📄 startvote.jsp.bak
字号:
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>
<%@page import="java.io.*" %>
<BODY bgcolor=cyan><Font size=3>
<%! int total=0;
synchronized void countTotal()
{total++;}
%>
<% boolean vote=true;
String name="";
name=request.getParameter("name");
if(name ==null) name ="?";
byte b[]=name.getBytes("ISO-8859-1");
name =new String(b);
String IP=(String)request.getRemoteAddr();
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:vote","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM IP WHERE IP="+"'"+IP+"'");
int row=0;
while(rs.next())row++;
if(row>=1)vote=false;
}catch(SQLException e1){}
if(name.equals("?"))
out.print("您没有投票，没有权利看选举结果");
else
{
if(vote)
{
out.print("您投了一票");
countTotal();
try
{
sql.executeQuery("SELECT * FROM people WHERE name="+"'"+name+"'");
rs.next();
}catch(SQLException e2){out.print(""+e2);}
try
{
rs=sql.executeQuery("SELECT * FROM people");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>" +"得票数");
out.print("<TH width=50>" +"总票数："+total);
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 b1=(count*100)/total;
out.print("<TD>"+b1+"%"+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
con.close();
}catch(SQLException e1){}
}
else
out.print("您已经投过票了！");
}
%>
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -