Pretty printing SQL results Java

Question

I am working on a sql parser/interpreter for Objects. More here: Parsing SQL like syntax, design pattern

I just wanted to know if there are any off the shelf libraries for pretty printing the output results. The results would be simple types, collections etc ..

Something like this would be very nice

mysql> SELECT poet,SUM(copies_in_stock) FROM writer GROUP BY poet;
+----------------------+----------------------+
| poet                 | SUM(copies_in_stock) |
+----------------------+----------------------+
| Douglas Livingstone  |                   23 |
| Mongane Wally Serote |                   13 |
+----------------------+----------------------+

Any pointers would be helpful

score 1 · Answer 1 · answered Jun 14 '12 at 05:31

Not that I know of. You can find some internal classes of open-source DB engines that do that, eg: http://www.docjar.org/docs/api/org/apache/derby/tools/JDBCDisplayUtil.html

Alternatively, there are libraries for outputting text in a table format, see: http://trac.inamik.com/trac/jtable_format/

score 0 · Accepted Answer · edited May 23 '17 at 11:48

0

This was exactly what i needed. Pretty print 2D array in Java

edited May 23 '17 at 11:48

Community

1
1

answered Jan 09 '13 at 10:41

jack_carver

1,510
2
13
28

Pretty printing SQL results Java

2 Answers2