smartupload实现 jsp页面上传文件将文件以二进制形式保存在数据库

最新推荐文章于 2021-02-24 08:25:51 发布

原创最新推荐文章于 2021-02-24 08:25:51 发布 · 961 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个使用jspSmartUpload组件将文件上传至数据库的示例代码。该示例展示了如何初始化上传组件、执行文件上传过程，并将文件保存为数据库中的二进制数据。此外还介绍了如何更新数据库中的文件名。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@page import="com.sys.utils.DBConnection"%>
<%@ page language="java" import="java.sql.*,com.jspsmart.upload.*"%>

<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />

<HTML>


<BODY BGCOLOR="white">

<H1>jspSmartUpload : Sample 4</H1>
<HR>

<%

// Variables
int count=0;

Connection con = DBConnection.connection();

// SQL Request
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT * FROM tfiles WHERE ID=1");

// if the resultset is not null
if (rs.next()){

// Initialization
mySmartUpload.initialize(pageContext);

// Upload
mySmartUpload.upload();

// upload file in the DB if this file is not missing
if (!mySmartUpload.getFiles().getFile(0).isMissing()){

try {

rs.updateString("FILENAME",mySmartUpload.getFiles().getFile(0).getFileName());

// Add the current file in the DB field
mySmartUpload.getFiles().getFile(0).fileToField(rs,"FILE");

// Update
rs.updateRow();
count++;

} catch(Exception e) {
out.println("An error occurs : " + e.toString());
}

}

}

// Display the number of files uploaded
out.println(count + " file(s) uploaded in the database.");

rs.close();
stmt.close();
con.close();

%>

</BODY>
</HTML>