📄 hyclass.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>
<%
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>
<%}}%>
<%
String id=request.getParameter("id");
String sql="select * from class_big where id='"+id+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
String bigname=rs.getString("name").trim();
rs.close();
sql="select * from class_small where bigid='"+id+"'";
rs=data.executeQuery(sql);
%>
<body leftmargin="0" topmargin="0">
<table width="430" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="15"></td>
</tr>
</table>
<table align="center" width="430" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="190" valign="top">
<table align="center" width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC">
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td height="25" colspan="4"><div align="center">类(<font color="#FF0000"><%=bigname%></font>)</div></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td height="20" colspan="4"> 分类列表:</td>
</tr>
<%
int i=0;
int smallid=0;
String smallname="";
while(rs.next())
{
i++;
smallid=rs.getInt("smallid");
smallname=rs.getString("name").trim();
%>
<tr>
<td width="30" height="20"><div align="center"><%=i%></div></td>
<td width="100"> <a href="hyclass.jsp?id=<%=id%>&big=<%=id%>&small=<%=smallid%>&name=<%=smallname%>"><%=smallname%></a></td>
<td width="30"><div align="center"><a href="hyclass.jsp?id=<%=id%>&big=<%=id%>&small=<%=smallid%>&name=<%=smallname%>">查看</a></div></td>
<td width="30"><div align="center"><a href="bigaction.jsp?id=<%=id%>&delete=<%=smallid%>"><font color="#FF0000">删除</font></a></div></td>
</tr>
<%} %>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10" colspan="2"></td>
</tr>
<tr>
<td width="20" colspan="2"><div align="center"><input type="button" value="确定还原" onClick="javascript:window.location='bigaction.jsp?id=<%=id%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
</tr>
</table></td>
<td width="30"></td>
<td width="210"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<%
String getbig=request.getParameter("big");
String getsmall=request.getParameter("small");
if(getbig!="" && getbig!=null)
{
if(getsmall!="" && getsmall!=null)
{
String getname=request.getParameter("name");
getname=new String(getname.getBytes("ISO8859_1"),"GBK");
int pagesize=12;
int allcount;
int allpage;
int intpage;
String strpage=request.getParameter("page");
if(strpage==null)
{
intpage=1;
}
else{
intpage=Integer.parseInt(strpage);
if(intpage<1) intpage=1;
}
sql="select * from ware where class_small='"+getsmall+"' and class_big='"+getbig+"' order by id desc";
rs=data.executeQuery(sql);
%>
<tr>
<td height="25" colspan="2"> 分类(<font color="#FF0000"><%=getname%></font>)商品列表：</td>
</tr>
<%
if(!rs.next())
{%>
<tr>
<td height="30" colspan="2"><div align="center"><font color="#FF0000">该分类下尚未录入商品</font></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 wareid=rs.getInt("id");
%>
<tr>
<td width="170" height="20"> <a target="_blank" href="waredel_show.jsp?show=<%=wareid%>"><%=rs.getString("warename")%></a></td>
<td width="40"><div align="center"><a href="bigaction.jsp?id=<%=id%>&big=<%=getbig%>&small=<%=getsmall%>&name=<%=getname%>&del=<%=wareid%>"><font color="#0000FF">删除</font></a></div></td>
</tr>
<%
i=1;
wareid=0;
String warename="";
while(i<pagesize && rs.next())
{
wareid=rs.getInt("id");
warename=rs.getString("warename");
%>
<tr>
<td width="170" height="20"> <a href="waredel_show.jsp?show=<%=wareid%>"><%=warename%></a></td>
<td width="40"><div align="center"><a href="bigaction.jsp?del=<%=wareid%>"><font color="#0000FF">删除</font></a></div></td>
</tr>
<%
i++;
}}%>
<tr>
<td height="10"><td>
</tr>
<tr>
<td colspan="2">
<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="hyclass.jsp?page=<%=intpage-1%>&id=<%=id%>&big=<%=getbig%>&small=<%=getsmall%>&name=<%=getname%>">上一页 </a>
<%} else{%>
<a href="hyclass.jsp?page=<%=1%>&id=<%=id%>&big=<%=getbig%>&small=<%=getsmall%>&name=<%=getname%>">最前页</a><a href="hyclass.jsp?page=<%=intpage-1%>&id=<%=id%>&big=<%=getbig%>&small=<%=getsmall%>&name=<%=getname%>"> 上一页</a>
<%}}%>
<%
if(intpage<allpage)
{
if(intpage==allpage)
{%>
<a href="hyclass.jsp?page=<%=intpage+1%>&id=<%=id%>&big=<%=getbig%>&small=<%=getsmall%>&name=<%=getname%>">下一页</a>
<%}else{%>
<a href="hyclass.jsp?page=<%=intpage+1%>&id=<%=id%>&big=<%=getbig%>&small=<%=getsmall%>&name=<%=getname%>">下一页 </a><a href="hyclass.jsp?page=<%=allpage%>&id=<%=id%>&big=<%=getbig%>&small=<%=getsmall%>&name=<%=getname%>">最后页</a>
<%}}%>
</div>
</form>
</td>
</tr>
<%}}%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -