classsmall.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("waredel_show.jsp?show="+a,"body","width=300,height=285");
}
function showsmall(a)
{
   window.open("small_show.jsp?show="+a,"body","scrollbars=yes,width=218,height=250");
}
function showbig(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="300" 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="80"><div align="center"><font color="#FFFFFF">所在大类</font></div></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="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
  <tr>
    <td>
	<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<%
	int pagesize=20;
	int allpage;
	int allcount;
	int intpage;
	int i;
	String strpage=request.getParameter("page");
	if(strpage==null)
	{
	intpage=1;
	}
	else{
	intpage=Integer.parseInt(strpage);
	if(intpage<1) intpage=1;
	}
	String sql="select * from class_small where dustbin='"+"1"+"' order by id desc";
	ResultSet rs=data.executeQuery(sql);
	if(!rs.next())
	{%>
	<tr bgcolor="#FFFFFF">
    <td height="60"><div align="center">回收站尚空</div></td>
    </tr>
	<%}
	rs.last();
	allcount=rs.getRow();
    allpage=(allcount+pagesize-1)/pagesize;
    if(intpage>allpage) intpage=allpage;
	if(allpage>0)
	{
	rs.absolute((intpage-1)*pagesize+1);
	int id=rs.getInt("id");
	int bigid=rs.getInt("bigid");
	String name=rs.getString("name");
	%>
	<tr bgcolor="#FFFFFF">
	<td width="40" height="25"><div align="center"><%=id%></div></td>
	<td width="100">　<a href="javascript:showsmall(<%=id%>)"><%=name%></a></td>
	<td width="80"><div align="center">
	<%
	String big="select * from class_big where id='"+bigid+"'";
	ResultSet brs=data.executeQuery(big);
	brs.next();
	String bigname=brs.getString("name");
	brs.close();
	%><a href="javascript:showbig(<%=bigid%>)"><%=bigname%></a></div></td>
	<td width="40"><div align="center"><a href="classsmall.jsp?id=<%=id%>"><font color="#FF0000">还原</font></a></div></td>
	<td width="40"><div align="center"><a href="classsmall.jsp?del=<%=id%>&big=<%=bigid%>"><font color="#FF0000">删除</font></a></div></td>
	</tr>
	<%
	i=1;
	id=0;
	bigid=0;
	name="";
	bigname="";
	while(i<pagesize && rs.next())
	{
	id=rs.getInt("id");
	bigid=rs.getInt("bigid");
	name=rs.getString("name");
	%>
	<tr bgcolor="#FFFFFF">
	<td width="40" height="25"><div align="center"><%=id%></div></td>
	<td width="100">　<a href="javascript:showsmall(<%=id%>)"><%=name%></a></td>
	<td width="80"><div align="center">
	<%
	big="select * from class_big where id='"+bigid+"'";
	brs=data.executeQuery(big);
	brs.next();
	bigname=brs.getString("name");
	brs.close();
	%><a href="javascript:showbig(<%=bigid%>)"><%=bigname%></a></div></td>
	<td width="40"><div align="center"><a href="classsmall.jsp?id=<%=id%>"><font color="#FF0000">还原</font></a></div></td>
	<td width="40"><div align="center"><a href="classsmall.jsp?del=<%=id%>big=<%=bigid%>"><font color="#FF0000">删除</font></a></div></td>
	</tr>
	<%
	i++;
	}}%>
		</table>
	</td>
  </tr>
</table>
<table width="300" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5">&nbsp;</td>
  </tr>
</table>
<form action="" method="post">
<div align="center">当前<font color="#FF0000"><%=intpage%></font>/<font color="#FF0000"><%=allpage%></font>页，每页<font color="#FF0000"><%=pagesize%></font>条
<%if(intpage>1)
 {
if(intpage==1)
 {%>
  <a href="classsmall.jsp?page=<%=intpage-1%>">上一页　</a> 
  <%} else{%>
  <a href="classsmall.jsp?page=<%=1%>">最前页</a><a href="classsmall.jsp?page=<%=intpage-1%>">　上一页</a> 
  <%}}%>
  <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
  <a href="classsmall.jsp?page=<%=intpage+1%>">下一页</a> 
  <%}else{%>
  <a href="classsmall.jsp?page=<%=intpage+1%>">下一页　</a><a href="classsmall.jsp?page=<%=allpage%>">最后页</a> 
  <%}}%>
  </div>
</form>
<br><br>
<%
String id=request.getParameter("id");
if(id!="" && id!=null)
{
sql="select * from class_small where id='"+id+"'";
rs=data.executeQuery(sql);
rs.next();
int getbig=rs.getInt("bigid");
int getsmall=rs.getInt("smallid");
rs.close();
sql="select * from class_big where id='"+getbig+"'";
rs=data.executeQuery(sql);
rs.next();
String name=rs.getString("name");
String dustbin=rs.getString("dustbin");
rs.close();
if(dustbin.equals("1"))
{%>
<script language="JavaScript">
alert("对不起，如果想还原该小类，请先还原其所在大类--><%=name%>");
</script>
<%}else{%>
<div align="center"><font size="3">请选择是否还原该小类下的所有商品</font><br><br>
  <font color="#0000FF">提示:选否将会将该小类下的所有商品永久性删除</font><br>
  <br>
  <a href="classsmall.jsp?action=yes&big=<%=getbig%>&small=<%=getsmall%>"><font size="3" color="#FF0000">是</font></a>　<a href="classsmall.jsp?action=no&big=<%=getbig%>&small=<%=getsmall%>"><font size="3" color="#FF0000">否</font></a></div>
<%}}%>
<%
String action=request.getParameter("action");
if(action!="" && action!=null)
{
String big=request.getParameter("big");
String small=request.getParameter("small");
if(action.equals("no"))
{
sql="update class_small set dustbin='"+"0"+"' where bigid='"+big+"' and smallid='"+small+"'";
rs=data.executeQuery(sql);
sql="delete from ware where class_small='"+small+"' and class_big='"+big+"'";
rs=data.executeQuery(sql);
response.sendRedirect("classsmall.jsp");
}
if(action.equals("yes"))
{
%>
<form action="" method="post">
<input type="hidden" name="thisclass" value="">
<input type="hidden" name="big" value="<%=big%>">
<input type="hidden" name="small" value="<%=small%>">
<table align="center" width="250" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC">
<tr>
<td>
<table align="center" width="250" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<%
sql="select * from ware where class_small='"+small+"' and class_big='"+big+"'";
rs=data.executeQuery(sql);
int wareid=0;
String name="";
while(rs.next())
{
wareid=rs.getInt("id");
name=rs.getString("warename");
%>
<tr>
<td width="200" height="20">　<a href="javascript:show(<%=wareid%>)"><font color="#FF0000"><%=name%></font></a></td>
<td width="50"><div align="center"><a href="classsmall.jsp?delete=<%=wareid%>"><font color="#999999">删除</font></a></div></td>
</tr>
<%}%>
</table>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="30"><div align="center"><input type="submit" value="全部还原" onClick="document.all.thisclass.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 delete=request.getParameter("delete");
if(delete!="" && delete!=null)
{
sql="delete from ware where id='"+delete+"'";
rs=data.executeQuery(sql);
}
%>
<%
String thisclass=request.getParameter("thisclass");
if(thisclass!=null && thisclass.equals("true"))
{
String bigid=request.getParameter("big");
String smallid=request.getParameter("small");
sql="update class_small set dustbin='"+"0"+"' where bigid='"+bigid+"' and smallid='"+smallid+"'";
rs=data.executeQuery(sql);
sql="update ware set dustbin='"+"0"+"' where class_small='"+smallid+"' and class_big='"+bigid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("classsmall.jsp");
}
%>
<%
String del=request.getParameter("del");
if(del!="" && del!=null)
{
String getbig=request.getParameter("big");
%>
<div align="center">删除该小类后，该类下的所有商品将会一起被删除，您确定要删除吗？<br><br>
<a href="classsmall.jsp?delid=<%=del%>"><font color="#FF0000" size="3">确定</font></a>　　<a href="javascript:window.location='classsmall.jsp'"><font color="#FF0000" size="3">取消</font></a></div>
<%}%>
<%
String getid=request.getParameter("delid");
if(getid!="" && getid!=null)
{
sql="select * from class_small where id='"+getid+"'";
rs=data.executeQuery(sql);
rs.next();
int getbigid=rs.getInt("bigid");
int getsmallid=rs.getInt("smallid");
rs.close();
sql="delete from class_small where id='"+getid+"'";
rs=data.executeQuery(sql);
sql="delete from ware where class_small='"+getsmallid+"' and class_big='"+getbigid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("classsmall.jsp");
}
%>