class_big.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+"'";
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>
<script language="JavaScript">
function check()
{
  if(document.addthis.thisclass.value.length==0)
  {
     alert("请填写新类的类名称");
	 document.addthis.thisclass.focus();
	 return false;
  }
}
</script>
<%
String addclass=request.getParameter("addclass");
if(addclass!=null && addclass.equals("true"))
{
String thisclass=request.getParameter("thisclass");
byte[] tmp=thisclass.getBytes("ISO8859_1");
thisclass=new String(tmp);
String setnumber=request.getParameter("number");

String sql="select * from class_big where name='"+thisclass+"'";
ResultSet rs=data.executeQuery(sql);
if(rs.next())
{%>
<script language="JavaScript">
alert("对不起，该类名已经存在,请另换一个");
</script>
<%}else{
sql="insert into class_big(name,number,habitus,dustbin) values(\'"+thisclass+"\',\'"+setnumber+"\',\'"+"0"+"\',\'"+"0"+"\')";
rs=data.executeQuery(sql);
}}%>

<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='"+"0"+"' and dustbin='"+"0"+"'";
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="up_class_big.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_big.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_stop.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" size="3">共有<font color="#FF0000"><%=i%></font>种大类</font></div></td>
</tr>
</table>
</table>
</td>
</tr>
</table>
<br><br><br>
<form action="" method="post" name="addthis" onSubmit="return check()">
<input type="hidden" name="addclass" value="">
<table width="260" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="120" height="25"><div align="center">分类名称</div></td>
    <td width="100"><div align="center">下级分类数量</div></td>
    <td width="40"><div align="center">操作</div></td>
  </tr>
  <tr>
    <td height="25"><div align="center"><input type="text" name="thisclass" size="20" maxlength="20" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
    <td><div align="center"><select name="number" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
	         <option value='no' selected>不限制</option>
			 <%
			 for(int a=1;a<=15;a++)
			 {
			 %>
			 <option value='<%=a%>'><%=a%>种</option>
			 <%}%>
			 </select></div></td>
    <td><div align="center">
          <input type="submit" value="添加" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" onClick="document.all.addclass.value='true';">
        </div></td>
  </tr>
</table>
</form>