📄 default.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 fname="";
String fjb="";
String fdemo="";
String userid = (String)session.getAttribute("Loginuser");
//out.println(userid);
int filejb=0;
strSQL="select * from userlist where userid='"+userid+"'";
sqlRst = sqlStmt.executeQuery(strSQL);
if(sqlRst.next()){
filejb=sqlRst.getInt("filejb");
}
sqlRst.close();
String tree_id=new String(request.getParameter("tree_id").getBytes("8859_1"));
if(!request.getQueryString().equals("tree_id=0101")){
fname=new String(request.getParameter("fname").getBytes("8859_1"));
fjb=new String(request.getParameter("fjb").getBytes("8859_1"));
fdemo=new String(request.getParameter("fdemo").getBytes("8859_1"));
}
String ttj="";
ttj=" and fjb<="+filejb;
if(!fname.equals("")){
ttj=ttj+" and fname like '%"+fname+"%'";
}
if(!fjb.equals("")){
ttj=ttj+" and fjb="+fjb+"";
}
if(!fdemo.equals("")){
ttj=ttj+" and fdemo like '%"+fdemo+"%'";
}
//out.println(ttj);
%>
<body background="../../image/backg2.gif">
<center>
<h5>文件检索</h5>
<form method="POST" action="default.jsp?tree_id=" name="search">
<input type='hidden' name='page' value='1'>
<table border="0" width="100%">
<tr align="center">
<td width='20%'>文件名称:</td>
<td width='40%'><input type="text" name="fname" size=40 value="<%=fname%>"></td>
<td width='40%' rowspan=3><a href="javascript:document.search.submit();"><img src="../../image/search.gif" border="0"></a></td>
</tr>
<tr align="center">
<td>文件级别:</td>
<td><SELECT NAME="fjb"><option value=''>--------------------------------------</option>
<%
strSQL="select * from filejb order by jbbh";
sqlRst = sqlStmt.executeQuery(strSQL);
while(sqlRst.next()){
int jbbh=sqlRst.getInt("jbbh");
String jbname=sqlRst.getString("jbname");
if(Integer.toString(jbbh).equals(fjb)){
out.println("<option value="+jbbh+" selected>"+jbbh+"*"+jbname+"</option>");
}
else{
out.println("<option value="+jbbh+">"+jbbh+"*"+jbname+"</option>");
}
}
sqlRst.close();
%></SELECT></td>
</tr>
<tr align="center">
<td>文件描述:</td>
<td><input type="text" name="fdemo" size=40 value="<%=fdemo%>"></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>
</tr>
<%
int curpage=1; //当前页
int page_record=30; //每页显示的记录数
int allpage =1; //总页数
int allrecord =0; //总记录数
strSQL="select count(*) A from filedb where 1=1 "+ttj+" ";
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)+" id from filedb where 1=1 "+ttj+" order by id desc";
strSQL= "select top "+page_record+" * from filedb where id not in ("+strSQL+") and 1=1 "+ttj+" order by id desc";
//strSQL="select * from filedb where 1=1 "+ttj+" order by 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>
</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);}%>条
||
<a href="javascript:document.search.page.value=1;document.search.submit();">首页</a>
<a href="javascript:document.search.page.value=<%=curpage-1%>;document.search.submit();">上一页</a>
<a href="javascript:document.search.page.value=<%=curpage+1%>;document.search.submit();">下一页</a>
<a href="javascript:document.search.page.value=<%=allpage%>;document.search.submit();">末页</a>
|| 第<%=curpage%>/<%=allpage%>页
|| 转到<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 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.search.page.value=document.form1.page.value;
document.search.submit();
}
}
</script> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -