Here is a java example that retrieves the data from the database and save it into csv file.

import java.io.*;
import java.sql.*;

public class DatabaseToCSV { 
public static void main(String[]args){ 
  String filename = "c:\\myjdbcfile.csv";
  Connection conn = null;
  String url = "jdbc:mysql://localhost:3306/";
  String dbName = "test";
  String driver = "com.mysql.jdbc.Driver";
  String userName = "root"; 
  String password = "root";
  Statement stmt;
  try
  {

  FileWriter fw = new FileWriter(filename);

  Class.forName(driver).newInstance();
  conn = DriverManager.getConnection
   (url+dbName,userName,password);
  String query  = "select * from data";
  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(',');
  fw.append(rs.getString(4));
  fw.append(',');
  fw.append(rs.getString(5));
  fw.append(',');
  fw.append(rs.getString(6));
  fw.append(',');
  fw.append(rs.getString(7));
  fw.append(',');
  fw.append(rs.getString(8));
  fw.append(',');
  fw.append(rs.getString(9));
  fw.append(',');
  fw.append(rs.getString(10));
  fw.append('\n');
  }
  fw.flush();
  fw.close();
  conn.close();
  System.out.println("CSV File is created successfully.");
  } catch (Exception e) {
  e.printStackTrace();
  }

  }
}

Thank you friend.. but can you give the code how to do it in jsp...