使用jsp将多种文件格式上传到服务器，并将路径存储在数据库中 [英] uploading multiple file formats to a server using jsp and store the path in database
问题描述
我想将文件(所有格式)上载到服务器并将文件位置存储在数据库中(MySQL)我尝试使用长blob格式将文件(所有格式)存储在数据库中，但它不接受文件大小不超过1kb，并且仅接受文本文件. 这是我的html代码
i want to upload files(all format) to a server and store the file location in a database(MySQL)i tried storing the files(all format)in a database using long-blob format,but it is not accepting the file size of not more-then 1kb and it accepts only text file. here is my html code
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<form enctype="multipart/form-data" action="upload.jsp" method="post">
<br/><br/><br/>
<center>
<table border="0" bgcolor=#ccFDDEE>
<tr>
<td colspan="2" align="center"><b>UPLOAD THE FILE</b></td>
</tr>
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td><b>Choose the file To Upload:</b></td>
<td><INPUT NAME="file" TYPE="file"> </td>
</tr>
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Send File"> </td>
</tr>
<table>
</center>
</form>
</body>
</html>
这是我的jsp代码，用于将文件存储到数据库(使用长blob).
here is my jsp code for storing files to a database(using long-blob).
<%@ page import="java.io.*,java.sql.*" %>
<%
String saveFile="";
String contentType = request.getContentType();
if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0)) {
DataInputStream in = new DataInputStream(request.getInputStream());
int formDataLength = request.getContentLength();
byte dataBytes[] = new byte[formDataLength];
int byteRead = 0;
int totalBytesRead = 0;
while (totalBytesRead < formDataLength) {
byteRead = in.read(dataBytes, totalBytesRead,formDataLength);
totalBytesRead += byteRead;
}
String file = new String(dataBytes);
saveFile = file.substring(file.indexOf("filename=\"") + 10);
saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1,saveFile.indexOf("\""));
int lastIndex = contentType.lastIndexOf("=");
String boundary = contentType.substring(lastIndex + 1,contentType.length());
int pos;
pos = file.indexOf("filename=\"");
pos = file.indexOf("\n", pos) + 1;
pos = file.indexOf("\n", pos) + 1;
pos = file.indexOf("\n", pos) + 1;
int boundaryLocation = file.indexOf(boundary, pos) - 4;
int startPos = ((file.substring(0, pos)).getBytes()).length;
int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;
saveFile="/home/adapco/Desktop"+saveFile;
File ff = new File(saveFile);
FileOutputStream fileOut = new FileOutputStream(ff);
fileOut.write(dataBytes, startPos, (endPos - startPos));
fileOut.flush();
fileOut.close();
%>
<br>
<table border="2">
<tr>
<td><b>You have successfully upload the file by the name of:</b><% out.println(saveFile);%></td>
</tr>
</table>
<%
Connection connection = null;
String connectionURL = "jdbc:mysql://localhost:3306/ksa";
ResultSet rs = null;
PreparedStatement psmnt = null;
FileInputStream fis;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "root");
File f = new File(saveFile);
psmnt = connection.prepareStatement("insert into file(file_data) values(?)");
fis = new FileInputStream(f);
psmnt.setBinaryStream(1, (InputStream)fis, (int)(f.length()));
int s = psmnt.executeUpdate();
if(s>0) {
System.out.println("Uploaded successfully !");
}
else{
System.out.println("unsucessfull to upload file.");
}
}
catch(Exception e){
e.printStackTrace();
}
}
%>
现在我必须将文件存储到服务器并存储其到db的路径，或者使用长blob类型将文件(所有格式)存储在数据库中.使用Netbeans和glassfish服务器(Red Hat Linux)来存储该文件.给我一些想法.
now i have to store the files either to a server and storing its path to db or to store the files(all formats)in a database using long-blob type.iam using netbeans and glassfish server(red hat linux).give me some idea.
推荐答案
我强烈建议您使用人们为多部分文件上传处理而构建的现有模块之一. 常用文件上传较为流行，我建议您调查一下(用法示例
I strongly advice you use one of the existing modules people have built for multipart file upload handling. Commons Fileupload is on of the more popular, I suggest you look into it (usage example here).
您的代码非常混乱，您正在混合使用字节数组和字符串，这肯定会产生错误.这个:
Your code is pretty messy and you are mixing working with byte arrays and Strings in a way that is sure to create errors. This:
int boundaryLocation = file.indexOf(boundary, pos) - 4;
int startPos = ((file.substring(0, pos)).getBytes()).length;
int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;
...
fileOut.write(dataBytes, startPos, (endPos - startPos));
特别有毛.无论如何，如果您坚持要自己做，就应该清理代码，不要将字符串和字节数组一起使用(记住，字符串中的一个字符不一定只是一个字节).但我不建议这样做，除非这是您的学习经历.在这种情况下，我会花一些时间尝试在Internet上找到一些用于多部分表单处理的示例代码.
is particularly hairy. Anyway, if you insist on doing it yourself, you should clean up your code, don't mix working with Strings and byte arrays (remember, one character in a string is not necessarily just one byte). I don't recommend it though, unless this is a learning experience for you. In which case I would spend some time to try and find some example code on the internet for multipart form handling.
这篇关于使用jsp将多种文件格式上传到服务器，并将路径存储在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
