📄 adminedit.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 width="95%" cellspacing="0" cellpadding="0" class="border" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<th width="39%" class="title" height=25>分类
</th>
<th width="31%" 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="39%">
<img src="pic/plus.gif"><b><%=rst.getString("class")%>(<%=rst.getString("child")%>)</b>
</td>
<td width="61%">
<p align="center"></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="39%"> <img src="pic/plus.gif"><%=rst1.getString("class")%>(<%=rst1.getString("child")%>) </td>
<td width="61%">
<div align="center"><a href="freeadd.jsp?action=add&classid=<%=rst1.getString("classid")%>&classtype=<%=rst1.getString("classtype")%>"><u>添加内容</u></a>
| <a href="adminedit1.jsp?action=edit&classid=<%=rst1.getString("classid")%>&classtype=<%=rst1.getString("classtype")%>"><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="39%">
<img src="pic/nofollow.gif"><%=rst2.getString("class")%>
</td>
<td width="61%">
<p align="center"><a href="freeadd.jsp?action=add&classid=<%=rst2.getString("classid")%>&classtype=<%=rst2.getString("classtype")%>"><U>
添加内容</U></a> | <a href="adminedit1.jsp?action=edit&classid=<%=rst2.getString("classid")%>&classtype=<%=rst2.getString("classtype")%>"><u>
内容管理</u></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 + -