vote.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<script language="JavaScript">
function check()
{
  if(document.addthis.matter.value.length==0)
  {
    alert("您需要为新投票添加一个主题");
	document.addthis.matter.focus();
	return false;
  }
}
</script>
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr> 
    <td height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">投票管理</font></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr>
		<td height="15"></td>
		</tr>
	    <tr>
          <td>
		  <%
		  String sql="select * from vote order by id desc";
		  ResultSet rs=data.executeQuery(sql);		  
		  int i=0;
		  int id=0;
		  String matter="";
		  String start="";
          while(rs.next())
		  {
		  i++;
		  id=rs.getInt("id");
		  matter=rs.getString("matter");
		  start=rs.getString("start");
		  %>
		  <form action="" method="post">
		  <table align="center" width="100%" cellpadding="0" cellspacing="0" border="0">		  
		  <tr>
		  <td width="40" height="20"><div align="center"><%=i%></div></td>
		  <td width="360"><a href="vote.jsp?show=<%=id%>"><%if(start.equals("1")){%><font color="#FF0000"><%}else{%><font color="#000000"><%}%><%=matter%></font></a></td>
		  <td width="50"><div align="center">
		  <%if(start.equals("1")){%>
		  <input type="button" value="停用" onClick="javascript:self.location='vote.jsp?stop=<%=id%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
		  <%}else{%>
		  <input type="button" value="启用" onClick="javascript:self.location='vote.jsp?start=<%=id%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
		  <%}%>
		  </div></td>
		  <td width="50"><div align="center"><input type="button" value="删除" onClick="javascript:window.location='vote.jsp?del=<%=id%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
		  </tr>
		  </table>
		  </form>
		  <%}%>		  
		  </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="25" bgcolor="3969A5"><div align="center">　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　<a href="vote.jsp?add=yes"><font color="#DFDFDF">添加新投票</font></a></div></td>
  </tr>
</table>
<%
String add=request.getParameter("add");
if(add!="" && add!=null)
{%>
<form action="" method="post" name="addthis" onSubmit="return check()">
<input type="hidden" name="addmatter" value="">
<table align="center" width="500" cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="25">投票主题:<input name="matter" type="text" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" size="45" maxlength="200">　选项数量 
        <select name="number" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<%for(int j=1;j<=50;j++){%>
<option value="<%=j%>"><%=j%></option>
<%}%></select>
<input type="submit" value="下一步" onClick="document.all.addmatter.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
</tr>
</table>
</form>
<%}%>
<%
String addmatter=request.getParameter("addmatter");
if(addmatter!=null && addmatter.equals("true"))
{
String getmatter=request.getParameter("matter");
getmatter=new String(getmatter.getBytes("ISO8859_1"),"GBK");
String number=request.getParameter("number");
int intnum=Integer.parseInt(number);
%>
<form action="" method="post">
<input type="hidden" name="thisvote" value="">
<input type="hidden" name="getmatter" value="<%=getmatter%>">
<input type="hidden" name="number" value="<%=number%>">
<table width="500" align="center" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" align="center" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr bgcolor="3969A5">
<td height="25"><div align="center"><font color="#FFFFFF"><%=getmatter%></font></div></td>
</tr>
<tr>
<td height="15"></td>
</tr>
<%
for(int v=1;v<=intnum;v++)
{%>
<tr>
<td height="25"><div align="center">选项<%=v%>:<input name="vote<%=v%>" type="text" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" size="50" maxlength="200"></div><td>
</tr>
<%}%>
<tr>
<td height="10"></td>
</tr>
<tr>
<td height="25"><div align="center"><input type="submit" value="添加" onClick="document.all.thisvote.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr bgcolor="3969A5">
<td height="25"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<%}%>
<%
String thisvote=request.getParameter("thisvote");
if(thisvote!=null && thisvote.equals("true"))
{
String setmatter=request.getParameter("getmatter");
setmatter=new String(setmatter.getBytes("ISO8859_1"),"GBK");
String getnum=request.getParameter("number");
int intnumber=Integer.parseInt(getnum); 
sql="insert into vote(matter,start,number) values(\'"+setmatter+"\',\'"+"0"+"\',\'"+intnumber+"\')";
rs=data.executeQuery(sql);
sql="select * from vote";
rs=data.executeQuery(sql);
rs.last();
int addnum=rs.getInt("id");
for(int a=1;a<=intnumber;a++)
{
String getvote=request.getParameter("vote"+a);
getvote=new String(getvote.getBytes("ISO8859_1"),"GBK");
if(!getvote.equals(""))
{
sql="insert into addvote(vote,number,titleid) values(\'"+getvote+"\',\'"+0+"\',\'"+addnum+"\')";
rs=data.executeQuery(sql);
}}
sql="select * from addvote where titleid='"+addnum+"'";
rs=data.executeQuery(sql);
rs.last();
int getnumber=rs.getRow();
if(getnumber<intnumber)
{%>
<script language="JavaScript">
alert("应有<%=intnumber%>个选项，您只填写了<%=getnumber%>个选项\n其余的可在修改时添加");
</script>
<%}
response.sendRedirect("vote.jsp");
}
%>
<%
String del=request.getParameter("del");
if(del!="" && del!=null)
{
sql="select * from vote where id='"+del+"'";
rs=data.executeQuery(sql);
rs.next();
String getstart=rs.getString("start");
rs.close();
if(getstart.equals("1"))
{%>
<script language="JavaScript">
alert("该投票正在使用，请停用后再删除");
</script>
<%}else{
sql="delete from vote where id='"+del+"'";
rs=data.executeQuery(sql);
sql="delete from addvote where titleid='"+del+"'";
rs=data.executeQuery(sql);
response.sendRedirect("vote.jsp");
}}
%>
<%
String show=request.getParameter("show");
if(show!="" && show!=null)
{
sql="select * from vote where id='"+show+"'";
rs=data.executeQuery(sql);
rs.next();
String getm=rs.getString("matter");
String gets=rs.getString("start");
int getn=rs.getInt("number");
rs.close();
%>
<table align="center" width="500" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC">
<tr bgcolor="3969A5">
<td height="25"><div align="center"><font color="#FFFFFF"><%=getm%></font></div></td>
</tr>
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td height="20"></td>
</tr>
<tr>
<td>
<%
sql="select * from addvote where titleid='"+show+"'";
rs=data.executeQuery(sql);
int ij=0;
int gsid=0;
String strvote="";
int n=0;
while(rs.next())
{
ij++;
gsid=rs.getInt("id");
strvote=rs.getString("vote");
n=rs.getInt("number");
%>
<form action="upvote.jsp" method="post">
<input type="hidden" name="id" value="<%=show%>">
<input type="hidden" name="gsid" value="<%=gsid%>">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td width="80" height="25"><div align="center">选项<%=ij%>:</div></td>
<td width="240"><input type="text" name="setvote" size="40" maxlength="200" value="<%=strvote%>" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
<td width="100"><div align="center">票数:<%=n%></div></td>
<td width="40"><div align="center"><input type="submit" value="修改" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
<td width="40"><div align="center"><input type="button" value="删除" onClick="javascript:window.location='vote.jsp?delete=<%=gsid%>&voteid=<%=show%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
</tr>
</table>
</form>
<%}
if(ij<getn)
{
for(int b=ij;b<getn;b++)
{%>
<form action="addvote.jsp" method="post">
<input type="hidden" name="id" value="<%=show%>">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td width="80" height="25"><div align="center">选项<%=b+1%>:</div></td>
<td width="240"><input type="text" name="add" size="40" maxlength="200" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
<td width="100"></td>
<td width="40"><input type="submit" value="添加" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
<td width="40"><input type="button" value="删除" onClick="javascript:window.location='vote.jsp?delnull=<%=show%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
</tr>
</table>
</form>
<%}}%>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="3969A5">
    <td height="25"><div align="center">　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　<a href="vote.jsp?delnum=<%=show%>"><font color="#DFDFDF">清空调查数据</font></a></div></td>
</tr>
</table>
<%}%>
<%
String delete=request.getParameter("delete");
if(delete!="" && delete!=null)
{
sql="delete from addvote where id='"+delete+"'";
rs=data.executeQuery(sql);
String getshow=request.getParameter("voteid");
response.sendRedirect("vote.jsp?show="+getshow);
}
%>
<%
String delnull=request.getParameter("delnull");
if(delnull!="" && delnull!=null)
{
sql="select * from vote where id='"+delnull+"'";
rs=data.executeQuery(sql);
rs.next();
int getint=rs.getInt("number");
rs.close();
sql="update vote set number='"+(getint-1)+"' where id='"+delnull+"'";
rs=data.executeQuery(sql);
response.sendRedirect("vote.jsp?show="+delnull);
}
%>
<%
String delnum=request.getParameter("delnum");
if(delnum!="" && delnum!=null)
{
sql="update addvote set number='"+0+"' where titleid='"+delnum+"'";
rs=data.executeQuery(sql);
response.sendRedirect("vote.jsp?show="+delnum);
}
%>
<%
String stop=request.getParameter("stop");
if(stop!="" && stop!=null)
{
sql="update vote set start='"+"0"+"' where id='"+stop+"'";
rs=data.executeQuery(sql);
response.sendRedirect("vote.jsp");
}
%>
<%
String getstart=request.getParameter("start");
if(getstart!="" && getstart!=null)
{
sql="select * from vote where start='"+"1"+"'";
rs=data.executeQuery(sql);
if(rs.next())
{
String getmatter=rs.getString("matter").trim();
%>
<script language="JavaScript">
alert("一次只能启用一个投票主题\n您需要将《<%=getmatter%>》停用后才能启用另一个投票");
</script>
<%}else{
sql="update vote set start='"+"1"+"' where id='"+getstart+"'";
rs=data.executeQuery(sql);
response.sendRedirect("vote.jsp");
}}
%>