?? admin.jsp
字號:
<%//@ page contentType="text/html;charset=gb2312"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link href="index.css" rel="stylesheet" type="text/css">
<META content="MSHTML 5.00.3315.2870" name=GENERATOR></HEAD>
<BODY leftMargin=0 topMargin=5>
<%@ page import="java.sql.*"%>
<jsp:useBean id="db" scope="page" class="guest.liupangzii"/>
<jsp:useBean id="server" scope="page" class="guest.page"/>
<% String ac=request.getParameter("ac");
String a=request.getParameter("a");
String b=request.getParameter("b");
String ids=request.getParameter("ids");
if(ids!=null && ac!=null && ac.equals("up")){//修改----------
/*String a1=request.getParameter("qq");
String a2=request.getParameter("home");
String a3=request.getParameter("title");
String a4=request.getParameter("body"); */
String a5=request.getParameter("hf");
if(db.executeUpdate("update dns_flash_guest set hf='"+a5+"' where id="+ids)){
out.print(server.codestring("<center>修改成功"));
}else{
out.print(server.codestring("<center>修改出錯"));
}
out.print(server.codestring("<br><a href=admin.jsp>返回</a></center>"));
db.connclose();
return;
}//修改----------
if(ids!=null && ac!=null && ac.equals("del")){//刪出----------
if(db.executeUpdate("delete from dns_flash_guest where id="+ids)){
out.print(server.codestring("<center>刪出成功"));
}else{
out.print(server.codestring("<center>刪出出錯"));
}
out.print(server.codestring("<br><a href=admin.jsp>返回</a></center>"));
db.connclose();
return;
}//刪出----------
if(ac!=null && ac.equals("exit")){
db.connclose();
session.removeAttribute("admin");
response.sendRedirect("admin.jsp");
}
if(ac!=null && ac.equals("admins") && a!=null && b!=null){ //管理認證
String ad="admin",pw="admin";
if(ad.equals(a) && pw.equals(b)){
db.connclose();
session.setAttribute("admin",ad);
response.sendRedirect("admin.jsp");
}else{
out.print(server.codestring("密碼或是用戶名錯誤"));
}
db.connclose();
return;
}//管理認證
String admin=(String)session.getAttribute("admin");
if(admin==null){
db.connclose();
%>
<form name="form1" method="post" action="admin.jsp?ac=admins">
<table width="200" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#BEBEBE">
<tr bgcolor="#CCCCCC">
<td height="25" colspan="2"> 留言管理</td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="53" align="right">用戶名：</td>
<td width="132"><input name="a" type="password" id="a" size="20" maxlength="100"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td align="right">密碼：</td>
<td><input name="b" type="password" id="b" size="20" maxlength="100"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td> </td>
<td><input type="submit" name="Submit" value="管理"></td>
</tr>
</table>
</form>
<% return; }
if(admin!=null && ac==null){
%><br><br><br>
<table width="600" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#999999">
<tr>
<td width="437" height="20" bgcolor="#CCCCCC"><a href="admin.jsp?ac=exit">退出管理</a></td>
<td width="42" align="center" bgcolor="#CCCCCC">ID</td>
<td width="47" align="center" bgcolor="#CCCCCC">修改</td>
<td width="45" align="center" bgcolor="#CCCCCC">刪出</td>
</tr>
<% ResultSet rs=db.executeQuery("select count(*) as t from dns_flash_guest");
int row=0,pagesize=30,pagecount=1;
String ejb;
ejb=request.getParameter("ejb");
if(rs.next()){
row=rs.getInt("t");
}
pagecount=(row+pagesize-1)/pagesize;
rs.close(); rs=null;
String titles;
int id=0;
ResultSet rs2=db.executeQuery("select * from dns_flash_guest order by id desc");
rs2.absolute(server.absolutepage(row,pagesize,ejb));
for(int i=0;i<pagesize;i++){
titles=server.codestring(rs2.getString("title"));
id=rs2.getInt("id");
%>
<tr>
<td height="20" bgcolor="#CCCCCC"> <%=titles%>;</td>
<td align="center" bgcolor="#CCCCCC"><%= id %></td>
<td align="center" bgcolor="#CCCCCC"><a href="admin.jsp?ac=view&ids=<%= id %>">VIEW</a></td>
<td align="center" bgcolor="#CCCCCC"><a href="admin.jsp?ac=del&ids=<%= id %>">DELETE</a></td>
</tr>
<%
if(!rs2.next())break;
}
rs2.close(); rs2=null;
db.connclose();
%>
<tr align="right">
<td height="25" colspan="4" bgcolor="#CCCCCC">
<%String pagename="admin.jsp?";
out.print(server.codestring(server.pages(pagecount,ejb,pagesize,pagename)+" 一共"+row+"條記錄"));
%>
</td>
</tr>
</table>
<% return; }
if(ac!=null && ac.equals("view")){
ResultSet rsx=db.executeQuery("select *from dns_flash_guest where id="+ids);
rsx.next();
String qq=rsx.getString("icq");
String home=rsx.getString("home");
String title=rsx.getString("title");
String bodys=rsx.getString("body");
String hfs=rsx.getString("hf");
rsx.close(); rsx=null;
db.connclose();
db=null;
%>
<form name="form1" method="post" action="admin.jsp?ac=up&ids=<%=ids%>">
<table width="400" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#BEBEBE">
<tr bgcolor="#CCCCCC">
<td height="25" colspan="2"> 回復留言 <a href="admin.jsp">返回</a></td>
</tr>
<tr bgcolor="#CCCCCC">
<td align="right">QQ：</td>
<td><input name="qq" type="text" id="qq" value="<%=qq%>" size="40" maxlength="100"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td align="right">網址：</td>
<td><input name="home" type="text" id="home" value="<%=home%>" size="40" maxlength="100"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="61" align="right">標題：</td>
<td width="324"><input name="title" type="text" id="title" value="<%=server.codestring(server.Htmlencode(title))%>" size="40" maxlength="200"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td align="right">內容：</td>
<td><textarea name="body" cols="50" rows="10" id="body"><%=server.codestring(server.Htmlencode(bodys))%></textarea></td>
</tr>
<tr bgcolor="#CCCCCC">
<td align="right">回復：</td>
<td><textarea name="hf" cols="50" rows="7" id="hf"><%=server.codestring(hfs)%></textarea></td>
</tr>
<tr bgcolor="#CCCCCC">
<td> </td>
<td><input type="submit" name="Submit2" value="回復"></td>
</tr>
</table>
</form>
<%
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -