日期:2014-05-20  浏览次数:20773 次

mybatis打印sql语句

请教下mybatis 如何打印sql语句 logs.properties 已经设置为debug了


------解决方案--------------------
探讨

引用:

帮顶,我也在研究

google一查全是ibatis的!唉……

------解决方案--------------------
探讨
唉……每次问问题都是没有答案的!

------解决方案--------------------
info 换成debug 试试
一般debug信息里肯定会有sql语句以及相关事务
------解决方案--------------------
mybatis其实就是ibatis的更高版本而已,你就直接搜ibatis的,应该有帮助,最好去查文档,ibatis用的人也不是很多,mybatis还算比较新,估计用的人更少了
------解决方案--------------------
MyBatis自己内部使用的是Log4j,但实际上支持用户使用各种Log技术。如果配置正确的话,也就是启用debug级别即可打印所有的MyBatis的语句。比如,在我的web程序中,使用logback,maven依赖如下:
XML code

    <!--log-begin-->
    <dependency>

------解决方案--------------------
关于MyBatis的使用,你最好加入MyBatis的邮件组,用英文提问,总会有人帮助你。据我所知,MyBatis的邮件组是总有很多人非常热心的,及时的回复。我也在其中。是我遇到的开源社区里面最活跃的邮件组。
------解决方案--------------------
我的程序打印出来的日志:
10:30:16.741 [http-thread-pool-8080-(1)] DEBUG o.a.i.d.pooled.PooledDataSource - Checked out connection 30051965 from pool.
10:30:16.741 [http-thread-pool-8080-(1)] DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 30051965 ...
10:30:16.743 [http-thread-pool-8080-(1)] DEBUG o.a.i.d.pooled.PooledDataSource - Connection 30051965 is GOOD!
10:30:16.743 [http-thread-pool-8080-(1)] DEBUG java.sql.Connection - ooo Connection Opened
10:30:16.744 [http-thread-pool-8080-(1)] INFO com.webt.user.UserManager - session:false
10:30:16.745 [http-thread-pool-8080-(1)] DEBUG java.sql.PreparedStatement - ==> Executing: select count(*) as FailedTimes from LoginHistory where (FailedName=?) and (Time between ? and ?) and (Result=1) 
10:30:16.746 [http-thread-pool-8080-(1)] DEBUG java.sql.PreparedStatement - ==> Parameters: kaimei(String), 2011-01-14 10:30:16.744(Timestamp), 2011-01-15 10:30:16.744(Timestamp)
10:30:16.747 [http-thread-pool-8080-(1)] DEBUG java.sql.ResultSet - <== Columns: FailedTimes
10:30:16.747 [http-thread-pool-8080-(1)] DEBUG java.sql.ResultSet - <== Row: 0
10:30:16.748 [http-thread-pool-8080-(1)] INFO com.webt.user.SystemAdminManager - we are here
10:30:16.748 [http-thread-pool-8080-(1)] INFO com.webt.user.UserManager - isAdministrator
10:30:16.749 [http-thread-pool-8080-(1)] DEBUG java.sql.PreparedStatement - ==> Executing: select PersonID,PasswordHashValue,Salt,Phone,Address,Sex from Administrator where Name = ? or Email = ? 
10:30:16.749 [http-thread-pool-8080-(1)] DEBUG java.sql.PreparedStatement - ==> Parameters: kaimei(String), null
10:30:16.752 [http-thread-pool-8080-(1)] DEBUG java.sql.PreparedStatement - ==> Executing: select PersonID,PasswordHashValue,Salt,Name,Email,Phone,Address,Sex from User where Name = ? or Email = ? 
10:30:16.752 [http-thread-pool-8080-(1)] DEBUG java.sql.PreparedStatement - ==> Parameters: kaimei(String), null
10:30:16.754 [http-thread-pool-8080-(1)] DEBUG java.sql.ResultSet - <== Columns: PersonID, PasswordHashValue, Salt, Name, Email, Phone, Address, Sex
10:30:16.754 [http-thread-pool-8080-(1)] DEBUG java.sql.ResultSet - <== Row: 1, 88e9e1390aacb14be605ee67850dfe945afec728f5703221e988eef31faf4520, 3jwd6giu, kaimei, csfreebird@gmail.com, null, null, male