一个基于Access数据库的网上投票系统。
1. beforevote.jsp
<%@ page contentType="text/html;charset=utf-8" %>
<%@ page import="java.sql.*" %>
<%
//JDBC连接数据库有两种方式: JDBC-ODBC桥接器方式和特定数据库的专用JDBC连接方式。
//本案采用JDBC-ODBC桥接器方式。
// ODBC数据源名为: voteDSN
// 表candidates ---- 存放候选人的名字:name和得票数:count
// 表voters ---- 存放投票人的IP: voterIP
//投票之前,要把候选人的名字和初始得票数填入candidates表中。
%>
<html>
<body>
<%
StringBuffer candidatesList = new StringBuffer();
Connection con;
Statement sql;
ResultSet rs;
//加载ODBC-JDBC驱动
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
//连接数据库并读出candidates表的内容
try{
con = DriverManager.getConnection("jdbc:odbc:vote", "", "");
//con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.3:1521:kwdb", "okjohn", "password"); //专用JDBC方式
sql = con.createStatement();
rs = sql.executeQuery("SELECT * FROM candidates");
candidatesList.append("<FORM action=execvote.jsp method=post>");
candidatesList.append("<TABLE border>");
candidatesList.append("<TR>");
candidatesList.append("<TD width=100>" + "姓名");
candidatesList.append("<TD width=70>" + "投票选择");
candidatesList.append("<TR>");
while(rs.next()){
candidatesList.append("<TR>");
String name = rs.getString("name");
candidatesList.append("<TD>" + name + "</TD>");
candidatesList.append("<TD> <INPUT type=radio name=selection value=" + name + "> </TD>");
candidatesList.append("</TR>");
}
candidatesList.append("</TABLE>");
candidatesList.append("<INPUT type=submit value='提交'>");
candidatesList.append("</FORM>");
con.close();
out.print(candidatesList);
}
catch(SQLException ex){
ex.printStackTrace();
}
%>
</body>
</html>
2. execvote.jsp
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<html>
<body>
<%!
//记录总票数的变量
int total=0;
synchronized void countTotal(){
total ++;
}
%>
<%
boolean alowVote = true;
//得到候选人的名字
String candidate = request.getParameter("selection");
if( candidate == null){
candidate = "?";
}
byte[] temp=candidate.getBytes("iso-8859-1");
candidate = new String(temp);
//得到投票人的IP地址
String IP=(String)request.getRemoteAddr();
//加载桥接器
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
Connection con = null;
Statement sql = null;
ResultSet rs = null;
//判断投票人的IP是否已经投过票
try{
con = DriverManager.getConnection("jdbc:odbc:vote","","");
sql = con.createStatement();
rs = sql.executeQuery("SELECT * FROM voters WHERE voterIP='" + IP +"'");
int row=0;
while(rs.next()){
row++;
}
if(row>=1){
alowVote = false;
}
}
catch(SQLException e1){
e1.printStackTrace();
}
//进行投票处理
if(candidate.equals("?")){
out.print("您没有投票。");
}
/*
else if( alowVote == false){
out.print("您已经投过票了。");
}
*/
else{
out.print("您投了一票。");
countTotal();
try{
rs = sql.executeQuery("SELECT count FROM candidates WHERE name='" + candidate + "'");
rs.next();
int count = rs.getInt("count");
count++;
sql.executeUpdate("UPDATE candidates SET count=" + count + " WHERE name='" + candidate + "'");
sql.executeUpdate("INSERT INTO voters (voterIP) VALUES ('" + IP + "')");
}
catch(SQLException e){
e.printStackTrace();
}
//显示得票情况
try{
rs = sql.executeQuery("SELECT * FROM candidates");
StringBuffer candidatesList = new StringBuffer();
candidatesList.append("<table border=1>");
candidatesList.append("<tr><td>姓名</td><td>得票数</td><td>得票率</td></tr>");
while(rs.next()){
candidatesList.append("<tr>");
candidatesList.append("<td>" + rs.getString("name") + "</td>");
int count = rs.getInt("count");
candidatesList.append("<td>" + count + "</td>");
double rate = (double)count / total ;
rate = rate * 100; //保留两位小数
int rate2 = ((int)rate) + (rate - ((int)rate) >= 0.5 ? 1 : 0); //四舍五入处理
candidatesList.append("<td>" + rate2 + "%</td>");
candidatesList.append("</tr>");
}
candidatesList.append("</table>");
candidatesList.append("总投票数:" + total);
out.print(candidatesList);
}
catch(SQLException e){
e.printStackTrace();
}
}
%>
</body>
</html>