一、MyBatis 核心配置文件

一、mybatis.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加载外部文件 -->
 7     <properties resource="db.properties"/>
 8 
 9     <!-- 设置MyBatis使用log4j日志支持 -->
10     <settings>
11         <setting name="logImpl" value="LOG4J"/>
12     </settings>
13 
14     <!-- typeAliases给类型起别名 -->
15     <typeAliases>
16         <package name="com.pojo"/>
17     </typeAliases>
18     
19     <!--用于指定使用哪个环境，default:用于指定使用的环境id-->
20     <environments default="dev">
21         <!--用于配置开发环境，id:环境的唯一识别码-->
22         <environment id="dev">
23             <!--事务管理器，type: 用于设置mybatis采用什么方式管理事务，JDBC表示采用和JDBC一样的事务管理方式-->
24             <transactionManager type="JDBC"></transactionManager>
25             <!--数据源/连接池, 用于配置连接池和数据库连接的参数，type: 用于设置mybatis是否采用连接池技术，POOLED表示MyBatis采用连接池技术-->
26             <dataSource type="POOLED">
27                 <property name="driver" value="${driver}"/>
28                 <property name="url" value="${url}"/>
29                 <property name="username" value="${username}"/>
30                 <property name="password" value="${password}"/>
31             </dataSource>
32         </environment>
33     </environments>
34     
35     <mappers>
36         <!--<mapper class="com.mapper.UserMapper"/>-->
37         <package name="com.mapper"/>
38     </mappers>
39 
40 </configuration>

二、mapper.xml

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 <!DOCTYPE mapper
 3         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 4         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 5 <!--namespace: 命名空间, 可以随意定义, 一般情况下要写全限定路径
 6 MyBatis管理SQL语句是通过namespace+id来定位的-->
 7 <mapper namespace="com.mapper.ClazzMapper">
 8     <!--开启二级缓存-->
 9     <cache/>
10 </mapper>

三、log4j.properties

 1 # Set root category priority to INFO and its only appender to CONSOLE.
 2 log4j.rootCategory= ERROR, CONSOLE
 3 #log4j.rootCategory=DEBUG, CONSOLE, LOGFILE
 4 
 5 # 单独设置SQL语句的输出级别为DEBUG级别
 6 # 方法级别
 7 # log4j.logger.com.mapper.UserMapper.selAll=DEBUG
 8 # 类级别
 9 # log4j.logger.com.mapper.UserMapper=DEBUG
10 # 包级别
11 # log4j.logger.com.mapper=DEBUG
12 log4j.logger.com.mapper=DEBUG
13 
14 # CONSOLE is set to be a ConsoleAppender using a PatternLayout.
15 log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
16 
17 log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
18 log4j.appender.CONSOLE.layout.ConversionPattern=- %m %n
19 
20 # LOGFILE is set to be a File appender using a PatternLayout.
21 log4j.appender.LOGFILE=org.apache.log4j.FileAppender
22 log4j.appender.LOGFILE.File=e:/log4jTest.log
23 log4j.appender.LOGFILE.Append=true
24 log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
25 log4j.appender.LOGFILE.layout.ConversionPattern=- %m %l %d{yyyy-MM-dd hh:mm:ss} %n

四、db.properties

1 driver=com.mysql.jdbc.Driver
2 url=jdbc:mysql://localhost:3306/db_books?useUnicode=true&characterEncoding=utf-8
3 username=root
4 password=123456