Copy Database table data to text file without looping recordset

Question

Is it possible to get the result set data to single string (for writing to notepad)? Using record set we need to loop through each fields.

Is there any other way we can get to a single string without loop through each fields? I am able to do this in VBA by copying the entire recordset to an excel sheet.

There is no 'recordset' in standard Java. Please be precise in what you mean. Did you mean `java.sql.ResultSet` instead? — Mark Rotteveel, Sep 28 '18 at 15:03
Mainly it depends on how do you get a data from a DB. If it's a core java - there is a one way, if a Spring or another framework app - another case — Yuriy Tsarkov, Sep 28 '18 at 15:03

Mark Rotteveel · Answer 1 · 2018-09-28T15:59:14.960

2

There isn't really something in standard Java that does this for you, except maybe using javax.sql.rowset.WebRowSet and one of its writeXml methods, but that is a very specific and verbose format.

If you want to output a result set in a specific format, you will need to do this yourself, or find a library that does this for you.

edited Sep 28 '18 at 15:59

answered Sep 28 '18 at 15:12

Mark Rotteveel

100,966
191
140
197

score 0 · Answer 2 · answered Sep 28 '18 at 15:24

0

Well, in general you have to convert a result set into an any DTO class whatever you want and then implement a toString() method in the way you want to be. There are some ways to achive this. Here is a one: Mapping a JDBC ResultSet to an object

answered Sep 28 '18 at 15:24

Yuriy Tsarkov

2,461
2
14
28

Copy Database table data to text file without looping recordset

2 Answers2