📄 classmana.jsp
字号:
<%@ include file="conn.jsp"%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div align="center">
<center>
<table border="0" cellpadding="3" cellspacing="0" class="border" width="95%" style="border-collapse: collapse" bordercolor="#111111" >
<tr>
<th class="title" colspan="2" height="25" width="100%">类别管理 </th>
</tr>
<tr>
<td class="tdbg" colspan="2"><b>注意</b>：<br>
①删除类别同时将删除该类别下所有资料！删除分类同时删除下属分类和其中资料！ 操作时请完整填写表单信息。<br>
②如果选择<b>复位所有类别</b>，则所有类别都将作为一级类别分类，这时您需要重新对各个类别进行归属的基本设置，<b>不要轻易使用该功能</b>，仅在做出了错误的设置而无法复原类别之间的关系和排序的时候使用
</td>
</tr>
<tr>
<td class="title"><b>类别操作选项</b></td>
<td class="title"><a href="classmana.jsp"> 类别管理首页</a> | <a href="?action=add">
新建一级类别</a> | </td>
</tr>
</table>
<br>
<table width="95%" cellspacing="0" cellpadding="0" class="border" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<th width="58%" class="title" height=25>类别分类 </th>
<th width="42%" class="title" height=25>操作 </th>
</tr>
<%
String sql="select classid,child,class from scott.class where parentid=0 order by classid asc";
ResultSet rst=stmt.executeQuery(sql);
while(rst.next()) { %>
<tr class="tdbg2">
<td height="25" width="58%"> <img src="pic/plus.gif"><b><%=rst.getString("class")%>(<%=rst.getString("child")%>)</b>
</td>
<td width="42%">
<p align="left"><a href="addclass.jsp?action=add&editid=<%=rst.getString("classid")%>"><u>添加分类</u></a>
| <a href="editclass.jsp?action=edit&editid=<%=rst.getString("classid")%>"><u>修改类别</u></a> |
</td>
</tr>
<%
sql="select classid,child,class,classtype from scott.class where parentid='"+rst.getString("classid")+"' order by classid asc";
ResultSet rst1=stmt1.executeQuery(sql);
while(rst1.next()) { %>
<tr class="tdbg">
<td height="25" width="58%"> <img src="pic/plus.gif"><%=rst1.getString("class")%>(<%=rst1.getString("child")%>)
</td>
<td width="42%">
<div align="left"><a href="addclass.jsp?action=add&editid=<%=rst1.getString("classid")%>"><u>添加分类</u></a>
| <a href="editclass.jsp?action=edit&editid=<%=rst1.getString("classid")%>"><u>修改类别</u></a> | </div>
</td>
</tr>
<% Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select classid,child,class,classtype from scott.class where parentid='"+rst1.getString("classid")+"' order by classid asc";
ResultSet rst2=stmt2.executeQuery(sql);
while(rst2.next()) { %>
<tr class="tdbg2">
<td height="25" width="58%"> <img src="pic/nofollow.gif"><%=rst2.getString("class")%>
</td>
<td width="42%">
<p align="left"><a href="freeadd.jsp?action=add&classid=<%=rst2.getString("classid")%>&classtype=<%=rst2.getString("classtype")%>"><U>
</U></a><a href="addclass.jsp?action=add&editid=<%=rst2.getString("classid")%>"><u>添加分类</u></a>
| <a href="editclass.jsp?action=edit&editid=<%=rst2.getString("classid")%>"><u>修改类别</u></a>
| <a href="delclass.jsp?classid=<%=rst2.getString("classid")%>">删除 </a>
</td>
</tr>
<%}
rst2.close();
}
rst1.close();%>
<%}%>
</table>
</center>
</div>
<div align="center">
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -