简易投票系统jsp+servlet+javabean

package com.hcketw.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.hcketw.db; public class editvote extends HttpServlet { /** * Constructor of the object. */ public editvote() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("gb2312"); try { String url = "jdbc:odbc:hcketw"; db database = new db(); Connection con = null; con = database.getAccessConn(url); String sql=null; int i,itemID=0; String s=""; int size=Integer.valueOf(request.getParameter("size")); for(i=1;i<=size;i++) { String t=request.getParameter("name"+i); if(t==null){ break; } if(i!=1) { s+=","; } itemID=Integer.valueOf(request.getParameter("itemID"+i)); sql = "update item set content='"+t+"' where ID="+itemID; database.excuteSql(con, sql); s+=itemID; } for(;;i++) { String t=request.getParameter("name"+i); if(t==null){ break; } if(i!=1) { s+=","; } sql = "insert into item (content) values('"; sql+=t+"')"; database.excuteSql(con, sql); sql="select max(ID) from item"; ResultSet rs=database.excuteQuery(con, sql); while(rs.next()) { itemID = Integer.valueOf(rs.getString(1)); } s+=itemID; } String title=request.getParameter("title"); String info=request.getParameter("info"); int indexID=Integer.valueOf(request.getParameter("indexID")); sql="update index set title='"+title+"' where ID="+indexID; database.excuteSql(con, sql); sql="update index set info='"+info+"' where ID="+indexID; database.excuteSql(con, sql); sql="update index set items='"+s+"' where ID="+indexID; database.excuteSql(con, sql); database.closeAccessConn(con); PrintWriter out = response.getWriter(); //out.print("<script language='javascript'>alert('修改成功');</script>"); response.sendRedirect("../editlist.jsp"); //request.getRequestDispatcher("result?ID="+userID).forward(request, response); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occurs */ public void init() throws ServletException { // Put your code here } }