[an error occurred while processing this directive]

Export data into CSV File using Servlet

                         

In this section, you will learn how to Export data into  CSV file using Servlet. We have created  file "JdbcCsvFile.java" to export data from this .java file..

Brief description for the flow of application :

A CSV file is commonly known as a Comma Delimited File or a Character Separated File. It is a text file that has a specific format which allows saving of text in organized manner. This format known as a flat table, is very simple. Each row contains one record of information. The character used to distinguish each piece of data within each record is most commonly used a comma ",".

*)Create a folder "csv" in the C:\ Drive:.
*)Create a file "CsvFile.java" that creates a CSV file "myfile.csv".
*)Download the "Tomcat apache Server With Latest version" and run with the URL
   http://localhost:8080/servletcsv/csvFile.


Step 1: Create a Servlet "CsvFile.java"

import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CsvFile extends HttpServlet { 
public void doGet (HttpServletRequest request,HttpServletResponse response) 
throws ServletException,IOException  {
try
{
      PrintWriter out = response.getWriter();
      String filename = "c:\\csv\\myfile.csv";
      FileWriter fw = new FileWriter(filename);
 
      fw.append("Employee Code");
      fw.append(',');
      fw.append("Employee Name");
      fw.append(',');
      fw.append("Employee Address");
      fw.append(',');
      fw.append("Employee Phone");
      fw.append(',');
      fw.append("Employee ZipCode");
      fw.append('\n');

      fw.append("E1");
      fw.append(',');
      fw.append("Vineet");
      fw.append(',');
      fw.append("Delhi");
      fw.append(',');
      fw.append("224277488");
      fw.append(',');
      fw.append("110085");
      fw.append('\n');

      fw.append("E2");
      fw.append(',');
      fw.append("Amar");
      fw.append(',');
      fw.append("Delhi");
      fw.append(',');
      fw.append("257765758");
      fw.append(',');
      fw.append("110001");
      fw.append('\n');

      fw.append("E3");
      fw.append(',');
      fw.append("Amit");
      fw.append(',');
      fw.append("Delhi");
      fw.append(',');
      fw.append("257685858");
      fw.append(',');
      fw.append("110005");
      fw.append('\n');

      fw.append("E4");
      fw.append(',');
      fw.append("Suman");
      fw.append(',');
      fw.append("Delhi");
      fw.append(',');
      fw.append("266447678");
      fw.append(',');
      fw.append("110081");
      fw.append('\n');
 
      
      fw.flush();
      fw.close();
      out.println("<b>Csv file Successfully created.</b>");


catch (Exception ex) {
ex.printStackTrace ();
}
}
}

 

Step 2:Create a "Web.xml" for mapping the Servlet "CsvFile.java". 

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
version="2.5">

<display-name>Welcome to Tomcat</display-name>
<description>
Welcome to Tomcat
</description>
<servlet>
<servlet-name>csvfile</servlet-name>
<servlet-class>CsvFile</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>csvfile</servlet-name>
<url-pattern>/csvFile</url-pattern>
</servlet-mapping>
</web-app>


Output :


"myfile.csv"

Download Source Code

 

                         

[an error occurred while processing this directive]