Printing a MySql results set in java

How can we print the data of a mysql results set on the printer with correct alignments of each data rows and column开发者_如何转开发s? Lets say, we get a dataset from a mysql database and populate that data in to a JTable, out of that JTable is there a way to get a printed hard-copy without any borders and lines of the JTable?

You need to pad each column with spaces and make it the same length as the column size.

Java has the System.out.printf method, which works like the printf of C with a format String and varargs.

I think for DB reports it is more convenient on the long run to use a Report Generator like iReport.