如何用JSP实现文件的上传和下载，要对数据库进行什么操作？
刚刚学jsp新人求大神指导jspsmartupload组件已经配好了<%@pagecontentType="text/html;charset=gb2312"langua...
刚刚学jsp 新人 求大神指导 jspsmartupload组件已经配好了
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="com.ConnDB" />
<%
String sql="SELECT * FROM tb_file";
ResultSet rs=conn.stmt.executeQuery(sql);%>
<html>
<head>
<title>文件上传与下载</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/style.css" rel="stylesheet">
</head>
<body>
<table width="620" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="73" colspan="3" background="images/title.jpg"> </td>
</tr>
<tr>
<td width="25" rowspan="2" align="center" valign="top" background="images/left_a.jpg"> </td>
<td width="575" align="center" valign="top"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#9A0000">
<tr>
<td width="63%" height="27" align="center" bgcolor="#FFFFFF">文件名 </td>
<td width="22%" align="center" bgcolor="#FFFFFF">文件大小</td>
<td width="15%" align="center" bgcolor="#FFFFFF">下载</td>
</tr>
<%
String name="";
while(rs.next()){
name=rs.getString("name");
%>
<tr>
<td height="27" align="center" bgcolor="#FFFFFF"> <%=name%></td>
<td align="center" bgcolor="#FFFFFF"> <%=rs.getInt("fileSize")%></td>
<td align="center" bgcolor="#FFFFFF"> <a href="download.jsp?filename=<%=name%>">下载</a></td>
</tr>
<%}%>
</table></td>
<td width="20" rowspan="2" background="images/right.jpg"> </td>
</tr>
<tr>
<td height="30" align="right" valign="bottom"><input name="Submit" type="button" class="btn_bg" value="上传文件" onClick="window.open('upFile.jsp','','width=350,height=150');">
</td>
</tr>
<tr>
<td height="30" colspan="3" background="images/bottom.jpg"> </td>
</tr>
</table>
</body>
</html>
这是首页的代码 书上说 在上面的代码中 需要对数据库进行操作。 应该怎么操作呀 展开
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="com.ConnDB" />
<%
String sql="SELECT * FROM tb_file";
ResultSet rs=conn.stmt.executeQuery(sql);%>
<html>
<head>
<title>文件上传与下载</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/style.css" rel="stylesheet">
</head>
<body>
<table width="620" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="73" colspan="3" background="images/title.jpg"> </td>
</tr>
<tr>
<td width="25" rowspan="2" align="center" valign="top" background="images/left_a.jpg"> </td>
<td width="575" align="center" valign="top"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#9A0000">
<tr>
<td width="63%" height="27" align="center" bgcolor="#FFFFFF">文件名 </td>
<td width="22%" align="center" bgcolor="#FFFFFF">文件大小</td>
<td width="15%" align="center" bgcolor="#FFFFFF">下载</td>
</tr>
<%
String name="";
while(rs.next()){
name=rs.getString("name");
%>
<tr>
<td height="27" align="center" bgcolor="#FFFFFF"> <%=name%></td>
<td align="center" bgcolor="#FFFFFF"> <%=rs.getInt("fileSize")%></td>
<td align="center" bgcolor="#FFFFFF"> <a href="download.jsp?filename=<%=name%>">下载</a></td>
</tr>
<%}%>
</table></td>
<td width="20" rowspan="2" background="images/right.jpg"> </td>
</tr>
<tr>
<td height="30" align="right" valign="bottom"><input name="Submit" type="button" class="btn_bg" value="上传文件" onClick="window.open('upFile.jsp','','width=350,height=150');">
</td>
</tr>
<tr>
<td height="30" colspan="3" background="images/bottom.jpg"> </td>
</tr>
</table>
</body>
</html>
这是首页的代码 书上说 在上面的代码中 需要对数据库进行操作。 应该怎么操作呀 展开
1个回答
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
