81,095
社区成员
发帖
与我相关
我的任务
分享
<!--
文件名:download.jsp
-->
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"
errorPage=""%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>下载文件列表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table width="99%" cellpadding=0 cellspacing=0 align=center>
<form name=form method=post action="download.jsp">
关键词:<input type=text size=12 name=key>
<input type=submit name=submit value="查询" >
</td></tr>
</form>
</table>
<p> </p>
<p align="center">下载文件列表</p>
<table width="75%" border="1" align="center">
<FORM METHOD="POST" ACTION="do_upload.jsp"
ENCTYPE="multipart/form-data">
<%
try{
String sqlStr;
String key;
if(request.getParameter("key")==null || request.getParameter("key").trim()=="")
sqlStr="select top 3 * from uploadfileinfo order by uploadtime desc";
else
{
key=request.getParameter("key");
sqlStr="select * from uploadfileinfo where filename like '%"+key
+"%' order by uploadtime desc";
}
Connection con;
ResultSet rs;
Statement stmt;
//数据库登录用户和密码
String user="sa";
String password="sa";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:jspbook";
con=DriverManager.getConnection(url,user,password);
//创建一个jdbc声明
stmt=con.createStatement();
rs=stmt.executeQuery(sqlStr);
while(rs.next())
{
String dfilename=rs.getString("filename");
%>
<tr><td align="center" >
<a href="do_download.jsp?dfilename=<%=dfilename%>"><%=dfilename%></a>
</td></tr>
<%
}
}
catch(Exception e){
out.println(e);
}
%>
</table>
</FORM>
</body>
</html>