一、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