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