📄 editinfo.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="top.jsp"%>
<%@ include file="class.jsp"%>
<html>
<head>
<title>公告信息</title>
<style>
table{
font-size:9pt;
}
</style>
</head>
<body bgcolor="#ffffff" topmargin="0" leftmargin="0">
<center>
<table border="0" width="760" cellspacing="0" cellpadding="1" bgcolor="#C0C0C0" id="table1">
<tr>
<td height="21">
<p align="center"><b>DQUS电台管理页面</b></td>
</tr>
<tr>
<td align="center" bgcolor="#eeeeee">
<table border="0" width="760">
<tr>
<td width="50%"><form name="nj" onSubmit="return check()" method="POST" action="addnj.jsp">NJ名：<input type="text" name="njname" size="10">密码：<input type="password" name="njpass" size="10"><select size="1" name="type">
<option value="0">普通NJ</option>
<option value="1">电台管理员</option>
</select>
<input type="submit" value="添加" name="B1"></p>
</form>
</td>
</tr>
</table>
<table border="0" width="90%">
<tr>
<td width="10%"><a href="program.jsp">节目列表</a></td>
<td width="10%"><a href="editinfo.jsp">公告信息</a></td>
<td width="10%"><a href="quit.jsp">注销</a></td>
<td></td>
</tr>
</table>
<%
String action=request.getParameter("action");
String sqls=null;
if(action!=null){
if(action.equals("edit")){
int id=Integer.parseInt(request.getParameter("id"));
sqls="select*from info where id="+id;
ResultSet rs=stmt.executeQuery(sqls);
while(rs.next()){
%>
<table align="center" border="0" width="400" cellspacing="0" cellpadding="0" id="table1">
<tr>
<td align="center">
<form method="POST" action="editinfo.jsp">
<table border="0" width="90%" cellspacing="0" cellpadding="0" id="table2">
<tr>
<td align="center"><textarea rows="15" name="content" cols="40"><%=rs.getString("info")%></textarea></td>
</tr>
<tr>
<td align="center"><input type="submit" value="修改" name="B1">
<input type="hidden" name="action" value="addedit">
<input type="hidden" name="id" value="<%=id%>"></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%}
rs.close();
}else if(action.equals("addedit")){
int id=Integer.parseInt(request.getParameter("id"));
String contents=new String(request.getParameter("content").getBytes("iso-8859-1"));
stmt.executeUpdate("update info set info='"+contents+"' where id="+id);
response.sendRedirect("editinfo.jsp");
}else if(action.equals("delete")){
int id=Integer.parseInt(request.getParameter("id"));
stmt.executeUpdate("delete from info where id="+id);
response.sendRedirect("editinfo.jsp");
}else if(action.equals("add")){%>
<table align="center" border="0" width="400" cellspacing="0" cellpadding="0" id="table1">
<tr>
<td align="center">
<form method="POST" action="editinfo.jsp">
<table border="0" width="90%" cellspacing="0" cellpadding="0" id="table2">
<tr>
<td align="center"><textarea rows="15" name="content" cols="40"></textarea></td>
</tr>
<tr>
<td align="center"><input type="submit" value="添加" name="B1">
<input type="hidden" name="action" value="addinfo">
</td>
</tr>
</table>
</form></td>
</tr>
</table>
<%}else if(action.equals("addinfo")){
String contents=new String(request.getParameter("content").getBytes("iso-8859-1"));
stmt.executeUpdate("insert into info (info) values ('"+contents+"')");
response.sendRedirect("editinfo.jsp");
}
}else{
sqls="select*from info order by time desc";
ResultSet rs=stmt.executeQuery(sqls);
%>
<table border="0" width="600">
<tr>
<td width="60%">info--<a href="editinfo.jsp?action=add">添加信息</a></td>
<td width="20%">删除</td>
<td width="20%">编辑</td>
</tr>
<%
while(rs.next()){
String id=rs.getString("id");
%>
<tr>
<td><%=rs.getString("info")%></td>
<td><a href="editinfo.jsp?id=<%=id%>&action=delete">删除</a></td>
<td><a href="editinfo.jsp?id=<%=id%>&action=edit">编辑</a></td>
</tr>
<%}
rs.close();
%>
</table>
<%}%>
</td></tr></table>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -