简单实现一个投票系统jsp+mssql+javabean首先规划下系统整体:Conn.java (数据库连接的java类文件)index.jsp (首页)vote.jsp (投票提交,sql执行对投票数进行累加)s.jsp (投票成功后提示并转到结果显示页)result.jsp (显示投票结果)add.jsp (可以增加项,也就是要投票的项,这里是大学的名字)addvote.jsp (sql执行)del.jsp (删除投票项)delcl.jsp (sql执行删除操作)style.css (css控制)实现过程:首先创建一个数据库edu .表education 字段为:name(学校的名字) ,num(票数) create database edu(创建库)use educreate table education(id int identity(1,1) primary key,name char(20) not null,num int not null)这里用到sql的驱动为:jtds-0.8.1.jar(1)创建Conn.java类文件package com;import java.sql.*;public class Conn {String url,sql;Connection con=null;Statement stmt=null;ResultSet rs=null;public Conn(){try{Class.forName("net.sourceforge.jtds.jdbc.Driver");url="jdbc:jtds:sqlserver://localhost:1433/edu";con=DriverManager.getConnection(url,"sa","");stmt=con.createStatement();}catch(Exception e){e.printStackTrace();}}public ResultSet executeQuery(String sql){try{rs=stmt.executeQuery(sql);}catch(SQLException e){System.err.println(e.getMessage());}return rs;}public int executeUpdate(String sql){int result=0;try{result=stmt.executeUpdate(sql);}catch(SQLException e){e.getMessage();}return result;}}(2) 创建index.jsp<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><jsp:useBean id="voteBean" scope="page" class="com.Conn"/><html><head><title></title><meta http-equiv="text/html;charset=gb2312"><link rel="stylesheet" type="text/css" href="style.css"></head><body><div align="center">请选择你喜欢的学校投票</div><%request.setCharacterEncoding("gb2312");%><%!String sql;ResultSet rs;%><%sql="select * from education";rs=voteBean.executeQuery(sql);%><center><table><form action="vote.jsp" method="post"><%while(rs.next()){%><tr><td><input type="radio" name="name" value=<%=rs.getString("id")%>> <%=rs.getString("name")%></td></tr><%}rs.close();%><tr><td><input type="submit" value="投票"></td></tr></form><tr><td><a href="result.jsp">查看结果</a></td></tr></table></center></body></html>(3)创建Vote.jsp<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*" language="java"%><jsp:useBean id="voteBean" scope="page" class="com.Conn"/><%String name=request.getParameter("name");if(name !=null && name !=""){String sql="update education set num=num+1 where id="+name;voteBean.executeUpdate(sql);}%><jsp:forward page="s.jsp"/>(4)s.jsp (投票后提示信息并转向结果显示)<%@ page contentType="text/html; charset=gb2312"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>投票</title></head><script language="javascript">alert("投票成功，请查看结果！！");window.location.href='result.jsp';</script><body></body></html>(5)result.jsp(结果显示页)<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><jsp:useBean id="voteBean" scope="page" class="com.Conn"/><html><head><title>投票结果</title><meta http-equiv="Content-Type" content="text/html;charset=gb2312"><link rel="stylesheet" type="text/css" href="style.css"></head><body><%!int totalSum=0;ResultSet rs=null;String sql;%><center><table><%rs=voteBean.executeQuery("select * from education");int i=1;while(rs.next()){%><tr><td>选项<%=i%>:<%=rs.getString("name")%></td></tr><%totalSum=rs.getInt("num");%><tr><td>得:[<%=totalSum %>票]</td></tr><%i++;}%></table></center><%rs.close();%><div align="right"><a href="index.jsp">返回投票</a></div></body></html>(6)add.jsp (添加页面)<%@ page language="java" contentType="text/html;charset=gb2312"%> <html><head><title>添加学校</title></head><body><center><tr><td colspan="3" bgcolor="#99CCFF">增加</td></tr><tr><td colspan="3"><form action="addvote.jsp" method="post"><p>内容:<input type="text" name="name1"></p><input type="submit" name="submit" value="提交"><input type="reset" name="reset" value="重置"></form></td></tr><tr><td><a href="index.jsp">投票中心</a></td></tr></table></center></body></html>(7)addvote.jsp (添加执行操作)<%@ page contentType="text/html;charset=gb2312"%><%@ page language="java"import="java.sql.*"%><jsp:useBean id="voteBean" scope="page" class="com.Conn"/><html><head><meta http-equiv="Content-Type" content="text/html;charset=gb2312"> </head><body><%!String name;ResultSet rs;String sql;%><%request.setCharacterEncoding("gb2312");name=request.getParameter("name1");if(name!=null && name!=""){sql="insert into education(name,num) values('"+name+"',0)";voteBean.executeUpdate(sql);}%></body><jsp:forward page="del.jsp"/>(8)del.jsp (删除页面)<%@ page language="java" contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%><jsp:useBean id="voteBean" scope="page" class="com.Conn"/><html><head><title>修改,删除操作</title><meta http-equiv="Content-Type" content="text/html;charset=gb2312"><link rel="stylesheet" type="text/css" href="style.css"></head><%!ResultSet rs;String sql;%><body><div align="center"><% request.setCharacterEncoding("gb2312");sql="select id,name from education order by id";rs=voteBean.executeQuery(sql);%><table width="60%" border="0" cellspacing="1" cellpadding="2"><tr><td width="10%" bgcolor="#99CCFF"><div align="center">序号</div></td><td width="30%" bgcolor="#99CCFF"><div align="center">学校</div></td><td width="10%" bgcolor="#99CCFF"><div align="center">删除操作</div></td></tr><%int i=1;while(rs.next()){%><tr><td><div align="center"><%=i%></div></td><td><div align="center"><%=rs.getString("name")%></div></td><td><div align="center"><a href="delcl.jsp?id=<%=rs.getInt("id")%>">删除</a></div></td></tr><%i=i+1;}%></table></div></body></html>(9)delcl.jsp(执行删除操作)<%@ page language="java" import="java.sql.*"contentType="text/html;charset=gb2312"%><jsp:useBean id="voteBean" class="com.Conn" scope="page"/><html><head><title>删除操作</title></head><body><%String id=request.getParameter("id");if(id!=null &&id!=""){voteBean.executeUpdate("delete from education where id="+id);}%><jsp:forward page="del.jsp"/></body></html>(10) style.cssbody{font-size:85%;font-family:宋体;background-image:url('img/background.jpg')} td{font-size:9pt;}p{font-size:9pt;}li{font-size:9pt;}a{text-decoration:none;color:navy}a:hover{color:#ff0000;text-decoration:underline}结束。