1:mybatis_config.xml
1 <?xml version="1.0" encoding="UTF-8" ?> 2 <!DOCTYPE configuration 3 PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 4 "http://mybatis.org/dtd/mybatis-3-config.dtd"> 5 <configuration> 6 <properties resource="db.properties"/> 7 8 <settings> 9 <!-- <setting name="logImpl" value="STDOUT_LOGGING"/>--> 10 <setting name="logImpl" value="LOG4J"/> 11 </settings> 12 13 <typeAliases> 14 <typeAlias type="com.lieyan.pojo.User" alias="User"/> 15 </typeAliases> 16 17 <environments default="development"> 18 <environment id="development"> 19 <transactionManager type="JDBC"/> 20 <dataSource type="POOLED"> 21 <property name="driver" value="${driver}"/> 22 <property name="url" value="${url}"/> 23 <property name="username" value="${username}"/> 24 <property name="password" value="${password}"/> 25 </dataSource> 26 </environment> 27 </environments> 28 <mappers> 29 <mapper resource="com/lieyan/dao/UserMapper.xml"/> 30 <!-- <mapper class="com.lieyan.dao.UserMapper"/>--> 31 <!-- <package name="com.lieyan.dao"/>--> 32 </mappers> 33 </configuration>
2:db.properties
1 driver=com.mysql.jdbc.Driver 2 url=jdbc:mysql://192.168.1.102:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8 3 username=root 4 password=hahaha
3:log4j.properties
1 ### 配置根 ### 2 log4j.rootLogger = debug,console,file 3 4 ### 配置输出到控制台 ### 5 log4j.appender.console = org.apache.log4j.ConsoleAppender 6 log4j.appender.console.Target = System.out 7 log4j.appender.console.Threshold=DEBUG 8 log4j.appender.console.layout = org.apache.log4j.PatternLayout 9 log4j.appender.console.layout.ConversionPattern = [%c]-%m%n 10 11 ### 配置输出到文件 ### 12 log4j.appender.file = org.apache.log4j.RollingFileAppender 13 log4j.appender.file.File = ./logs/lieyan.log 14 log4j.appender.file.MaxFileSize = 10mb 15 log4j.appender.file.Threshold = DEBUG 16 log4j.appender.file.layout = org.apache.log4j.PatternLayout 17 log4j.appender.file.layout.ConversionPattern = [%p][%d{yy-MM-dd}][%c]%m%n 18 19 ### 日志输出级别 ### 20 log4j.logger.org.mybatis=debug 21 log4j.logger.java.sql=debug 22 log4j.logger.java.sql.Statement=debug 23 log4j.logger.java.sql.PreparedStatement=debug 24 log4j.logger.java.sql.ResultSet=debug
原文:https://www.cnblogs.com/nuyan/p/15178327.html