📄 classmana.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../conn.jsp"%>
<%request.setCharacterEncoding("gb2312");
if ((session.getAttribute("admin")==null)){
response.sendRedirect("admin.jsp");
}else{
String str=(String)session.getAttribute("rights");
int flag=Integer.parseInt(str.trim());
if(flag<1){
out.print("<br><p align=center>您没有权限操作!</p>");
}else{
String sql="select * from class order by classid";
ResultSet rs=stmt.executeQuery(sql);
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql2="select * from Nclass order by nclassid";
ResultSet rs2=stmt2.executeQuery(sql2);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type=text/css>
<!--
BODY{
margin:0px;
FONT-SIZE: 12px;
FONT-FAMILY: "宋体", "Verdana", "Arial", "Helvetica", "sans-serif";
scrollbar-face-color: #DEE3E7;
scrollbar-highlight-color: #FFFFFF;
scrollbar-shadow-color: #DEE3E7;
scrollbar-3dlight-color: #D1D7DC;
scrollbar-arrow-color: #006699;
scrollbar-track-color: #EFEFEF;
scrollbar-darkshadow-color: #98AAB1;
background-color: #799AE1;
}
table { border:0px; }
td { font:normal 12px 宋体; }
img { vertical-align:bottom; border:0px; }
a { font:normal 12px 宋体; color:#000000; text-decoration:none; }
a:hover { color:#428EFF;text-decoration:underline; }
.sec_menu { border-left:1px solid white; border-right:1px solid white; border-bottom:1px solid white; overflow:hidden; background:#D6DFF7; }
.menu_title { }
.menu_title span { position:relative; top:2px; left:8px; color:#215DC6; font-weight:bold; }
.menu_title2 { }
.menu_title2 span { position:relative; top:2px; left:8px; color:#428EFF; font-weight:bold; }
input,select,Textarea{
font-family:宋体,Verdana, Arial, Helvetica, sans-serif; font-size: 12px;}
}
.style1 {
color: #3D6DD3;
font-weight: bold;
}
-->
</style>
</head>
<body>
<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" bgcolor="#799AE1"><p></p> <table width="620" height="100%" border="0" cellpadding="0" cellspacing="1">
<form name="form1" method="post" action="classmana1.jsp"><tr>
<td bgcolor="#D4DEF9"><div align="center">类别:
<select name="subject" size="1" style="font-size:9pt" onChange="javascript:document.form1.reTitle.value=this.options[selectedIndex].text;">
<%//显示一级栏目
while(rs.next()){
out.print("<option value='"+rs.getString("classid")+"'>"+rs.getString("class")+"</option>");
}
//close class resultset
rs.close();
%>
</select>
<input name="del" type="submit" id="del" value="删除">
</div></td>
</tr>
<tr>
<td height="20" bgcolor="#D4DEF9"><div align="center"></div></td>
</tr>
<tr>
<td bgcolor="#D4DEF9"><div align="center">新名字:
<input name="reTitle" type="text" id="reTitle">
<input name="rename" type="submit" id="rename" value="改名">
</div></td>
</tr>
<tr>
<td height="20" bgcolor="#D4DEF9"><div align="center"></div></td>
</tr>
<tr>
<td bgcolor="#D4DEF9"><div align="center">
<p>新类别:
<input name="newTitle" type="text" id="newTitle">
<input name="new" type="submit" id="new" value="新增">
</p>
</div></td>
</tr> </form>
<tr>
<td height="23" bgcolor="#D4DEF9"><div align="center"></div></td>
</tr>
<tr>
<td height="22" bgcolor="#D4DEF9"><div align="center"><strong>子专题管理</strong></div></td>
</tr>
<tr>
<td height="24" bgcolor="#D4DEF9"><div align="center"></div></td>
</tr>
<form name="form2" method="post" action="classmana2.jsp"><tr>
<td bgcolor="#D4DEF9"><div align="center">子专题:
<select name="subject" size="1" style="font-size:9pt" onChange="javascript:document.form2.reTitle.value=this.options[selectedIndex].text;">
<%//显示二级栏目
while(rs2.next()){
out.print("<option value='"+rs2.getString("nclassid")+"'>"+rs2.getString("nclass")+"</option>");
}
//close Nclass resultset
rs2.close();
%>
</select>
<input name="del" type="submit" id="del" value="删除">
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#D4DEF9"><div align="center"></div></td>
</tr>
<tr>
<td bgcolor="#D4DEF9"><div align="center">
<p>专题修改:
<%Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql3="select * from class order by classid";
ResultSet rs3=stmt3.executeQuery(sql3);
Statement stmt4=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql4="select * from class order by classid";
ResultSet rs4=stmt4.executeQuery(sql4);
%>
<input name="reTitle" type="text" id="reTitle" size="15">
在
<select name="classid" size="1" id="classid" style="font-size:9pt">
<%//显示一级栏目
while(rs3.next()){
out.print("<option value='"+rs3.getString("classid")+"'>"+rs3.getString("class")+"</option>");
}
//close class resultset
rs3.close();
%>
</select>
中
<input name="rename" type="submit" id="rename" value="改名">
<br>
(请选择上方相应子类别,然后输入新名字和选择类别) </p>
</div></td>
</tr>
<tr>
<td height="29" bgcolor="#D4DEF9"> </td>
</tr>
<tr>
<td bgcolor="#D4DEF9"><div align="center">新专题:
<input name="newTitle" type="text" id="newTitle" size="15">
在
<select name="psubject" size="1" id="psubject" style="font-size:9pt">
<%//显示一级栏目
while(rs4.next()){
out.print("<option value='"+rs4.getString("classid")+"'>"+rs4.getString("class")+"</option>");
}
//close class resultset
rs4.close();
%>
</select>
中
<input name="new" type="submit" id="new" value="新增">
</div></td>
</tr></form>
</table></td>
</tr>
</table>
</body>
</html>
<% stmt.close();
stmt2.close();
stmt3.close();
stmt4.close();
conn.close();
}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -