📄 admin_log.jsp

📁 一个用jsp写的完整的论坛源代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ include file="INC/const.jsp"%>
<%@ page import = "java.util.Vector,
					com.bcxy.bbs.forum.admin.*"%>
<jsp:useBean id="jw" scope="page" class="com.bcxy.db.JdbcWrapper"/>					
<title><%=forumName%>--管理页面</title>
<link rel="stylesheet" type="text/css" href="forum.css">

<BODY bgcolor="#ffffff" alink="#333333" vlink="#333333" link="#333333" topmargin="20">
<%
	try{
		if(session.getAttribute("adminFlag")==null)
			throw new Exception("本页面为管理员专用，请<a href=elogin.jsp>登陆管理</a>后进入。");	
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tableWidth%> bgcolor=<%=tableBackColor%> align=center>
  <tr>
    <td>
      <table cellpadding=3 cellspacing=1 border=0 width=100%>
        <tr bgcolor='<%=tableTitleColor%>'>
        <td align=center colspan="2">欢迎<b>
<%=session.getAttribute("adminName")%></b>进入管理页面
        </td>
        </tr>
            <tr bgcolor=<%=tableBodyColor%>>
              <td width="20%" valign=top>
<%@include file="admin_left.jsp"%>
	      </td>
              <td width="80%" valign=top>
<%
	//
	String act = ParamUtil.getString(request, "action", "");
	if(!"".equals(act) && "clear".equals(act)){
		jw.executeUpdate("delete from log");
	}
	String sql = "select l_id, l_username, l_content, l_url, l_addtime from " + BBSConst.TABLE_LOG + " order by l_id desc";
	int cPage = ParamUtil.getInt(request, "p", 1);
	jw.executeLimitQuery(sql,(cPage-1)*20, 20);
%>

<div align="center"><center>

<form method=Post action="admin_log.jsp" onsubmit="this.action.value='clear';">
<input type="hidden" name="action" value="">
<div align="center">
<table border="0" cellspacing="1"  width=<%=tableWidth%> bgcolor=<%=tableBackColor%> cellpadding="0">
        <tr bgcolor="<%=tableTitleColor%>">
          <td width="46" align="center" height="20"><strong>ID号</strong></td>
          <td width="40" align="center"><strong>用户名</strong></td>
          <td width="40" align="center"><strong>操作</strong></td>
          <td width="100" align="center"><strong>URL</strong></td>
          <td width="100" align="center"><strong>操作时间</strong></td>                    
          <td width="68" align="center"><input type='submit'  value='清空日志' onclick="return window.confirm('确定要清空日志吗？');"></td>
        </tr>
<%
		while(jw.next())
		{
			String url = jw.get(4);
%>
        <tr bgcolor=<%=tableBodyColor%>>
          <td height="23" width="46"><p align="center"><%=jw.get(1)%></td>
          <td ><p align="center"><%=jw.get(2)%></td>
          <td ><p align="center"><%=jw.get(3)%></td>
          <td ><p align="center"><a href=/bbs/<%=url%> target=_blank><%=url%></a></td>
          <td ><p align="center"><%=jw.get(5)%></td>
          <td width="68"><p align="center">&nbsp;</td>
        </tr>
<% 
		}
%>
      </table>
      </center></div><br>
<%
	int totalPages = jw.getPages();
	out.println("共" + jw.getAllRows() + "条记录 第" +cPage+"/"+totalPages+" 页　");
	if (cPage==1|| totalPages==1 ){
		out.println("<font color=gray>首页　前页</font>");
	}else{
		out.println("<a href=?p=1>首页</a>　<a href=?p="+(cPage-1)+">前页</a>");
	}
		
	if (cPage==totalPages|| totalPages==1){
		out.println("　<font color=gray>后页　尾页</font>");
	}else{
		out.println("　<a href=?p="+(cPage+1)+">后页</a>　<a href=?p="+totalPages+">尾页</a>");
	}		
%>
	      </td>
            </tr>
        </table>
        </td>
    </tr>
</table>
<%
}
catch(Exception e){
	String errMsg=e.getMessage();
	%>
	<%@include file="INC/error.jsp"%>
	<%
}%>
<%@ include file="foot.jsp"%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -