📄 admin_uploadfile.jsp

📁 一个用jsp写的完整的论坛源代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ include file="INC/const.jsp"%>
<%@ page import = "java.util.Vector,com.bcxy.util.FileUtil,com.bcxy.util.SysUtil,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>
<%
	int rid = ParamUtil.getInt(request, "id", 0);
	if(rid != 0){
		String filename = ParamUtil.getString(request, "filename" ,"");
		FileUtil.delFile(SysUtil.getRealPath() + "/WEB-INF/upload/" + filename);
		jw.executeUpdate("update fileupload set flag=0 where id=" + rid);
	}
	String sql = "select id, filename, fileext, filesize, uptime, name, downcount from " + BBSConst.TABLE_FILEUPLOAD + " where flag=1 order by uptime 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" cellpadding="4" width=<%=tableWidth%> bgcolor=<%=tableBackColor%>>
        <tr bgcolor="<%=tableTitleColor%>">
          <%--<td width="46" align="center" height="20"><strong>ID号</strong></td>--%>
          <td align="center" height="20"><strong>文件名</strong></td>
          <%--<td width="40" align="center"><strong>扩展名</strong></td>--%>
          <td width="100" align="center"><strong>文件大小</strong></td>
          <td width="150" align="center"><strong>上传时间</strong></td>  
          <td width="60" align="center"><strong>下载次数</strong></td>                  
          <td width="40" align="center"> <strong>操 作</strong> </td>
        </tr>
<%
		while(jw.next())
		{
			String name = jw.get(6);
%>
        <tr bgcolor=<%=tableBodyColor%>>
          <%--<td height="23" width="46"><p align="center"><%=jw.get(1)%></td>--%>
          <td ><p align="center"><a href=/bbs/file_download.jsp?filename=<%=name%> target=_blank><%=jw.get(2)%></a></td>
          <%--<td ><p align="center"><%=jw.get(3)%></td>--%>
          <td ><p align="center"><%=jw.get(4)%> Bytes</td>
          <td ><p align="center"><%=jw.get(5)%></td>
          <td ><p align="center"><%=jw.get(7)%></td>
          <td width="40" align="center"><a href="?id=<%=jw.get(1)%>&filename=<%=name%>" onclick="return window.confirm('确定要删除吗？');">删除</a></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 + -