How to download data as csv from database using java?

Question

I need to download the csv file from database using database.

I have jdbc connection and execute the query , get the data from database.Those values are download as csv format using java class.

Java class:
String filename="Cases.csv";
//here database connection.


ResultSet rst= stmt.executeQuery(qry);
    System.out.println("1"+rst);
    if(rst.next())
    {

    Content=rst.getString("USER_details");

    }
    //ServletOutputStream out = null;
    //out.println(Content);
    System.out.println("1"+Content);
    byte requestBytes[] = Content.getBytes();
    ByteArrayInputStream bis = new ByteArrayInputStream(requestBytes);
    response.reset();
    response.setContentType("application/text");
    response.setHeader("Content-disposition","attachment; filename=" +filename);
    byte[] buf = new byte[1024];
    int len;
    while ((len = bis.read(buf)) > 0){
    response.getOutputStream().write(buf, 0, len);
    }
    bis.close();
    response.getOutputStream().flush(); 
    }
    catch(Exception e){
    e.printStackTrace();
    }

How to get all values from database to csv format ?

I would always do while(rst.next()) instead of if(rst.next()) in case you return multiple rows in the future. Also put your close statments in a finally block. — Romain Hippeau
– Romain Hippeau, Commented Jul 2, 2010 at 17:56
I want to get more than one row and coloumn.How to modify the code ? — Nancy
– Nancy, Commented Jul 2, 2010 at 18:08

gustafc · Accepted Answer · 2010-07-02 17:42:38Z

3

OpenCSV supports exporting a ResultSet to CSV:

CSVWriter writer = ...;
ResultSet rs = ...;
writer.writeAll(rs, true);

answered Jul 2, 2010 at 17:42

gustafc

29k7 gold badges75 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to download data as csv from database using java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related