jpa打印sql

<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.format_sql" value="true"/>

spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true

# Logback example
logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE

import javax.persistence.EntityManager;
import javax.persistence.Query;
import org.hibernate.EmptyInterceptor;
import java.io.Serializable;

public class SqlPrintInterceptor extends EmptyInterceptor {
    @Override
    public boolean onPrepareStatement(String sql) {
        System.out.println(sql);
        return super.onPrepareStatement(sql);
    }
}

// 在EntityManagerFactory配置中注册拦截器
Map<String, Object> properties = new HashMap<>();
properties.put("hibernate.ejb.interceptor", new SqlPrintInterceptor());
EntityManagerFactory emf = Persistence.createEntityManagerFactory("your-persistence-unit", properties);