Shulou(Shulou.com)06/02 Report--

How to print sql statements in spring boot? I believe many inexperienced people don't know what to do about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Methods:

You can add code to your application.properties file

Logging.level.com.shop=debug# logging.level. Then you need to print the package of the sql statement = debug#, for example, my package is com.shop.

The printed sql statement looks like this

: = > Preparing: select id, merchantid, shopName, shopDescription, shopBussinessScope, province, city, businessLicense, createTime, `state`from youfanshop where 1room1 and `state` =?: = > Parameters: 0 (Integer):

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.