mybatis的配置文件

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>
View Code

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
View Code

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
View Code

 

posted @ 2021-08-23 23:59  现在开始JAVA  阅读(35)  评论(0)    收藏  举报