Retriving zip file stored in database into my own filesystem

Retriving zip file stored in database into my own filesystem

Hi all, I have a table named tempdb with tempid and zipfile as two column.Currently I am using sybase db.

create table tempdb(tempid int,zipfile image)
i have several zip file stored in this table now I want to retrieve it and put it in an directory in my file system.

PreparedStatement psmt=con.prepareStatement("select * from dbo.temp_blob");

   ResultSet rs=psmt.executeQuery();
    while(rs.next())
       {
           System.out.println("PIID IS "+rs.getInt(1));
           //ByteArrayOutputStream byt = new ByteArrayOutputStream(1024);
           //BufferedInputStream bsstream=new BufferedInputStream(rs.getBinaryStream(2));                  
        Blob  b1=rs.getBlob(2);
           byte[] barray=b1.getBytes(1,(int)b1.length());
           File destinationzip=new File("d://dest.zip");
           if(!destinationzip.exists())
           {
               destinationzip.createNewFile();
           }
           FileOutputStream fout=new FileOutputStream(destinationzip);
           ZipOutputStream zpout=new ZipOutputStream(new BufferedOutputStream(fout));
           zpout.write(barray,0,barray.length);

But this not the right approach please tell the proper way to do it.

View Answers

Ads









Related Tutorials/Questions & Answers:
Retriving zip file stored in database into my own filesystem
Retriving zip file stored in database into my own filesystem  Hi all... several zip file stored in this table now I want to retrieve it and put it in an directory in my file system. PreparedStatement psmt=con.prepareStatement("select
Retriving data stored in database
Retriving data stored in database  Hi, How to retrive data from my sql database using Hibernate,Spring and tapestry please give me an example.I am new to this Hibernate and Spring
Advertisements
How to browse excel file and stored the contents into the database using jsp/servlet?
How to browse excel file and stored the contents into the database using jsp/servlet?  Hi.. I want to browse excel file and stored the file data into the My-sql database using jsp/servlet
downloading file through a file's path stored in database in jsp
downloading file through a file's path stored in database in jsp  hi want to download a file from a directory where the file location is stored... table,but i dont know hoe to download the file using its path stored
Resize image stored in database
Resize image stored in database  hi, Can any one please send code for how to resize image stored in database in blob datatype in jsp, i want to resize it to 140(w)*160(h) please help me
where this file is stored
where this file is stored  thank your sir, but where this file is stored? and how to get the path for further use
sending a zip file to servlet
sending a zip file to servlet  I have created a .zip file in a servlet on the local system(no static ip). The .zip file contains xml files. I have to send it to another servlet which is in a server(has a static ip). I have done
How to zip a file using javascrip?
How to zip a file using javascrip?  hi.. can anyone tell me How to zip a file using javascrip
convert zip file to byte array
convert zip file to byte array  Hi,How to convert zip file to byte array,can you please provide program?? Thanks, Ramanuja
convert a file .doc to .zip
convert a file .doc to .zip  hiii, I uploaded a file with extension .doc now i required with .zip   Hi Friend, Try the following code...;TITLE>Display file upload form to the user</TITLE></HEAD> <
Unzip a ZIP File
and stored in the zip file. Here is the code of the program... Unzip a ZIP File       How to unzip (extract) a zip file? How to retrieve elements from
Creating a ZIP file in Java
say the files are stored in the zip format with compression. The file which... Creating a ZIP file in Java       Zip File: Zip file format is the popular method
Read file zip in J2ME - MobileApplications
Read file zip in J2ME  I would like to read file.zip in J2ME,I don't know how to extract it. Please help me
Create zip file in Java
Create zip file in Java       Introduction In this section, you will know about a zip file. You will also learn how to create a zip file from any file through the java
Can I learn Hadoop on my own?
Can I learn Hadoop on my own?  Hi, I am beginner in Data Science... learn Hadoop on my own? Try to provide me good examples or tutorials links so that I can learn the topic "Can I learn Hadoop on my own?". Also tell me
Can I learn R on my own?
Can I learn R on my own?  Hi, I am beginner in Data Science... on my own? Try to provide me good examples or tutorials links so that I can learn the topic "Can I learn R on my own?". Also tell me which
Issue in Converting .zip file to .jar file?
Issue in Converting .zip file to .jar file?  I have a folder called "printpdf.jar". I have changed the .jar to .zip and did some customizations. After which i had "zipped" it again and made as ".jar". Now the final file
What is the best way to learn Java on my own?
What is the best way to learn Java on my own?  Hi, I am new to job market and after completing my graduation searching for better IT job in market... tutorials in Java. What is the best way to learn Java on my own?   Hi
how to display or retrive an image in jsp whose path is stored in oracle database
how to display or retrive an image in jsp whose path is stored in oracle database  how to display or retrive an image in jsp whose path is stored in oracle database and the image is stored in my pictures folder
HTML(Registration form) to Jsp to stored into MS ACCESS database
HTML(Registration form) to Jsp to stored into MS ACCESS database  i am sending one html file that contain 18 fields these are stored in ms-access database by using jsp code.i want to urgent jsp code. please urgent sir. thank
Where to download spring framework zip file?
Where to download spring framework zip file?  Hi, I am trying to find the link to download the full distribution zip file of the Spring Framework.... Can anyone tell me the url from where I can download the full zip file
I need to display parts of my own website on another website in an iframe
I need to display parts of my own website on another website in an iframe  I need to display parts of my own website on another website in an iframe. please refer me how do i do
How to create a zip file and how to compare zip size with normal text file
How to create a zip file and how to compare zip size with normal text file .../ZipCreateExample.shtml but when i verified the size of zip and normal file,normal file is showing as 12 bytes and zip file was showing 150bytes in Dos prompt.Is there any error
Listing Contents of a ZIP File
Listing Contents of a ZIP File     ... of a zip file through the java code. Following program helps you for the appropriate... list of elements present in the zip file format. Program Result: This program
Zip File Using Java
; This example shows how to create a zip file in java. In other words, we... applications. This example shows how we zip a file through a java program... to write files in the zip file format. This class can be used for both compressed
find zip file length lessthen 5MB
find zip file length lessthen 5MB  import java.io.BufferedReader...(); } else{ System.out.println("zip file...; } } System.out.println("Zip File
how to create own tld and use it in jspx file
how to create own tld and use it in jspx file  I wanted to add fmt as own tag and internationalize add.title=Add. please help me solve the problem. <!-- Document : add Created on : Mar 4, 2012, 7:00:38 PM
how to create own tld and use it in jspx file
how to create own tld and use it in jspx file  I wanted to add fmt as own tag and internationalize add.title=Add. please help me solve the problem. <!-- Document : add Created on : Mar 4, 2012, 7:00:38 PM
date retriving
date retriving  my name is subbareddy.sir i was implementing attendance management .In this project i faced one problem that is when i print date stored in the database displays time with date.but i want print only date.please
How much time will it take to learn machine learning on my own?
How much time will it take to learn machine learning on my own?  Hi... on my own? Try to provide me good examples or tutorials links so that I can learn the topic "How much time will it take to learn machine learning on my
What should I study on my own to become a data scientist?
What should I study on my own to become a data scientist?  Hi, I am... for the tutorials to learn: What should I study on my own to become a data scientist... "What should I study on my own to become a data scientist?". Also

Ads