Java-pretty print sql query

Question

Does anyone have a pretty_print function to query an SQL query in java format?

given string as:

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

UNIT person_person

ON person_table.name = person_person

WHERE person_table.name = dan

or better?

Thanks in advance!

Answer 1

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

Answer 2

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