?? startvote.jsp
字號:
<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
{
rs=sql.executeQuery("SELECT * FROM people WHERE name="+"'"+name+"'");
rs.next();
int count=rs.getInt("count");
count++;
String condition="UPDATE people SET count="+count+" WHERE name="+"'"+name+"'";
sql.executeUpdate(condition);
String to="INSERT INTO IP VALUES"+"("+"'"+IP+"'"+")";
sql.executeUpdate(to);
}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 + -