📄 edit_sort.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="connManager" scope="application" class="bbs.ConnManager" />
<%
Connection con = connManager.getConnection("mysql");
if(con==null)
{
%>对不起，现在数据库忙，请稍后再试<%
}
Statement stmt = con.createStatement();
request.setcharacterEncoding("gb2312");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
a {
font-size: 12px;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style2 {
color: #FFFFFF;
font-weight: bold;
}
.style3 {
color: #6600CC;
font-weight: bold;
}
-->
</style></head>
<body>
<%
String UserName=new String(session.getAttribute("Admin").getBytes("ISO8859_1"),"GBK");
if (UserName==null)
response.sendRedirect("admin/login.jsp");
String Sort=new String(request.getParameter("sortname").getBytes("ISO8859_1"),"GBK");
String Id=new String(request.getParameter("sortid"));
String sql = "select * from sort where Id='"+Id+"';
rs =stmt.executeQuery(sql);
String Manager=rs.getString(4);
rs.close;
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img src="../images/part1_37.gif" width="5" height="28"></td>
<td width="709" background="../images/part1_38.gif"><div align="center" class="style2">：：： 类 别 管 理 ：：：</div></td>
<td width="5"><img src="../images/part1_41.gif" width="8" height="28"></td>
</tr>
<tr>
<td width="6" height="45" background="../images/part1_44.gif"> </td>
<td>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr>
<td height="23" colspan="3" background="../images/bg_02.gif" class="text1"><div align="center" class="style3">编 辑 类 别</div></td>
</tr>
<tr>
<td class="text1" colspan="3">
<form name=form1 method="post" action="editsort_check.jsp">
<P align="center">
<P align="center">
<input name="id" type="hidden" id="id" value="<%=Id%>">
类别名称：
<input name="sortname" type="text" id="sortname" value="<%=Sort%>" size="20">
斑竹：
<select name="manager" id="manager">
<option selected><%=Manager%></option>
<%
String sql2 = "select NickName,IsManager from user_info;
rs2 =stmt.executeQuery(sql2);
while(rs.next())
{
String NickName=rs2.getString("NickName");
Boolean IsManager=rs2.getBoolean("IsManger");
if(!IsManager)
{
%>
<option ><%=NickName%></option>
<%
}
}
rs2.close();
stmt.close();
connManager.releaseConnection("mysql",con);
%>
</select>
<p align="center">
<input name="submit" type=submit value=" 确 定 ">
<INPUT name="reset" type=reset value=" 清 除 "></p>
</form></tr>
</table>
<div align="center">
</td>
<td width="5" background="../images/part1_48.gif"> </td>
</tr>
<tr>
<td width="6"><img src="../images/part1_51.gif" width="5" height="14"></td>
<td background="../images/part1_52.gif"> </td>
<td width="5"><img src="../images/part1_55.gif" width="8" height="14"></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -