?? 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 + -