Mybatis单元测试（一、项目构建）

测试环境：

①IDE: Eclipse Java EE IDE for Web Developers. Version: Mars.2 Release (4.5.2)

②JDK:1.7.0.79

③DB:Mysql

④其他：Navicat for MySQL v11.2.7

一、Maven项目构建

    1.首先要安装本地maven环境，测试环境为apache-maven-3.3.9

    2.新建maven项目，编辑pom.xml文件，如下：

            自动构建项目，下载远程maven库jar包，此处集成了：

                ①单元测试junit

                ②mybatis

                ③数据库连接

                ④日志查看（控制台查看sql语句...）

                ⑤JDK版本

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>tk.mybatis</groupId>
  <artifactId>simple</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <!-- 常用配置 -->
  <properties>
  	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>
  
  <dependencies>
	  
	    <dependency>
	        <groupId>junit</groupId>
	        <artifactId>junit</artifactId>
	        <version>4.10</version>
	        <optional>true</optional>
	    </dependency>  
		<dependency>
		    <groupId>org.mybatis</groupId>
		    <artifactId>mybatis</artifactId>
		    <version>3.3.0</version>
		</dependency>
		<dependency>
		    <groupId>mysql</groupId>
		    <artifactId>mysql-connector-java</artifactId>
		    <version>5.1.38</version>
		</dependency>
        <!-- 日志依赖,用于看tomcat的启动日志,实际没有什么作用 -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.12</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.12</version>
        </dependency>	        
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
	<!-- 其他依赖 -->
  </dependencies>

  
  <!-- 添加其他配置 -->
  <build>
  	<plugins>
		<plugin>
		    <artifactId>maven-compiler-plugin</artifactId>
		    <configuration>
		        <source>1.7</source>
		        <target>1.7</target>
		    </configuration>
		</plugin>
  	</plugins>
  </build>
</project>

二、日志插件

    src/main/resource 地址下新建log4j.properties文件

#全局配置
log4j.rootLogger=ERROR,stdout
#Mybatis日志配置
log4j.logger.tk.mybatis.simple.mapper=TRACE
#控制台输出配置
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n