📄 waredel_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+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<%
String id=request.getParameter("show");
String sql="select * from ware where id='"+id+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
String warename=rs.getString("warename");
String small_pic=rs.getString("small_pic");
String addware=rs.getString("addware");
String addtime=rs.getString("addtime").substring(0,16);
String class_small=rs.getString("class_small");
String class_big=rs.getString("class_big");
rs.close();
sql="select * from class_big where id='"+class_big+"'";
rs=data.executeQuery(sql);
rs.next();
String bigclass=rs.getString("name");
rs.close();
sql="select * from class_small where bigid='"+class_big+"' and smallid='"+class_small+"'";
rs=data.executeQuery(sql);
rs.next();
String smallclass=rs.getString("name");
rs.close();
%>
<body leftmargin="0" topmargin="0">
<table width="300" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr> 
    <td height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">商品<%=warename%>的部分资料</font></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr> 
          <td height="25">　所在分类:　<font color="#FF0000"><%=bigclass%></font>-><font color="#FF0000"><%=smallclass%></font>-><font color="#FF0000"><%=warename%></font></td>
        </tr>
        <tr> 
          <td height="10"></td>
        </tr>
        <tr> 
          <td height="20">　商品图片:</td>
        </tr>
        <tr> 
          <td height="120"><div align="center"><img src="../upload/<%=small_pic%>" height="100" width="100" border="0"></div></td>
        </tr>
        <tr> 
          <td height="10"></td>
        </tr>
        <tr> 
          <td height="25">　添加人:<font color="#FF0000"><%=addware%></font></td>
        </tr>
        <tr>
          <td height="25">　添加时间:<%=addtime%></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="25" bgcolor="3969A5"></td>
  </tr>
</table>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -