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!

The thing with that is that everyone has a different way of writing SQL - some people place the JOIN clause on the same line as the FROM, or keep the ON clause with the JOIN clause on the same line. — Makoto
– Makoto, Commented Feb 28, 2013 at 16:52

Burhan Ali · Accepted Answer · 2014-03-13 09:30:02Z

4

Burhan Ali

2,2161 gold badge28 silver badges38 bronze badges

answered Feb 28, 2013 at 16:59

Farlan

1,8922 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexandr Dolgov · Accepted Answer · 2017-02-03 05:12:44Z

3

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

answered Feb 3, 2017 at 5:12

Alexandr Dolgov

313 bronze badges

Works for HQL too.