📄 program.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 program 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="program.jsp">
<table border="0" width="90%" cellspacing="0" cellpadding="0" id="table2">
<tr>
<td align="right">时间段：</td>
<td align="left" height="20">
<input type="text" name="hours" size="20" value="<%=rs.getString("时间")%>"></td>
</tr>
<tr>
<td align="right">节目：</td>
<td align="left" height="20">
<input type="text" name="info" size="20" value="<%=rs.getString("节目名称")%>"></td>
</tr>
<tr>
<td align="right">主持人：</td>
<td align="left" height="20">
<input type="text" name="nj" size="20" value="<%=rs.getString("NJ")%>"></td>
</tr>
<tr>
<td align="center" colspan="2"><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 hours=new String(request.getParameter("hours").getBytes("iso-8859-1"));
String program=new String(request.getParameter("info").getBytes("iso-8859-1"));
String nj=new String(request.getParameter("nj").getBytes("iso-8859-1"));
stmt.executeUpdate("update program set 时间='"+hours+"',节目名称='"+program+"',NJ='"+nj+"' where id="+id);
response.sendRedirect("program.jsp");
}else if(action.equals("delete")){
int id=Integer.parseInt(request.getParameter("id"));
stmt.executeUpdate("delete from program where id="+id);
response.sendRedirect("program.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="program.jsp">
<table border="0" width="90%" cellspacing="0" cellpadding="0" id="table2">
<tr>
<td align="right">时间段：</td>
<td align="left" height="20">
<input type="text" name="hours" size="20"></td>
</tr>
<tr>
<td align="right">节目：</td>
<td align="left" height="20">
<input type="text" name="info" size="20"></td>
</tr>
<tr>
<td align="right">主持人：</td>
<td align="left" height="20">
<input type="text" name="nj" size="20"></td>
</tr>
<tr>
<td align="center" colspan="2"><input type="hidden" name="action" value="addinfo"><input type="submit" value="添加" name="B1"></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%}else if(action.equals("addinfo")){
String hours=new String(request.getParameter("hours").getBytes("iso-8859-1"));
String program=new String(request.getParameter("info").getBytes("iso-8859-1"));
String nj=new String(request.getParameter("nj").getBytes("iso-8859-1"));
stmt.executeUpdate("insert into program(时间,节目名称,NJ) values ('"+hours+"','"+program+"','"+nj+"')");
response.sendRedirect("program.jsp");
}
}else{
sqls="select*from program order by id desc";
ResultSet rs=stmt.executeQuery(sqls);
%>
<table border="0" width="600">
<tr>
<td width="60%">info--<a href="program.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("时间")+"--"+rs.getString("节目名称")+"--"+rs.getString("NJ")%></td>
<td><a href="program.jsp?id=<%=id%>&action=delete">删除</a></td>
<td><a href="program.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 + -