class.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
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>
<%}}%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<br><br>
<table width="550" height="25" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="3969A5">
  <tr> 
    <td width="50"><div align="center"><font color="#FFFFFF">类序号</font></div></td>
    <td width="160"><div align="center"><font color="#FFFFFF">分类名称</font></div></td>
    <td width="100"><div align="center"><font color="#FFFFFF">下级分类数量</font></div></td>
    <td width="50"><div align="center"><font color="#FFFFFF">修改</font></div></td>
    <td width="50"><div align="center"><font color="#FFFFFF">删除</font></div></td>
    <td width="120"><div align="center"><font color="#FFFFFF">特殊操作</font></div></td>
    <td width="30">&nbsp;</td>
  </tr>
</table>
<table width="548" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="546" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
  <td height="10" bgcolor="#FFFFFF"></td>
  </tr>
<%
String sql="select * from class_big where habitus='"+"1"+"'";
ResultSet rs=data.executeQuery(sql);
int i=0;
int id=0;
String name="";
String number="";
String setnum="";
while(rs.next())
{
i++;
id=rs.getInt("id");
name=rs.getString("name");
number=rs.getString("number");
%>
<tr>
<td bgcolor="#FFFFFF">
<form action="edit_class.jsp" method="post" name="form1">
<input type="hidden" name="id" value="<%=id%>">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
   <td width="50" height="25"><div align="center"><%=id%></div></td>   
   <td width="160"><div align="center"><input type="text" name="name" value="<%=name%>" size="15" maxlength="20" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
   <td width="100"><div align="center"><select name="number" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                                                                    <%
																	if(number.equals("no"))
																	{ setnum="不限制"; 
																	%>
																	<option value='<%=number%>'><%=setnum%></option>
																	<%
																	for(int b=1;b<=15;b++)
																	{%>
																	  <option value='<%=b%>'><%=b%></option>
																	<%}
																	%>
																	<%}else{%>
																	<option value='<%=number%>'><%=number%>																	
																    <option value='no'>不限制</option>
                                                                    <%
																     for(int j=1;j<=15;j++)
																    {%>
																    <option vlaue='<%=j%>'><%=j%></option>
																    <%}}%></select></div></td>
<td width="50"><div align="center"><input type="submit" value="修改" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
<td width="50"><div align="center"><input type="button" value="删除" onClick="javascript:window.location='del_class.jsp?id=<%=id%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
<td width="120"><div align="center"><input type="button" value="取消暂停状态" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" onClick="javascript:window.location='class_start.jsp?id=<%=id%>'"></div></td>															  
<td width="20"></td>
</tr>
</table>
</form>
</td>
</tr>
<%}%>
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="#3969A5" align="center">
<tr>
<td width="100%" height="30"><div align="center"><font color="#FFFFFF">隐藏类数量:　<font color="#FF0000"><%=i%></font></font></div></td>
</tr>
</table>
</table>
</td>
</tr>
</table>