Wednesday, April 25, 2012

download the csv file using servlets


Csv.java
-----------

import java.io.DataInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileWriter;
import java.io.IOException;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class Csv
 */
@WebServlet("/Csv")
public class Csv extends HttpServlet {
private static final long serialVersionUID = 1L;
     
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Csv() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {



File                f        = new File("d:\\csv.txt");
       int                 length   = 0;
       ServletOutputStream op       = response.getOutputStream();
       ServletContext      context  = getServletConfig().getServletContext();
       String              mimetype = context.getMimeType( "text" );
       FileWriter writer = new FileWriter("d:\\csv1.text");

       //
       //  Set the response and go!
       //
       //
       response.setContentType( (mimetype != null) ? mimetype : "application/octet-stream" );
       response.setContentLength( (int)f.length() );
       response.setHeader( "Content-Disposition", "attachment; filename=\"" + writer + "\"" );

       //
       //  Stream to the requester.
       //
       byte[] bbuf = new byte[1024];
DataInputStream in = new DataInputStream(new FileInputStream(f));

       while ((in != null) && ((length = in.read(bbuf)) != -1))
       {
           op.write(bbuf,0,length);
       }

       in.close();
       op.flush();
       op.close();
// TODO Auto-generated method stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}

}


web.xml
----------
<?xml version="1.0" encoding="UTF-8"?>
<web-app>
<servlet>
<servlet-name>abc</servlet-name>
<servlet-class>Csv</servlet-class>

</servlet>
<servlet-mapping>
<servlet-name>abc</servlet-name>
<url-pattern>/csvv</url-pattern>

</servlet-mapping>


</web-app>

1 comment:

  1. can any one tel me how to load CSV file into oracle data base using JSP or SERVLET

    ReplyDelete