?? add_class.jsp
字號:
<script language=javascript>
<!--
var startTime,endTime;
var d=new Date();
startTime=d.getTime();
//-->
</script>
<html><%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
response.sendRedirect("login.jsp");
} %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<jsp:useBean id="do_class" scope="page" class="news.functions"/>
<%@ page import="java.lang.*" %>
<%ResultSet rs;%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>企業內部管理信息平臺-管理</title>
<link rel="stylesheet" href="m_style.css" type="text/css">
</head>
<body>
<div align=center>
<SCRIPT LANGUAGE=javascript>
<!--
function Juge(myform)
{
if (myform.sortName.value == "")
{
alert("分類名稱不能為空！");
myform.sortName.focus();
return (false);
}
if (myform.sortid.value == "")
{
alert("所屬分類沒有選擇！");
myform.sortid.focus();
return (false);
}
}
function SelectAll() {
for (var i=0;i<document.selform.selSortid.length;i++) {
var e=document.selform.selSortid[i];
e.checked=!e.checked;
}
}
//-->
</script>
<%if (request.getParameter("action")!=null) {//判斷是否有提交信息
do_class.del_class(request.getParameter("action"),request.getParameter("id"),request.getParameter("class"));
//調用do_class bean的del_class方法完成類別刪除操作
}
String sessionauthority = (String)session.getAttribute("authority");
%>
<table width="95%" border="0" cellspacing="1" cellpadding="3" align=center class="tableBorder">
<tr>
<th width="100" class="tableHeaderText" height=25>分類管理
</th>
</tr>
<tr>
<td class="forumrow">
<p><B>注意</B>：<BR>
①刪除分類同時將刪除該分類下所有的信息！刪除分類同時刪除下屬分類和所有記錄！ 操作時請完整填寫表單信息。<BR>
②修改分類請點擊相應的分類名稱可以對其操作</p>
</td>
</tr>
</table>
<%if (request.getParameter("act")!=null&&request.getParameter("act").equals("edit")) {//判斷是否有修改動作
String curentclass=new String(request.getParameter("curentclass").getBytes("ISO8859_1"),"GBK");
String parentclass="";
if (request.getParameter("parentclass")!=null)
parentclass=new String(request.getParameter("parentclass").getBytes("ISO8859_1"),"GBK");
// 取得文本輸入域的值，并進行編碼轉化
do_class.edit_class(request.getParameter("rootid"),request.getParameter("id"),curentclass,parentclass);
}
if (request.getParameter("act")!=null&&request.getParameter("act").equals("add")) {//判斷是否有添加動作
String curentclass=new String(request.getParameter("curentclass").getBytes("ISO8859_1"),"GBK");
// 取得文本輸入域的值，并進行編碼轉化
do_class.add_class(request.getParameter("rootid"),curentclass);
//調用do_class bean的add_class方法完成操作
}
%>
<table width="95%" border="0" cellspacing="1" cellpadding="3" align=center class="tableBorder">
<%
//若是要修改分類信息，顯示此表單
if (request.getParameter("action")!=null&&request.getParameter("action").equals("edit")){
%>
<form action ="add_class.jsp?act=edit" method=post name=form1>
<tr>
<th height=24 colspan=2><B>修改分類</th>
</tr><%
String currentclass=new String(request.getParameter("class").getBytes("ISO8859_1"),"GBK");
String id=request.getParameter("id");
rs = sqlbean.executeQuery("select * from class where class='"+currentclass+"'");
rs.first();
String parentclass=rs.getString("parentclass");
String parentid=rs.getString("parentid");
rs.close();
if (!parentid.equals("0")){
if (sessionauthority.equals("all"))//權限確認，僅總管理員列出所有條目
rs = sqlbean.executeQuery("select * from class where parentid=0");
else
rs = sqlbean.executeQuery("select * from class where parentid=0 and class='"+sessionauthority+"'");
}%>
<tr>
<td width="40%" height=30 class="forumrow">分類名稱</td>
<td width="60%" class="forumrow">
<input name="curentclass" type="text" id="curentclass" value="<%=currentclass%>" size="35">
<input type="Hidden" name="id" value='<%=id%>'>
</td>
</tr>
<tr>
<td height=30 class="forumrow"><U>所屬類別</U></td>
<td class="forumrow">
<select name=rootid>
<%if (parentid.equals("0")){%>
<option value="0">≡做為一級分類≡</option>
<input type="Hidden" name="parentclass" value='<%=currentclass%>'>
<%}else{%>
<option value="<%=parentid%>"><%=parentclass%></option>
<%while(rs.next()){ %>
<option value="<%=rs.getString("id")%>"><%=rs.getString("class")%></option>
<%}
rs.close();}%>
</select><input type="submit" name="Submit" class="button" value="修改分類">
</td>
</tr>
<tr>
<td height=24 class="forumRow"> </td>
<td class="forumRow">
</td>
</tr></form>
<%}
else{%>
<form action ="add_class.jsp?act=add" method=post name=form1>
<input type="Hidden" name="action" value='savenew'>
<tr>
<th height=24 colspan=2>添加分類</th>
</tr>
<tr>
<td width="40%" height=30 class="forumrow">分類名稱</td>
<td width="60%" class="forumrow">
<input name="curentclass" type="text" id="curentclass" value="" size="35">
</td>
</tr>
<tr>
<td height=30 class="forumrow"><U>所屬類別</U></td>
<td class="forumrow">
<select name=rootid>
<%
if (sessionauthority.equals("all")){
rs = sqlbean.executeQuery("select * from class where parentid=0");
out.println("<option value=\"0\">≡做為一級分類≡</option>");}
else
rs = sqlbean.executeQuery("select * from class where parentid=0 and class='"+sessionauthority+"'");
%>
<%while(rs.next()){
%>
<option value="<%=rs.getString("id")%>"><%=rs.getString("class")%></option>
<%}
rs.close();%>
</select><input type="submit" name="Submit" class="button" value="添加分類">
</td>
</tr>
<tr>
<td height=24 class="forumRow"> </td>
<td class="forumRow">
</td>
</tr></form>
<%}%>
<tr height=23 align=center><td colspan=2 class=forumHeaderBackgroundAlternate>分類管理</td></tr>
<%
if (sessionauthority.equals("all"))
rs = sqlbean.executeQuery("select * from class where parentid=0");
else
rs = sqlbean.executeQuery("select * from class where parentid=0 and class='"+sessionauthority+"'");
while (rs.next()) {%>
<tr height=23><td colspan=2 class=forumRow> <a href="editchoose.jsp?root=yes&class=<%=rs.getString("class")%>"><strong><%=rs.getString("class")%></strong></a>
<a href="add_class.jsp?action=delroot&id=<%=rs.getString("id")%>&parentclass=<%=rs.getString("class")%>" onclick="{if(confirm('此操作將刪除本分類下的所有二級分類以及此分類下的所有記錄信息！\n \n 刪除后將不能恢復，您確定執行的操作嗎?')){this.document.myform.submit();return true;}return false;}"><u>刪除</u></a>/<a href="add_class.jsp?action=edit&id=<%=rs.getString("id")%>&class=<%=rs.getString("class")%>">修改</a>一級分類
<%ResultSet rs2 = sqlbean.executeQuery("select * from class where parentclass='"+rs.getString("class")+"'");
while (rs2.next()) {%>
<a href="add_class.jsp?action=delsec&id=<%=rs2.getString("id")%>&class=<%=rs2.getString("class")%>" onclick="{if(confirm('此操作將刪除本分類下所有記錄信息！\n \n刪除后將不能恢復，您確定執行的操作嗎?')){this.document.myform.submit();return true;}return false;}">刪除</a>/<a href="add_class.jsp?action=edit&id=<%=rs2.getString("id")%>&class=<%=rs2.getString("class")%>">修改</a><font color=red><%=rs2.getString("class")%></font>
<%}
rs2.close();%></td></tr>
<%}
rs.close();%>
</table>
</div>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -