问题描述
我是Spring Boot的新手. sql参数绑定的配置设置是什么.例如，在下面的行中，我应该能够看到所有?"的值.
I am new to spring boot. What is the configuration setting for sql parameter binding. For example in the following line I should be able to see values for all '?'.
选择*从MyFeed WHERE feedId>? AND isHidden = false ORDER BY feedId DESC LIMIT吗?
SELECT * FROM MyFeed WHERE feedId > ? AND isHidden = false ORDER BY feedId DESC LIMIT ?
当前我的配置为
spring.jpa.show-sql:是
spring.jpa.show-sql: true
推荐答案
这只是底层持久性提供程序的提示，例如Hibernate，EclipseLink等.很难知道您正在使用什么.
This is just a hint to the underlying persistence provider e.g. Hibernate, EclipseLink etc. Without knowing what you are using it is difficult to say.
对于Hibernate，您可以配置日志记录以同时输出绑定参数:
For Hibernate you can configure logging to also output the bind parameters:
http://www.mkyong .com/hibernate/how-to-display-hibernate-sql-parameter-values-log4j/
这将为您提供如下输出:
which will give you output like:
Hibernate: INSERT INTO transaction (A, B)
VALUES (?, ?)
13:33:07,253 DEBUG FloatType:133 - binding '10.0' to parameter: 1
13:33:07,253 DEBUG FloatType:133 - binding '1.1' to parameter: 2
一种适用于所有JPA提供程序的替代解决方案是使用log4jdbc之类的东西，它将为您提供更好的输出:
An alternative solution which should work across all JPA providers is to use something like log4jdbc which would give you the nicer output:
INSERT INTO transaction (A, B) values (10.0, 1.1);
请参阅:
https://code.google.com/p/log4jdbc-log4j2/
这篇关于Spring Boot显示SQL参数绑定?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！