Home Servlets Expport data into CSV File using JDBC in Servlet

Related Tutorials


 
 

Share on Google+Share on Google+

Expport data into CSV File using JDBC in Servlet

Advertisement
In this section, you will learn how to export data into CSV file using JDBC in Servlet.

Expport data into CSV File using JDBC in Servlet

     

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

Brief description for the flow of application :

*)Create a folder "csv" in the C:\ Drive:.
*)Create a file "JdbcCsvFile.java" that creates a CSV file "myjdbcfile.csv".
*)Download the "Tomcat apache Server With Latest version" , download source code as given below and run application with the URL
   http://localhost:8080/servletcsv/jdbcCsvFile

 

Step 1: Create a  table "user_register" in the database.

Step 1: Create a Servlet "JdbcCsvFile.java".

import java.io.FileWriter;
import java.io.IOException;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
 
public class JdbcCsvFile extends HttpServlet { 
public  void doGet (HttpServletRequest request,
  HttpServletResponse response) 
  throws ServletException,IOException  {
  String filename = "c:\\csv\\myjdbcfile.csv";
  Connection conn = null;
  String url = "jdbc:mysql://localhost:3306/";
  String dbName = "user_register";
  String driver = "com.mysql.jdbc.Driver";
  String userName = "root"; 
  String password = "root";
  Statement stmt;
  try
  {
  PrintWriter out = response.getWriter();
  FileWriter fw = new FileWriter(filename);
  fw.append("Employee Code");
  fw.append(',');
  fw.append("First Name");
  fw.append(',');
  fw.append("Last Name");
  fw.append('\n');

  Class.forName(driver).newInstance();
  conn = DriverManager.getConnection
   (url+dbName,userName,password);
  String query  = "select * from employee_details";
  stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery(query);
  while(rs.next())
  {
  fw.append(rs.getString(1));
  fw.append(',');
  fw.append(rs.getString(2));
  fw.append(',');
  fw.append(rs.getString(3));
  fw.append('\n');
  }
  fw.flush();
  fw.close();
  conn.close();
  out.println
   ("<b>You are Successfully Created Csv file.</b>");
  } catch (Exception e) {
  e.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>jdbccsvfile</servlet-name>
<servlet-class>JdbcCsvFile</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>jdbccsvfile</servlet-name>
<url-pattern>/jdbcCsvFile</url-pattern>
</servlet-mapping>
</web-app>


Output :


"myfile.csv"

Download Source Code

 

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: September 26, 2008

Related Tutorials

Discuss: Expport data into CSV File using JDBC in Servlet   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com