<%rs.close();%>
2.result.jsp
<%@pagecontentType="text/html;charset=gb2312"%>
<%@pageimport="java.sql.*"%>
useBeanid="dbBean"class="vote.DBConnect"scope="page"/>
<%
Stringsql="select*fromvoteorderbyid";
ResultSetrs=dbBean.executeQuery(sql);
Stringid;
id=request.getParameter("vote");
sql="updatevotesetnumber=number+1whereid="+id;
dbBean.executeQuery(sql);
ResultSetrs1,rstotal;
intquestionNum=0,optType,id1,number,total=0;
Stringquestion,str,optContent;
sql="select*fromvotewhereflag=0andoptType=0orderbyiddesc";
rs=dbBean.executeQuery(sql);
while(rs.next()){
questionNum++;
str="主题"+questionNum+":
";
question=rs.getString("question");
optType=rs.getInt("optType");
id=Integer.toString(rs.getInt("id"));
out.print(str+question+"
");
sql="select*fromvotewhereflag="+id;
rstotal=dbBean.executeQuery(sql);
//求得投票的总数
while(rstotal.next()){
number=rstotal.getInt("number");
total+=number;
}
sql="select*fromvotewhereflag="+id;
rs1=dbBean.executeQuery(sql);
out.print("
//输出各选项的得票数
while(rs1.next()){
id1=rs1.getInt("id");
optContent=rs1.getString("optContent");
number=rs1.getInt("number");
%>
<%=optContent%>得票数:
<%=number%>
<%}%>
<%}%>
3.add.jsp
<%@pagecontentType="text/html;charset=gb2312"%>
<%@pageimport="java.sql.*"%>
useBeanid="dbBean"scope="page"class="vote.DBConnect"/> <% Stringquestion=request.getParameter("question"); if(question==null){ question=""; } Stringtype=request.getParameter("type"); intnum=0,optType=0; try{ num=Integer.parseInt(request.getParameter("num")); } catch(Exceptione){} %>
||
请输入主题名:
<% if(type! =null){ out.print("checked"); optType=1; } else{ optType=0; } %> >多选 请输入选项的数目: <% Stringsubmit=request.getParameter("sumbit"); if(submit! =null){ for(inti=1;i<=num;i++){ %> 选项<%=i%>: <%}%> <%}%> <% Stringsubmit1=request.getParameter("submit1"),str="",optContent,sql; intid; if(submit1! =null){ sql="insertintovote(flag,optType,question)values(0,"+optType+",'"+question+"')"; dbBean.executeUpdate(sql); sql="select*fromvoteorderbyiddesc"; ResultSetrs=dbBean.executeQuery(sql); id=rs.getInt (1); for(inti=1;i<=num;i++){ str=Integer.toString(i); optContent=request.getParameter(str); sql="insertintovote(flag,optContent,number)values("+id+",'"+optContent+"',0)"; dbBean.executeUpdate(sql); } out.print("成功插入主题! "); } %>
4.del.jsp
<%@pagecontentType="text/html;charset=gb2312"%>
useBeanid="dbBean"scope="session"class="vote.DBConnect"/> <% Stringid=request.getParameter("id"); Stringsql="deletefromvotewhereid="+id; if(id! =null){ if(dbBean.executeUpdate(sql)){ out.print("删除记录成功。 "); } } %>
||
请输入删除的序号(ID):
5.display.jsp
<%@pagecontentType="text/html;charset=gb2312"%>
<%@pageimport="java.sql.*"%>
||
useBeanid="dbBean"class=" copyright@ 2008-2022 冰豆网网站版权所有 经营许可证编号:鄂ICP备2022015515号-1