📄 class_update.jsp
字号:
<%@ page contentType="text/html; charset=GBK" language="java" errorPage="" %>
<%@include file ="../../incs/ChkPwd.jsp"%>
<%@include file="../../ConnDB.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>类别修改</title>
<link href="../style/Admin_Style.css" rel="stylesheet" type="text/css" />
<script language="javascript">
function form1_onsubmit()
{
if (document.form1.ClassName.value=="")
{
window.alert("请输入分类栏目名称");
return false;
}
}
</script>
</head>
<body>
<br /> <a href="Class_Manage.jsp">类别管理</a> | <a href="Class_Add.jsp">类别添加</a>
<hr color="#0099FF" size="1" />
<%
if (request.getParameter("update_class")!=null)
{
int ID_Class_U=Integer.parseInt(request.getParameter("ID_Class"));
String ClassName=new String(request.getParameter("ClassName").getBytes("iso-8859-1"));
int OrderID=Integer.parseInt(request.getParameter("OrderID"));
String Readme=new String(request.getParameter("Readme").getBytes("iso-8859-1"));
int View=Integer.parseInt(request.getParameter("View"));
int ParentID=Integer.parseInt(request.getParameter("ParentID"));
Statement stmt_U=conn.createStatement();
String sql_U="update tDT_WebDirClass set fClassName='"+ClassName+"',fOrderID="+OrderID+",fReadme='"+Readme+"',fView="+View+",fParentID="+ParentID+" where fID_Class="+ID_Class_U;
int cg=stmt_U.executeUpdate(sql_U);
if (cg>0)
{
out.print("<p align='center'>网址类别：["+ ClassName +"] 修改成功</p>");
}else{
out.print("<p align='center'>网址类别：["+ ClassName +"] 修改不成功</p>");
}
}
if (request.getParameter("ID_Class")!=null)
{
int ID_Class=Integer.parseInt(request.getParameter("ID_Class"));
Statement stmt_Class=conn.createStatement();
String sql_C="Select * from tDT_WebDirClass where fID_Class="+ ID_Class;
ResultSet rsClass=stmt_Class.executeQuery(sql_C);
rsClass.next();
String fClassName=rsClass.getString("fClassName");
int fView=rsClass.getInt("fView");
int fParentID=rsClass.getInt("fParentID");
int fOrderID=rsClass.getInt("fOrderID");
String fReadme=rsClass.getString("fReadme");
%>
<form id="form1" name="form1" method="post" action="" onsubmit="return form1_onsubmit()">
<table width="550" border="0" align="center">
<tr>
<td>分类栏目名称：</td>
<td><input type="text" name="ClassName" value=<%=fClassName%> /> * 修改栏目名会导致栏目内网址不对应</td>
</tr>
<tr>
<td>所属类别：</td>
<td>
<select name="ParentID">
<option value="0" <%if (fParentID==0) {%>selected="selected"<%}%> >根目录</option>
<%
Statement stmt_ClassList=conn.createStatement();
String sql_Clist="Select * from tDT_WebDirClass";
ResultSet rsClassList=stmt_Class.executeQuery(sql_Clist);
while (rsClassList.next())
{
int fID_Class_List=rsClassList.getInt("fID_Class");
%>
<option value="<%=fID_Class_List%>" <%if (fParentID==fID_Class_List) {%>selected="selected"<%}%> ><%=rsClassList.getString("fClassName")%></option>
<%
}
rsClassList.close();
stmt_ClassList.close();
%>
</select>
</td>
</tr>
<tr>
<td>排序ID：</td>
<td><input name="OrderID" type="text" value="<%=fOrderID%>" /></td>
</tr>
<tr>
<td>显示设定</td>
<td><select name="View" id="View">
<option value="0" <%if (fView==0) {%>selected="selected"<%}%> >首页不显示</option>
<option value="-1" <%if (fView==-1) {%>selected="selected"<%}%> >首页“酷站大全”栏目中显示</option>
<option value="1" <%if (fView==1) {%>selected="selected"<%}%> >首页左侧侧栏显示</option>
</select>
* 是否在首页“网址大全”显示 </td>
</tr>
<tr>
<td>栏目简介：</td>
<td><textarea name="Readme" cols="60" rows="6" ><%=fReadme%></textarea></td>
</tr>
<tr>
<td><input type="hidden" name="ID_Class" value="<%=ID_Class%>" />
<input type="hidden" name="update_class" value="ok" />
</td>
<td><input type="submit" name="Submit" value="修改" />
<input type="reset" name="Reset" value="重置" /></td>
</tr>
</table>
</form>
<p> </p>
<%
}
rsClass.close();
stmt_Class.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -