📄 showclass.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*,java.util.*,shop.buy.buy" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(images/css.css); -->
</style>
<%
String show=request.getParameter("show");
if(show!="" && show!=null)
{
String selclass="select * from class_small where id='"+show+"'";
ResultSet sel=data.executeQuery(selclass);
sel.next();
String big=sel.getString("bigid");
String small=sel.getString("smallid");
sel.close();
%>
<script language="JavaScript">
self.location="showclass.jsp?big=<%=big%>&small=<%=small%>";
</script>
<%}%>
<body bgcolor="#63bce6" leftmargin="0" topmargin="0">
<table border=0 cellPadding=0 cellSpacing=0 width=770>
<tr height=7 background="images/main_top_line.gif">
<td colSpan=3 height=7></td>
</tr>
<tr>
<td background="images/main_left_line.gif" width=7></TD>
<td vAlign=top> <table width="756" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="95" valign="middle"><%@ include file="top.jsp"%></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="165"><%@ include file="left.jsp" %></td>
<td width="14"></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"><div align="right" class="darkbluetext">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="560" height="25"><div align="right">HOME
> <font color="#FF0000">商品分类</font></div></td>
<td> </td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height="20"> </td>
</tr>
<tr>
<td><table width="560" height="35" border="0" cellpadding="0" cellspacing="0" background="images/wareclass.gif">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="90"></td>
<td>
<%
boolean bigclass=false;
String getbig=request.getParameter("big");
String getsmall=request.getParameter("small");
if(getbig!="" && getbig!=null)
{ bigclass=true; }
sql="select * from class_big where id='"+getbig+"'";
rs=data.executeQuery(sql);
rs.next();
String namebig=rs.getString("name");
rs.close();
%>
<a href="showclass.jsp?big=<%=getbig%>&small=all"><font color="#FF0000"><%=namebig%></font></a></td>
</tr>
<tr>
<td height="10"></td>
<td></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="560" height="20"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"></td>
</tr>
<tr>
<td>
<table width="90%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td height="20">
<%
sql="select * from class_small where bigid='"+getbig+"' and dustbin='"+"0"+"'";
rs=data.executeQuery(sql);
id=0;
String name="";
while(rs.next())
{
id=rs.getInt("id");
name=rs.getString("name");
%>
<a href="showclass.jsp?show=<%=id%>"><%=name%></a>
<%}%>
</td>
</tr>
</table>
</td>
</tr>
</table></td>
<td></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td>
<%
if(bigclass){%>
<iframe src="class.jsp?big=<%=getbig%>&small=<%=getsmall%>" frameborder="0" width="560" height="1120" scrolling="no"></iframe>
<%}%>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td></td>
</tr>
</table></td>
<td background="images/main_right_line.gif" width=7></td>
</tr>
<tr height=7>
<td background="images/main_bottom_line.gif" colSpan=3 height=7></td>
</tr>
</table>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -