📄 class_small.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.selectthis.class_big.value=="no")
{
alert("请选择大类后显示相应小类");
document.selectthis.class_big.focus();
return false;
}
}
</script>
<br><br><br>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">管理商品小类</font></div></td>
</tr>
</table>
<table width="398" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="398" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="15" bgcolor="#FFFFFF" colspan=2></td>
</tr>
<tr>
<td width="180" valign="top" bgcolor="#FFFFFF">
<form action="" method="post" name="selectthis" onSubmit="return check()">
<input type="hidden" name="selthis" value="">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<select name="class_big" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<option value='no'>请选择</option>
<%
String sql="select * from class_big where habitus='"+"0"+"' and dustbin='"+"0"+"'";
ResultSet rs=data.executeQuery(sql);
int i=0;
String name="";
while(rs.next())
{
i=rs.getInt("id");
name=rs.getString("name");
%>
<option value='<%=name%>'><%=name%></option>
<%} %>
</select>
<input type="submit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" onClick="document.all.selthis.value='true';" value="选择">
</div></td>
</tr>
</table>
</form></td>
<td bgcolor="#FFFFFF">
<%
String selthis=request.getParameter("selthis");
if(selthis!=null && selthis.equals("true"))
{
String getname=request.getParameter("class_big");
byte[] tmp=getname.getBytes("ISO8859_1");
getname=new String(tmp);
sql="select * from class_big where name='"+getname+"'";
rs=data.executeQuery(sql);
rs.next();
int id=rs.getInt("id");
rs.close();
sql="select * from class_small where bigid='"+id+"' and dustbin='"+"0"+"'";
rs=data.executeQuery(sql);
int bigid=0;
int small=0;
String smallname="";
while(rs.next())
{
bigid=rs.getInt("bigid");
small=rs.getInt("smallid");
smallname=rs.getString("name");
%>
<form action="up_class_small.jsp" method="post">
<input type="hidden" name="bigid" value="<%=bigid%>">
<input type="hidden" name="smallid" value="<%=small%>">
<table width="220" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25" width="120"><input type="text" name="name" size="10" maxlength="15" value="<%=smallname%>"></td>
<td width="40"><input type="submit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="修改"></td>
<td width="40"><input type="button" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="删除" onClick="javascript:window.location='del_class_small.jsp?big=<%=bigid%>&small=<%=small%>'"></td>
<td wdith="20"></td>
</tr>
</table>
</form>
<%}}else{%>
<div align="center">请选择左边的选项</div>
<%}%>
</td>
</tr>
<tr>
<td height="15" colspan=2 bgcolor="#FFFFFF">
</tr>
</table></td>
</tr>
</table>
<table width="398" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="25" bgcolor="3969A5"> </td>
</tr>
</table>
<br><br><br>
<form action="" method="post">
<input type="hidden" name="addsmall" value="">
<table width="400" height="30" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="30"><table width="100%" height="30" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><div align="center">
<select name="bigid" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<%
sql="select * from class_big where habitus='"+"0"+"' and dustbin='"+"0"+"'";
rs=data.executeQuery(sql);
int id=0;
String bigname="";
while(rs.next())
{
id=rs.getInt("id");
bigname=rs.getString("name");
%>
<option value='<%=id%>'><%=bigname%></option>
<%}%>
</select> <input type="text" name="smallname" size="20" maxlength="15" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"> <input type="submit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" onClick="document.all.addsmall.value='true';" value="添加">
</div></td>
</tr>
</table> </td>
</tr>
</table></form>
<%
String addsmall=request.getParameter("addsmall");
if(addsmall!=null && addsmall.equals("true"))
{
String bigid=request.getParameter("bigid");
bigid=new String(bigid.getBytes("ISO8859_1"),"GBK");
String smallname=request.getParameter("smallname");
smallname=new String(smallname.getBytes("ISO8859_1"),"GBK");
sql="select * from class_big where id='"+bigid+"'";
rs=data.executeQuery(sql);
rs.next();
String num=rs.getString("number").trim();
rs.close();
int lastnum=1;
sql="select * from class_small where bigid='"+bigid+"'";
rs=data.executeQuery(sql);
if(!rs.next())
{
sql="insert into class_small(bigid,smallid,name,dustbin) values(\'"+bigid+"\',\'"+lastnum+"\',\'"+smallname+"\',\'"+"0"+"\')";
rs=data.executeQuery(sql);
}else{
rs.last();
int count=rs.getRow();
lastnum=rs.getInt("smallid");
lastnum=lastnum+1;
if(num.equals("no"))
{
sql="insert into class_small(bigid,smallid,name,dustbin) values(\'"+bigid+"\',\'"+lastnum+"\',\'"+smallname+"\',\'"+"0"+"\')";
rs=data.executeQuery(sql);
}else{
int intnum=Integer.parseInt(num);
if(count>=intnum)
{%>
<script language="JavaScript">
alert("对不起，该类已被限制下级分类数为<%=intnum%>，您不能超过限制");
</script>
<%}else{
sql="insert into class_small(bigid,smallid,name,dustbin) values(\'"+bigid+"\',\'"+lastnum+"\',\'"+smallname+"\',\'"+"0"+"\')";
rs=data.executeQuery(sql);
}}}}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -