springboot + mybaties 第一个 web 项目

旧城等待， 2021-06-26 16:06 462阅读 0赞

**目录**

一、新建项目

二、application.yml 文件的配置信息

三、sqlMapConfig.xml

四、在启动类上 扫描 mapper 包（持久层）

五、配置完成了，自己写个demo测试下就好

--------------------

项目环境：

idea 2017 + maven + jdk

# 一、新建项目 #

记得选择下面的这些要导入的 jar 包选项。

![70][]

如果没有选的话，可以参考下面这份 pom.xml 补全。

<dependencies>
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-thymeleaf</artifactId>
    	</dependency>
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-web</artifactId>
    	</dependency>
    	
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-test</artifactId>
    		<scope>test</scope>
    	</dependency>
    	
    	<dependency>
    		<groupId>org.mybatis.spring.boot</groupId>
    		<artifactId>mybatis-spring-boot-starter</artifactId>
    		<version>1.3.2</version>
    	</dependency>
    	
    	<dependency>
    		<groupId>mysql</groupId>
    		<artifactId>mysql-connector-java</artifactId>
    		<scope>runtime</scope>
    	</dependency>
    	
    	<dependency>
    		<groupId>com.alibaba</groupId>
    		<artifactId>druid</artifactId>
    		<version>1.1.4</version>
    	</dependency>
    </dependencies>

最终的目录结构：

![70 1][]

![70 2][]

# 二、application.yml 文件的配置信息 #

server:
      port: 8080
      servlet:
        context-path: /
    
    spring:
      datasource:
        url: jdbc:mysql://localhost:3306/oa?useUnicode=true&characterEncoding=utf-8&useSSL=false
        username: root
        password: root
        driver-class-name: com.mysql.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
      thymeleaf:
        cache: false
    mybatis:
      config-location: classpath:mybatis/sqlMapConfig.xml
      mapper-locations: classpath:mapper/*.xml
      type-aliases-package: com.yyzheng.oa.dao

# 三、sqlMapConfig.xml  #

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        <settings>
            <setting name="callSettersOnNulls" value="true"/>
    
            <setting name="cacheEnabled" value="true"/>
    
            <setting name="lazyLoadingEnabled" value="true"/>
    
            <setting name="aggressiveLazyLoading" value="true"/>
    
            <setting name="multipleResultSetsEnabled" value="true"/>
    
            <setting name="useColumnLabel" value="true"/>
    
            <setting name="useGeneratedKeys" value="false"/>
    
            <setting name="autoMappingBehavior" value="PARTIAL"/>
    
            <setting name="defaultExecutorType" value="SIMPLE"/>
    
            <setting name="mapUnderscoreToCamelCase" value="true"/>
    
            <setting name="localCacheScope" value="SESSION"/>
    
            <setting name="jdbcTypeForNull" value="NULL"/>
    
        </settings>
    
        
        <typeAliases>
            <typeAlias alias="Integer" type="java.lang.Integer" />
            <typeAlias alias="Long" type="java.lang.Long" />
            <typeAlias alias="HashMap" type="java.util.HashMap" />
            <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" />
            <typeAlias alias="ArrayList" type="java.util.ArrayList" />
            <typeAlias alias="LinkedList" type="java.util.LinkedList" />
        </typeAliases>
    
    </configuration>

# 四、在启动类上 扫描 mapper 包（持久层） #

![70 3][]

# 五、配置完成了，自己写个demo测试下就好 #

[70]: /images/20210626/34ce6467b8864a58b6b2c22af1f976f3.png
[70 1]: /images/20210626/539f65a8bfb845708be4592c21f08ef1.png
[70 2]: /images/20210626/8342139f0f21427f80be702ca3decb3d.png
[70 3]: /images/20210626/9b28ef75675e419e8263d2d123e98cb4.png