📄 small_show.jsp

📁 用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>
<%
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("show");
String sql="select * from class_small where id='"+id+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
int big=rs.getInt("bigid");
int small=rs.getInt("smallid");
String name=rs.getString("name");
rs.close();
%>
<body leftmargin="0" topmargin="0">
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
  <td height="12"></td>
  </tr>
  <tr> 
    <td height="25"><div align="center">类名：<font color="#FF0000"><%=name%></font></div></td>
  </tr>
  <tr>
  <td height="10"></td>
  </tr>
  <tr>
    <td height="25"> 　商品列表：</td>
  </tr>
  <tr>
  <td>
  <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">
  <%
  sql="select * from ware where class_small='"+small+"' and class_big='"+big+"'";
  rs=data.executeQuery(sql);
  int i=0;
  int wid=0;
  String warename="";
  while(rs.next())
  {
  i++;
  wid=rs.getInt("id");
  warename=rs.getString("warename");
  %>
  <tr>
  <td height="20" width="35"><div align="center"><%=i%></div></td>
  <td width="165">　<a target="_blank" href="waredel_show.jsp?show=<%=wid%>"><%=warename%></a></td>
  </tr>
  <%}%>
  </table>
  </td>
  </tr>
  </table>
  </td>
  </tr>
</table>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -