Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

FileUpload and Download

Ads

 
 

Share on Google+Share on Google+

Rajalakshmi
FileUpload and Download
0 Answer(s)      5 years and 5 months ago
Posted in : JSP-Interview Questions

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

<[email protected] 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

<[email protected] 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

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

<[email protected] import="java.sql.*"%>
<[email protected] import="java.io.*"%>
<[email protected] 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();
%>
Ads
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
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
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  how to download the file in server using php code: "<form method="post" action=""> enter the folder name<input type="text" name="t1" > <input type="submit" value="search" name="s1"> </form> <
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
JSF-fileupload-ajax - Development process
JSF-fileupload-ajax   for the above code , iam able to bind the contractname & contractNo but i am unable to bind the upload property in the bean it is giving null value
download excel
download excel  hi i create an excel file but i don't i know how to give download link to that excel file please give me any code or steps to give download link
JSF-fileupload-ajax - Java Server Faces Questions
JSF-fileupload-ajax  hi i am upload the file JSF with ajax i am using . i create 4 panel tabs in one panel tab i used .i want file to be uploaded using , but i am getting Nullpointer Exception when i try to get the file
file download
file download  I uploaded a file and saved the path in database. Now i want to download it can u plz provide code
Java download
Java download  Hi, Is it possible to download the Java for Linux Centos 6? From where it can be downloaded for Linux Centos 6? Thanks
download - SQL
download  i want download the mysql server  Hi friend, The latest version of MySQL can be downloaded from http://www.mysql.com. Read for more information. http://www.roseindia.net/mysql/mysql5/Installing
Download Java
process of downloading and Installing Java  Hi, How easy is the process of downloading and Installing Java? I have windows 7 machines. Can anyone tell me how to download and install Java? 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
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
Fileupload from source path to destination path
Fileupload from source path to destination path  first we will create one .doc file and .rtf file in one location statically.In html we will give source path &Destination path fields and BOTH INPUT TYPES ARE "TEXT" we
java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory
java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory  Hi, How to resolve exception: java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory Full stack trace of the exception