📄 default.jsp

📁 公文办理系统
💻 JSP
字号:
<%@page contentType="text/html;charset=GBK"%>
<%@include file="..\const\global.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/style.css" type="text/css">
<script language="javascript">
function openwin(id) {	
	window.open('xhzcshow.asp?id='+id,'','resizable,scrollbars,dependent,width=800,height=600');
		void 0;
}
</script>
</head>
<%
String StrMsg="";
try{
	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	sqlCon = java.sql.DriverManager.getConnection(ConnStr,ConnUser,ConnPassword);
	sqlStmt = sqlCon.createStatement();

	String userid="sysadm";
	String tree_id=new String(request.getParameter("tree_id").getBytes("8859_1"));

	String name="";
 	strSQL="select * from tree where id='"+tree_id+"'";
	sqlRst = sqlStmt.executeQuery(strSQL);
	if(sqlRst.next()){
		name=sqlRst.getString("name");
	}
	sqlRst.close();
%>

<body background="../image/backg2.gif">
<center>
<h5><%=name%>文件库管理</h5>
<form method="POST" action=""  name="search">
<table border="0" width="100%">
	<tr align="center">
		<td>【<a href='..\upload2dir\upfile1.jsp?tree_id=<%=tree_id%>&backlj=fileadm/default.jsp'>增加</a>】</td>
	</tr>  
</table>  
</form>  

<form method="POST" action="default.jsp?tree_id=<%=tree_id%>"  name=form1>  
	<table border="0" width="100%" cellspacing="1" cellpadding="5" class="main">  
      <tr align="center">   
        <td class="top">编号</td>  
        <td class="top">文件名称</td>  
        <td class="top">文件级别</td>  
        <td class="top">文件描述</td>  
		<td class="top">大小</td>
        <td class="top">上传时间</td>  
        <td class="top">查看</td>  
        <td class="top">删除</td>  
      </tr>  
<%  
	int curpage=1;			//当前页
	int page_record=30;		//每页显示的记录数
	int allpage =1;			//总页数
	int allrecord =0;		//总记录数
	   
	strSQL="select count(*) A from filedb a,ljlist b where a.mlid=b.id and a.mlid='"+tree_id+"'";
	sqlRst = sqlStmt.executeQuery(strSQL);
	//获得总页面数 
	if(sqlRst.next()){
		allrecord=sqlRst.getInt("A");
		allpage = (int)Math.ceil((allrecord+page_record-1) / page_record);
		if(allpage<1){
			allpage=1;
			}
		}
	sqlRst.close();
	//判断参数page是否为空 
	if (request.getParameter("page")==null) { 
		curpage=1; 
	} else { 
		curpage =Integer.parseInt(request.getParameter("page"));//获取传递的值，需要显示的页
		if(curpage<1){
			curpage=1;
			}
		if(curpage>allpage){
			curpage=allpage;
			}
	}

	strSQL = "select top "+((curpage-1)*page_record)+" a.id from filedb a,ljlist b where a.mlid=b.id and a.mlid='"+tree_id+"' order by a.id desc";
	strSQL= "select top "+page_record+" a.id, fname,upname,fjb,fdemo,fsize,uptime from filedb a,ljlist b where a.id not in ("+strSQL+") and a.mlid=b.id and a.mlid='"+tree_id+"' order by a.id desc";

  	//strSQL="select * from filedb a,ljlist b where a.mlid=b.id and a.mlid='"+tree_id+"' order by a.id desc";
	sqlRst = sqlStmt.executeQuery(strSQL);
	while(sqlRst.next()){
		int id=sqlRst.getInt("id");
	%>
		<tr align="center" class="bc">
			<td><%=id%></a></td>
			<td><%=sqlRst.getString("fname")%></td>
			<td><%=sqlRst.getString("fjb")%></td>	
			<td><%=sqlRst.getString("fdemo")%></td>
			<td><%=sqlRst.getInt("fsize")%>KB</td>
			<td><%=sqlRst.getDate("uptime")+" "+sqlRst.getTime("uptime")%></td>
			<td><a href="../filedb/<%=sqlRst.getString("upname")%>" target="_blank"><img src="../image/search.gif" border="0"></a>   
			</td>  
			<td><a href="javascript:del('<%=id%>')"><img src="../image/del.gif" border="0"></a></td>
		</tr>
	<%
	}
	sqlRst.close();
	%>  
	<tr><td colspan="8" align="center">		
	共<%=allrecord%>条，列出第<%if(((curpage-1)*page_record+1)>allrecord){out.print(allrecord);}else{out.print((curpage-1)*page_record+1);}%>到第<%if(curpage*page_record>allrecord){out.print(allrecord);}else{out.print(curpage*page_record);}%>条
					||&nbsp;&nbsp;
					<a href="default.jsp?tree_id=<%=tree_id%>&page=1">首页</a>
					<a href="default.jsp?tree_id=<%=tree_id%>&page=<%=curpage-1%>">上一页</a>
					<a href="default.jsp?tree_id=<%=tree_id%>&page=<%=curpage+1%>">下一页</a>
					<a href="default.jsp?tree_id=<%=tree_id%>&page=<%=allpage%>">末页</a>
					||&nbsp;&nbsp;第<%=curpage%>/<%=allpage%>页
					||&nbsp;&nbsp;转到<input type="text" name="page" size="3" value="<%=curpage%>">页
	<a href="javascript:page_submit();"><img border="0" src="../image\search.gif"></a>
	</td></tr>
    </table>  
</form>  
</center>                                  
<%      
    //关闭SQL语句对象 
    sqlStmt.close();
    //关闭数据库
    sqlCon.close();
    }catch(SQLException s) { 
        StrMsg="SQL错误信息："+s.toString()+" "+s.getErrorCode()+" "+s.getSQLState();
    }catch(Exception e) { 
        StrMsg="错误信息："+e.toString()+e.getMessage();
    }

	if(!StrMsg.equals("")){
		out.println("<font color=red>"+StrMsg+"</font>");
	}
		
%>                                  
</body>                                  
</html>                                  
                                  
<script language=javascript>                                  
function del(aa)                                  
{                                  
	del1(aa);                                  
}                           
function search()                                  
{                                  
	document.search.submit();                                  
}        
function page_submit(){
    //提交页面
    var reg =/^[0-9]{1,18}$/;
    if(reg.exec(document.form1.page.value)==null||document.form1.page.value==0) {
		alert("输入数字无效！");
		document.form1.page.focus();
		return;
	}
    else{
        document.form1.submit();
    }    
}
</script>                                  
<script language=vbscript>                                  
function del1(aa)                                  
	if MsgBox("你是否要删除这条记录？", vbQuestion + vbYesNo, "提示") = vbYes then                                  
		window.location.href ="delete.jsp?id=" &aa                                  
	end if                                  
end function                                  
</script>
⌨️ 快捷键说明

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