mybatis报的错

maven构建报错：

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.1:test (default-test) on project maven_test2: There are test failures.

Please refer to E:\develop software\IDEA\IDEA缓存项目\maven_test2\target\surefire-reports for the individual test results.
Please refer to dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.

解决： 【忽略maven错误，直接查看日志输出】

1. pom里加入：

   放在标签<build><pluginManagement><plugins>里：

   <plugin>
       <groupId>org.apache.maven.plugins</groupId>
       <artifactId>maven-surefire-plugin</artifactId>
       <configuration>
           <testFailureIgnore>true</testFailureIgnore>
       </configuration>
   </plugin>
   

2. 点一下这个
   

3. mybatis配置文件里设置log4j打印日志

<settings>
        <setting name="logImpl" value="log4j"/>
</settings>

【两个属性值一个也不能变，logImpl是mybatis识别，log4j是导入的log4j.jar里的一个包名】
对应jar包：

<dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
</dependency>

• maven使用clean命令时，运行会报：

Class not found: “dao.user.UserMapperTest”

• 第二次运行就正常了

• mybatis报日期的错：

   Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
  

  解决：

  在url后边加上 ?zeroDateTimeBehavior=convertToNull
  

url=jdbc:mysql://localhost:3306/数据库名?zeroDateTimeBehavior=convertToNull

测试类中：

count=sqlSession.selectOne("dao.user.UserMapper.count"); 

selectOne()里边的参数 是sql的xml映射文件里mapper的namespace属性的值打点sql语句的id属性值