pollresult.jsp

一个关于商业的网站

<%
/*
 *	pollResult.jsp  post users' selection
 *	Written by Jack April 16th,2001
 *      All rights reserved by EVERSTAR COMPANY. 2001-2002.
 *  Notes:
 *       refered tables:   THEMEINFO、THEMEOPINION
 *                model:   OnlinePoll
 *  Modified Records:
 *       $2001.04.16 Created.
 */
%>
<%@  page import="java.util.*,
                  java.sql.*,
                  java.lang.*,
                  java.* ,
                  javax.servlet.http.*"
          contentType="text/html;charset=gb2312"
%>
<jsp:useBean id="dbConn" scope="request" class="com.everstar.database.Database"/>
<%
  String        themeNo = request.getParameter("themeNo");
  String    answerCount = request.getParameter("answerCount");
  String   answer1Count = request.getParameter("answer1Count");
  String   answer2Count = request.getParameter("answer2Count");
  String   answer3Count = request.getParameter("answer3Count");
  String   answer4Count = request.getParameter("answer4Count");       
  String sqlStr="update THEMEOPINION set SELECTCOUNT=(SELECTCOUNT+1) where THEMENO="+themeNo+" and OPINNO=";  
  if (answer1Count.equals("check"))
  {
   sqlStr += 1;
  }
  else if (answer2Count.equals("check"))
  {
    sqlStr += 2;
  }
  else if (answer3Count.equals("check"))
  {
    sqlStr += 3;
  }
  else if (answer4Count.equals("check"))
  {
    sqlStr += 4;
  }
  dbConn.update(sqlStr);
  response.sendRedirect("./showResult.jsp");   
%>