投票JSP程序说明

投票JSP程序说明

开发运行环境：MyEclipse+tomcat+access

数据库：vote.mdb

数据库连接参数：private String driverStr = "sun.jdbc.odbc.JdbcOdbcDriver";

private String connStr = "jdbc:odbc:vote";

数据源设置：控制面板—管理工具—数据源（ODBC）--

系统DSN—添加按钮—创建新数据源：Microsoft-Access-driver(*.mdb) [完成] 数据源名：vote

数据库选择S…（按钮）找到vote.mdb 【即可】

DBBean.java

package dbBean;

import java.sql.*;

public class DBBean

{

private String driverStr = "sun.jdbc.odbc.JdbcOdbcDriver";

private String connStr = "jdbc:odbc:mydbsource";

private Connection conn = null;

private Statement stmt = null;

public DBBean()

{

try {

Class.forName(driverStr);

}

catch(ClassNotFoundException ex) {

System.out.println(ex.getMessage());

}

}

public void setDriverStr(String dstr)

{

driverStr=dstr;

}

public void setConnStr(String cstr)

{

connStr=cstr;

}

public ResultSet executeQuery(String sql)

{

ResultSet rs = null;

try {

conn = DriverManager.getConnection(connStr);

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

}

catch(SQLException ex) {

System.out.println(ex.getMessage());

}

return rs;

}

public int executeUpdate(String sql)

{

int result=0;

try{

conn = DriverManager.getConnection(connStr);

stmt = conn.createStatement();

result = stmt.executeUpdate(sql);

}

catch(SQLException ex){

System.out.println(ex.getMessage());

}

return result;

}

public void close()

{

try{

stmt.close();

conn.close();

}

catch(SQLException ex){

System.out.println(ex.getMessage());

}

}

}

index.jsp

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>

您最喜爱的奥斯卡获奖影片是：

<%

ResultSet rs=db.executeQuery("select * from vote");

while(rs.next())

{

out.println("

");

out.println("

");

}

rs.close();

db.close();

session.setMaxInactiveInterval(-1);

%>

"); out.println(rs.getString("item")); out.println("

查看投票

投票系统维护

vote.jsp

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>

<%

String id=request.getParameter("id");

ResultSet rs=db.executeQuery("select * from vote where id="+id);

int num=0;

if(rs.next())

num=rs.getInt("count");

num++;

rs.close();

db.executeUpdate("update vote set count="+num+" where id="+id);

db.close();

%>

info.jsp

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>

投票结果

<%

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()&&totalNum!=0)

{

out.println("

");

int num=rs.getInt("count");

out.println("

");

out.println("

");

out.println("

");

}

rs.close();

db.close();

%>

选项	得票数	比例
"+rs.getString("item")+"	得："+num+"票共："+totalNum+"票	得票率："); out.println(""); out.println(num*100/totalNum+"%

返回投票页面

manage.jsp

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>

<%@ include file="checkadmin.jsp"%>

系统维护

<%

ResultSet rs=db.executeQuery("select * from vote");

int i=1;

while(rs.next())

{

out.println("

");

out.println("

");

out.println("

");

out.println("

");

i++;

}

rs.close();

db.close();

%>

删除投票项
"+i+"	"+rs.getString("item")+"	删除
添加投票项
内容：
返回投票页面

add.jsp

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>

<%

request.setCharacterEncoding("gb2312");

String additem=request.getParameter("additem");

if(additem!=null)

{

String sql="insert into vote(item,count) values('"+additem+"',"+0+")";

db.executeUpdate(sql);

db.close();

}

%>

delete.jsp

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>

<%

String delid=request.getParameter("delid");

if(delid!=null)

{

db.executeUpdate("delete from vote where id="+delid);

db.close();

}

%>

login.jsp

<%@ page contentType="text/html;charset=gb2312"%>

管理员登录

用户名：
密码：

<%

String warning=request.getParameter("warning");

if(warning!=null)

{

warning=new String(warning.getBytes("8859_1"));

out.println("

"+warning+"，请重新登录或返回首页

");

}

%>

process.jsp

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>

<%

String user=request.getParameter("user");

String pw=request.getParameter("pw");

String sql="select * from admin where name='"+user+"' and password='"+pw+"'";

ResultSet rs=db.executeQuery(sql);

if(rs.next())

{

rs.close();

db.close();

session.setAttribute("admin","ok");

%>

<%

}

else

{

rs.close();

db.close();

%>

<%

}

%>

checkadmin.jsp

<%

if(session.getAttribute("admin")==null)

response.sendRedirect("login.jsp");

%>