Mybatis搭建以及常见问题.

1.maven仓库:

  <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
  <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
  </dependency>

2.搭建环境

 1)搭建数据库:

  
  CREATE DATABASE `mybatis`
  ​
  USE `mybatis`
  ​
  CREATE TABLE `user`(
  `id` INT(20) NOT NULL PRIMARY KEY,
  `name` VARBINARY(30) DEFAULT NULL,
  `pwd` VARBINARY(30) DEFAULT NULL
  )ENGINE=INNODB DEFAULT CHARSET=utf8;
  ​
  INSERT INTO `user`(`id`,`name`,`pwd`) VALUES
  (1,'苏立伟','123456'),
  (2,'北京','123456'),
  (3,'java','143253')

 2)新建项目:

新建一个普通夫人maven项目 ---- Mybatis-Study

导入maven项目依赖如下

  
  <!--导入依赖-->
      <dependencies>
          <!--mysql驱动-->
          <dependency>
              <groupId>mysql</groupId>
              <artifactId>mysql-connector-java</artifactId>
              <version>8.0.33</version>
          </dependency>
          <!--mybatis-->
          <dependency>
              <groupId>org.mybatis</groupId>
              <artifactId>mybatis</artifactId>
              <version>3.5.6</version>
          </dependency>
          <!--junit-->
          <dependency>
              <groupId>junit</groupId>
              <artifactId>junit</artifactId>
              <version>4.12</version>
          </dependency>
      </dependencies>

!注意点:org.apache.ibatis.binding.BindingException: Type interface com.kuang.dao.UserDao is not known to the MapperRegistry.

MapperRegistry是什么? 在核心配置文件中注册Mappers

      <!--在build中配置resources, 来防止我们资源导出失败问题-->
      <build>
          <resources>
              <resource>
                  <directory>src/main/java</directory>
                  <includes>
                      <include>**/*.xml</include>
                      <include>**/*.properties</include>
                  </includes>
              </resource>
  ​
              <resource>
                  <directory>src/main/resources</directory>
                  <includes>
                      <include>**/*.xml</include>
                      <include>**/*.properties</include>
                  </includes>
                  <filtering>true</filtering>
              </resource>
          </resources>
      </build>

3.搭建顺序: