📄 big_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 show=request.getParameter("show");
String sql="select * from class_big where id='"+show+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
String name=rs.getString("name");
rs.close();
sql="select * from class_small where bigid='"+show+"'";
rs=data.executeQuery(sql);
%>
<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">
  <%
  int i=0;
  int id=0;
  String smallname="";
  while(rs.next())
  {
  i++;
  id=rs.getInt("id");
  smallname=rs.getString("name");
  %>
  <tr>
  <td width="35" height="20"><div align="center"><%=i%></div></td>
  <td width="165">　<a href="small_show.jsp?show=<%=id%>"><%=smallname%></a></td>
  </tr>
  <%}%>
    </table>
  </td>
  </tr>
  </table>
  </td>
  </tr>
</table>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -