classbig.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 show(a)
{
  window.open("big_show.jsp?show="+a,"body","scrollbars=yes,width=218,height=250");
}
</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+"' and system='"+"1"+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，您不是系统管理员不能进行相应操作");
history.back();
</script>
<%}}%>
<table width="220" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="3969A5">
  <tr> 
    <td height="25" width="40"><div align="center"><font color="#FFFFFF">序号</font></div></td>
    <td width="100">　<font color="#FFFFFF">类名</font></td>
    <td width="40"><div align="center"><font color="#FFFFFF">还原</font></div></td>
    <td width="40"><div align="center"><font color="#FFFFFF">删除</font></div></td>
  </tr>
</table>
<table width="220" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
  <tr>
    <td>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<%
String sql="select * from class_big where dustbin='"+"1"+"'";
ResultSet rs=data.executeQuery(sql);
int id=0;
String name="";
while(rs.next())
{
id=rs.getInt("id");
name=rs.getString("name");
%>
<tr>
<td width="40" height="20"><div align="center"><%=id%></div></td>
<td width="100">　<a href="javascript:show(<%=id%>)"><%=name%></a></td>
<td width="40"><div align="center"><a href="classbig.jsp?id=<%=id%>"><font color="#FF0000">还原</font></a></div></td>
<td width="40"><div align="center"><a href="classbig.jsp?del=<%=id%>"><font color="#FF0000">删除</font></a></div></td>
</tr>
<%}
if(!rs.next())
{%>
<tr bgcolor="#FFFFFF">
<td height="60"><div align="center">回收站尚空</div></td>
</tr>
<%}%>
</table>
	</td>
  </tr>
</table>
<table width="220" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5">&nbsp;</td>
  </tr>
</table>
<br><br><br>
<%
String getid=request.getParameter("id");
if(getid!="" && getid!=null)
{
sql="select * from class_big where id='"+getid+"'";
rs=data.executeQuery(sql);
rs.next();
String bigname=rs.getString("name").trim();
rs.close();
%>
<form action="" method="post">
<input type="hidden" name="hyid" value="<%=getid%>">
<input type="hidden" name="hythis" value="">
<table width="260" align="center" cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="20"><div align="center">请为类(<font color="#FF0000"><%=bigname%></font>)选择还原选项</div></td>
</tr>
<tr>
<td height="20"><div align="left"><input type="radio" name="hy" value="small">还原本类及下属分类(不包括分类下商品)</div></td>
</tr>
<tr>
<td height="20"><div align="left"><input type="radio" name="hy" value="all" checked>还原所有</div></td>
</tr>
<tr>
<td height="20"><div align="left"><input type="radio" name="hy" value="select">
        手动选择还原　　　　　　　 
        <input type="submit" value="选择" onClick="document.all.hythis.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
</tr>
</table>
</form>
<%}%>
<%
String hythis=request.getParameter("hythis");
if(hythis!=null && hythis.equals("true"))
{
String hy=request.getParameter("hy");
String hyid=request.getParameter("hyid");
if(hy.equals("all"))
{
sql="update class_big set dustbin='"+"0"+"' where id='"+hyid+"'";
rs=data.executeQuery(sql);
sql="update class_small set dustbin='"+"0"+"' where bigid='"+hyid+"'";
rs=data.executeQuery(sql);
sql="update ware set dustbin='"+"0"+"' where class_big='"+hyid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("classbig.jsp");
}
else if(hy.equals("small"))
{
sql="update class_big set dustbin='"+"0"+"' where id='"+hyid+"'";
rs=data.executeQuery(sql);
sql="update class_small set dustbin='"+"0"+"' where bigid='"+hyid+"'";
rs=data.executeQuery(sql);
sql="delete from ware where class_big='"+hyid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("classbig.jsp");
}
else if(hy.equals("select"))
{%>
<script language="JavaScript">
window.open("hyclass.jsp?id="+<%=hyid%>,"body","width=450,height=350");
</script>
<%}}%>
<%
String del=request.getParameter("del");
if(del!="" && del!=null)
{%>
<div align="center">删除该小类后，该类下的所有分类及商品将会一起被删除，您确定要删除吗？<br><br>
<a href="classbig.jsp?delid=<%=del%>"><font color="#FF0000" size="3">确定</font></a>　　<a href="javascript:window.location='classbig.jsp'"><font color="#FF0000" size="3">取消</font></a></div>
<%}%>
<%
String delid=request.getParameter("delid");
if(delid!="" && delid!=null)
{
sql="delete from class_big where id='"+delid+"'";
rs=data.executeQuery(sql);
sql="delete from class_small where bigid='"+delid+"'";
rs=data.executeQuery(sql);
sql="delete from ware where class_big='"+delid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("classbig.jsp");
}
%>