java-pretty print sql query

Question

Does someone have pretty_print function for print SQL query in java?

given string like:

SELECT person_table.name FROM person_table JOIN person_person ON person_table.name=person_person WHERE person_table.name=dan

The function will print:

SELECT person_table.name

FROM person_table

JOIN person_person

ON person_table.name=person_person

WHERE person_table.name=dan

or better?

Thanks in advance!

Answer 1

If you work with Hibernate try org.hibernate.jdbc.util.FormatStyle.BASIC.getFormatter().format(yourNonFormattedSqlQueryString);

Answer 2

You can take a look at org.apache.openjpa.lib.jdbc.SQLFormatter.