SpringBoot整合Mybatis的一些总结和遇到的问题

SpringBoot整合Mybatis的一些总结和遇到的问题

闲来无事在家里创建了一个小项目，废话不多说先看下我的配置和工具
eclipse
jdk1.8
maven
先使用maven创建项目File->New->Maven Project 会出现如下弹框
点击我箭头所指位置选择工作空间，点击next然后选择如下图所示

点击next出现下图

GroupId和ArtifactId是为了定位项目的唯一坐标，具体怎么填写看个人，我就不多加赘述，点击Finsh创建项目完毕

这是创建之后的·项目的目录

现在我们来整合Mybatis 首先我们先看看项目中的pom.xml文件；

```java
<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/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.zd.demo</groupId>
  <artifactId>ZdpTwo</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>ZdpTwo Maven Webapp</name>
  <url>http://maven.apache.org</url>
  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
  </dependencies>
  <build>
    <finalName>ZdpTwo</finalName>
  </build>
</project>

这是刚创建项目之后的pom依赖，现在我们要在其中加入我们项目所需要的依赖

1.所有springboot项目都需要的依赖

  <parent>
  	<groupId>org.springframework.boot</groupId>
  	<artifactId>spring-boot-starter-parent</artifactId>
  	<version>1.4.3.RELEASE</version>
  </parent>

下面时我所用的一些依赖，比较多我就不一个个介绍了直接发出来

<dependencies>
  
  	<!-- web项目所必需的启动器 -->
  	<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
  
  	<!-- 单元测试所需依赖 -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    
    <!-- 支持使用JDBC访问数据库 -->
    <dependency>
    	<groupId>org.springframework.boot</groupId>
    	<artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    
    <!-- 添加适用于生产环境的功能，例如应用监控和性能指标等功能 -->
    <dependency>
    	<groupId>org.springframework.boot</groupId>
    	<artifactId>spring-boot-starter-actuator</artifactId>
    </dependency>
    
    <!-- Mybatis第三方依赖，用于集成第三方框架-->
<!--     <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.2.2</version>
    </dependency> -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.2.8</version>
    </dependency>
    <!--Mysql / DataSource -->
    <dependency>
        <groupId>org.apache.tomcat</groupId>
        <artifactId>tomcat-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.17</version>
    </dependency>
    <!--Json Support -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.1.43</version>
    </dependency>
    <!--Swagger support -->
    <dependency>
        <groupId>com.mangofactory</groupId>
        <artifactId>swagger-springmvc</artifactId>
        <version>0.9.5</version>
    </dependency>
     
    <!-- 支持jsp start -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>jstl</artifactId>
    </dependency>
    
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <scope>provided</scope>
    </dependency>

    <dependency>
        <groupId>org.apache.tomcat.embed</groupId>
        <artifactId>tomcat-embed-jasper</artifactId>
        <scope>provided</scope>
    </dependency>
    
    <dependency>
		<groupId>javax.servlet</groupId>
		<artifactId>javax.servlet-api</artifactId>
	</dependency>
	
	<dependency>
		<groupId>org.apache.commons</groupId>
		<artifactId>commons-text</artifactId>
		<version>1.6</version>
	</dependency>
	
    <dependency>
        <groupId>com.dangdang</groupId>
        <artifactId>config-toolkit</artifactId>
        <version>3.3.0-RELEASE</version>
    </dependency>
	
	<dependency>
	   <groupId>org.springframework.boot</groupId>
	   <artifactId>spring-boot-starter-aop</artifactId>
	</dependency>
    
  </dependencies>

到此为止SpringBoot项目就建立好了