waredel.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");
}
</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="502" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">商品回收管理</font></div></td>
  </tr>
</table>
<table width="500" 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 allcount;
int allpage;
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 ware where dustbin='"+"1"+"' order by id desc";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<tr bgcolor="#FFFFFF">
<td height="30" colspan="5"><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");
String name=rs.getString("warename");
%>
<tr bgcolor="#FFFFFF">
<td width="30" height="25"><div align="center"><%=id%></div></td>
          <td width="340"> 　<a href="javascript:show(<%=id%>)"><%=name%></a></td>
<td width="30"><div align="center"><a href="javascript:show(<%=id%>)"><font color="#FF0000">查看</font></a></div></td>
<td width="30"><div align="center"><a href="waredel.jsp?id=<%=id%>"><font color="#FF0000">还原</font></a></div></td>
<td width="70"><div align="center"><a href="waredel.jsp?del=<%=id%>"><font color="#FF0000">永久性删除</font></a></div></td>
</tr>
<%
i=1;
id=0;
name="";
while(i<pagesize && rs.next())
{
id=rs.getInt("id");
name=rs.getString("warename");
%>
<tr bgcolor="#FFFFFF">
<td width="30" height="25"><div align="center"><%=id%></div></td>
          <td width="340">　<a href="javascript:show(<%=id%>)"><%=name%></a></td>
<td width="30"><div align="center"><a href="javascript:show(<%=id%>)"><font color="#FF0000">查看</font></a></div></td>
<td width="30"><div align="center"><a href="waredel.jsp?id=<%=id%>"><font color="#FF0000">还原</font></a></div></td>
<td width="70"><div align="center"><a href="waredel.jsp?del=<%=id%>"><font color="#FF0000">永久性删除</font></a></div></td>
</tr>
<%
i++;
}}%>
	</table>
	</td>
  </tr>
</table>
<table width="502" 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="waredel.jsp?page=<%=intpage-1%>">上一页　</a> 
  <%} else{%>
  <a href="waredel.jsp?page=<%=1%>">最前页</a><a href="waredel.jsp?page=<%=intpage-1%>">　上一页</a> 
  <%}}%>
  <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
  <a href="waredel.jsp?page=<%=intpage+1%>">下一页</a> 
  <%}else{%>
  <a href="waredel.jsp?page=<%=intpage+1%>">下一页　</a><a href="waredel.jsp?page=<%=allpage%>">最后页</a> 
  <%}}%>
  </div>
</form>
<%
String id=request.getParameter("id");
if(id!="" && id!=null)
{
sql="select * from ware where id='"+id+"'";
rs=data.executeQuery(sql);
rs.next();
int class_small=rs.getInt("class_small");
int class_big=rs.getInt("class_big");
rs.close();
sql="select * from class_big where id='"+class_big+"'";
rs=data.executeQuery(sql);
rs.next();
String bname=rs.getString("name").trim();
rs.close();
sql="select * from class_small where bigid='"+class_big+"' and smallid='"+class_small+"'";
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("恢复该商品前请先恢复该商品的上级分类--><%=bname%>--><%=name%>");
</script>
<%}else{
sql="update ware set dustbin='"+"0"+"' where id='"+id+"'";
rs=data.executeQuery(sql);
response.sendRedirect("waredel.jsp");
}}
%>
<%
String del=request.getParameter("del");
if(del!="" && del!=null)
{
sql="delete from ware where id='"+del+"'";
rs=data.executeQuery(sql);
response.sendRedirect("waredel.jsp");
}
%>