How to download a file from database

i have inserted a .doc into ms access database using com.oreilly.servlet.MultipartRequest.Now how can i download it.Can anyone plz help me with the code.

Please provide more information with your questions.

Are you able to get the file out of the database? If you can get it in, you should be able to extract it. To send it to the client, you can adapt the code here

package rdb;
 
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import com.oreilly.servlet.MultipartRequest;
 
 
public class FinalUpload extends HttpServlet
{
  public void service(HttpServletRequest req,HttpServletResponse res)
      throws ServletException,IOException
  {
    String filename="";
    PrintWriter out = res.getWriter();
    try
      {
        
        MultipartRequest multi= new MultipartRequest(req,"c:/visu/resumes",5*1024*1024);
        Enumeration files=multi.getFileNames();
        File f=null;
        while(files.hasMoreElements())
        {
         String name=(String)files.nextElement();
         
         filename=multi.getFilesystemName(name);
         String type=multi.getContentType(name);
         f=multi.getFile(name);
         System.out.println("The File is "+f);
        }
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("jdbc  :-o	  dbc:Rd","Admin","");
        Statement stmt = con.createStatement();
        System.out.println("2 "+f);
        InputStream is = new FileInputStream(f);
        System.out.println("4 "+is);
        byte b[]=new byte[is.available()];
        is.read(b);
        String s1 = multi.getParameter("name");
        String sql = "INSERT into Table4 values('"+s1+"','" + b + "');";
        System.out.println("sql is " +sql);
        stmt.execute(sql);
        ResultSet rs = stmt.executeQuery("Select * from Table4");
        while(rs.next())
        {
          out.println("Name : " + rs.getString(1) +
                      "CV : " + rs.getString(2));
        }
        rs.close();
        stmt.close();
        con.close();
 
      }catch(Exception e)
         {
           out.println(e);
         }
          out.println("The resume is Added into Database");
 
  }
}

Using this code i have inserted the data into the access database.when i gave the select command i got a number format for CV field.i want to download it to text format.could u plz help me

[added code tags]
[ September 08, 2005: Message edited by: Jeanne Boyarsky ]

Moving to the JDBC forum.

Visu,
Which line throws the exception? Does it work if you do the select without doing the insert first?

When i retrieve the data i am getting an output of this sort

Name : viswanathCV : 5B00420040003100640031003000610035006300