FileUpload and Download

FileUpload and Download

Hello Sir/Madam, I have used the below coding for Upload and download file, but it is not stored in database and also it s not download the file with its content... just it download doc with 0 Bytes what should be modify here to get correct solution my database contain the table name as files and column name as file_data can you please correct it.. thanks in advance...

index.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@ page language="java" %>
<HTML>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD>

<BODY> <FORM ENCTYPE="multipart/form-data" ACTION="upload.jsp" METHOD=POST>
<br><br><br>
<center>
<table border="0">
<tr>
<center>
<td colspan="2" align="center"><B>UPLOAD THE FILE</B</td></center>
</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>

upload.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>

<%
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);
String saveFile = file.substring(file.indexOf("filename=\"") + 10);
saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1,saveFile.indexOf("\""));
out.println(saveFile);
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;

FileOutputStream fileOut = new FileOutputStream(saveFile);
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>
<a  href = "downloadFile.jsp" > Downloadfile</a>

<%
Connection connection = null;
ResultSet rs = null;
PreparedStatement psmnt = null;
FileInputStream fis;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance();
connection = DriverManager.getConnection("jdbc:odbc:sss","","");
File f = new File(saveFile);
psmnt = connection.prepareStatement("insert into files(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();}
}
//
%>

downloadFile.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%
ServletOutputStream output = response.getOutputStream();
String connectionURL = "jdbc:mysql://192.168.10.112:3306/files";;;;
String Content=new String("");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection(connectionURL,"root","root");
Statement st=con.createStatement();
ResultSet rst= st.executeQuery("select file_data from files");
if(rst.next())
{
Content=rst.getString("file_data");
}
con.close();
}catch(Exception e){
System.out.println("Exception caught"+e.getMessage());
}
byte requestBytes[] = Content.getBytes();
ByteArrayInputStream bis = new ByteArrayInputStream(requestBytes);
response.reset();
response.setContentType("application/doc");
response.setHeader("Content-disposition","attachment; filename=" +"file.doc");
byte[] buf = new byte[1024];
int len;
while ((len = bis.read(buf)) > 0){
output.write(buf, 0, len);
}
bis.close();
response.getOutputStream().flush();
%>
View Answers

Ads









Related Tutorials/Questions & Answers:
FileUpload and Download
FileUpload and Download  Hello Sir/Madam, I have used the below coding for Upload and download file, but it is not stored in database and also it s not download the file with its content... just it download doc with 0 Bytes
FileUpload and Download
FileUpload and Download  Hello Sir/Madam, I have used the below coding for Upload and download file, but it is not stored in database and also it s not download the file with its content... just it download doc with 0 Bytes
Advertisements
FileUpload and Download
FileUpload and Download  Hello Sir/Madam, I have used the below coding for Upload and download file, but it is not stored in database and also it s not download the file with its content... just it download doc with 0 Bytes
FileUpload and Download
FileUpload and Download  Hello Sir/Madam, I have used the below coding for Upload and download file, but it is not stored in database and also it s not download the file with its content... just it download doc with 0 Bytes
FileUpload and Download
FileUpload and Download  Hello Sir/Madam, I have used the below coding for Upload and download file, but it is not stored in database and also it s not download the file with its content... just it download doc with 0 Bytes
FileUpload and Download
FileUpload and Download  Hello sir/madam, I need a simple code for File upload and Download in jsp using sql server,that uploaded file should... be download with its full content...can you please help me... im in urgent i have
Version of commons-fileupload>commons-fileupload dependency
List of Version of commons-fileupload>commons-fileupload dependency
FileUpload
ModuleNotFoundError: No module named 'fileupload'
ModuleNotFoundError: No module named 'fileupload'  Hi, My Python... 'fileupload' How to remove the ModuleNotFoundError: No module named 'fileupload' error? Thanks   Hi, In your python environment you
Fileupload in servlet
Fileupload in servlet  If we upload a file using servlet can it possible to put the uploaded file in any locationof the syatem(in D drive or in C drive)??? If any pls give the code.. Thanks in advance....   import
Download
Download JDK  How to Download the latest Version of JDK?   Download OST to PST converter from: http://www.osttopst.info
Download.
Download.  I need a swing program to download a file from the server
Artifacts of commons-fileupload
List of Artifacts of commons-fileupload maven depenency
Maven Dependency commons-fileupload >> 1.0-beta-1
You should include the dependency code given in this page to add Maven Dependency of commons-fileupload >> commons-fileupload version1.0-beta-1 in your project
Maven Dependency commons-fileupload >> 1.0
You should include the dependency code given in this page to add Maven Dependency of commons-fileupload >> commons-fileupload version1.0 in your project
Maven Dependency commons-fileupload >> 1.1.1
You should include the dependency code given in this page to add Maven Dependency of commons-fileupload >> commons-fileupload version1.1.1 in your project
Maven Dependency commons-fileupload >> 1.1
You should include the dependency code given in this page to add Maven Dependency of commons-fileupload >> commons-fileupload version1.1 in your project
Maven Dependency commons-fileupload >> 1.0-rc1
You should include the dependency code given in this page to add Maven Dependency of commons-fileupload >> commons-fileupload version1.0-rc1 in your project
Maven dependency for commons-fileupload - commons-fileupload version 1.3 is released. Learn to use commons-fileupload version 1.3 in Maven based Java projects
-fileupload released The developers of   commons-fileupload - commons-fileupload project have released the latest version of this library on 24 Mar 2013, the released version of  commons-fileupload - commons-fileupload
ModuleNotFoundError: No module named 'bambu-fileupload'
ModuleNotFoundError: No module named 'bambu-fileupload'  Hi, My... named 'bambu-fileupload' How to remove the ModuleNotFoundError: No module named 'bambu-fileupload' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'Flask-FileUpload'
ModuleNotFoundError: No module named 'Flask-FileUpload'  Hi, My... named 'Flask-FileUpload' How to remove the ModuleNotFoundError: No module named 'Flask-FileUpload' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'Flask-FileUpload'
ModuleNotFoundError: No module named 'Flask-FileUpload'  Hi, My... named 'Flask-FileUpload' How to remove the ModuleNotFoundError: No module named 'Flask-FileUpload' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'Flask-FileUpload'
ModuleNotFoundError: No module named 'Flask-FileUpload'  Hi, My... named 'Flask-FileUpload' How to remove the ModuleNotFoundError: No module named 'Flask-FileUpload' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'js.jquery_fileupload'
ModuleNotFoundError: No module named 'js.jquery_fileupload'  Hi...: No module named 'js.jquery_fileupload' How to remove the ModuleNotFoundError: No module named 'js.jquery_fileupload' error? Thanks   Hi
ModuleNotFoundError: No module named 'opps-fileupload'
ModuleNotFoundError: No module named 'opps-fileupload'  Hi, My... named 'opps-fileupload' How to remove the ModuleNotFoundError: No module named 'opps-fileupload' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'SwampDragon-fileupload'
ModuleNotFoundError: No module named 'SwampDragon-fileupload'  Hi...: No module named 'SwampDragon-fileupload' How to remove the ModuleNotFoundError: No module named 'SwampDragon-fileupload' error? Thanks   Hi
ModuleNotFoundError: No module named 'ai-django-fileupload'
ModuleNotFoundError: No module named 'ai-django-fileupload'  Hi...: No module named 'ai-django-fileupload' How to remove the ModuleNotFoundError: No module named 'ai-django-fileupload' error? Thanks   Hi
ModuleNotFoundError: No module named 'GC-Flask-FileUpload'
ModuleNotFoundError: No module named 'GC-Flask-FileUpload'  Hi, My... named 'GC-Flask-FileUpload' How to remove the ModuleNotFoundError: No module named 'GC-Flask-FileUpload' error? Thanks   Hi
ModuleNotFoundError: No module named 'internal-fileupload-django'
ModuleNotFoundError: No module named 'internal-fileupload-django'  Hi...: No module named 'internal-fileupload-django' How to remove the ModuleNotFoundError: No module named 'internal-fileupload-django' error? Thanks
ModuleNotFoundError: No module named 'XStatic-Angular-FileUpload'
ModuleNotFoundError: No module named 'XStatic-Angular-FileUpload'  Hi...: No module named 'XStatic-Angular-FileUpload' How to remove the ModuleNotFoundError: No module named 'XStatic-Angular-FileUpload' error? Thanks
java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory Maven
java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory Maven  Hi, I am getting following error while running a maven based... dispatcher java.lang.NoClassDefFoundError: org/apache/commons/fileupload

Ads