SPRINGMVC + Spring + MyBatis Learning Note: Add print SQL functionality to MyBatis (most simplified configuration)

System: WIN8.1

Database: Oracle 11GR2

Development tools: MyEclipse 8.6

Frames: Spring3.2.9, SpringMVC3.2.9, MyBatis3.2.8

1. Copy the following jar packages to the Lib directory

2, in the SRC directory to increase the log4j.properties file, the content is as follows

1 # Global logging configuration 2 log4j.rootlogger=ERROR, stdout3 # Log4j.logger followed by the project DAO package path, inside all are the DAO layer interface 4 Log4j.logger. Com.kickstarter.dao=TRACE5 # Console output ... 6 log4j.appender.stdout=org.apache.log4j.ConsoleAppender7 log4j.appender.stdout.layout=org.apache.log4j.PatternLayout8 log4j.appender.stdout.layout.conversionpattern=%5p [%t]-%m%n

Configuration is complete. Trace can also be configured as debug output.

Springmvc + Spring + MyBatis Learning Note: Add print SQL functionality to MyBatis (most simplified configuration)