SpringBoot整合Mybatis(使用配置文件方式)

分手后的思念是犯贱 2022-04-22 02:20 303阅读 0赞

**1.首先看下一下maven的依赖，主要是mybatis依赖，mysql驱动，以及之后测试使用的依赖spring-boot-test**

<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>
    		</dependency>
    		<dependency>
    			<groupId>org.junit.jupiter</groupId>
    			<artifactId>junit-jupiter-api</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-test</artifactId>
    			<version>5.1.2.RELEASE</version>
    			<scope>compile</scope>
    		</dependency>
    		<dependency>
    			<groupId>junit</groupId>
    			<artifactId>junit</artifactId>
    			<version>4.12</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-test</artifactId>
    		</dependency>

**2.其次在application.properties文件中配置mybatis的mapper文件位置，和实体类的包路径，还有最好加上驼峰命名规范**

####mybatis配置
    # 注意注意
    mybatis.mapper-locations=classpath:edu/hohai/chapter1/gt/mapper/*.xml
    #mybatis.mapper-locations=classpath:mapper/*.xml   #这种方式需要自己在resources目录下创建mapper目录然后存放xml
    mybatis.type-aliases-package=edu.hohai.chapter1.gt.entity
    # 驼峰命名规范 如：数据库字段是  order_id 那么 实体字段就要写成 orderId
    mybatis.configuration.map-underscore-to-camel-case=true

看下项目结构：这里我把Mapper类和Mapper映射文件放在了一起，这时候我们还需要做下面设置，让springboot能在java包中扫描xml文件（springboot默认扫描的是包中的\*.java文件），如果使用resources目录下面的xml，这打开上面的

mybatis.mapper-locations=classpath:mapper/*.xml

项目结构图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0Nyb25vdXNHVA_size_16_color_FFFFFF_t_70][]

**3.设置springboot在包中扫描xml文件**

<build>
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    				<configuration>
    					<fork>true</fork>
    				</configuration>
    			</plugin>
    		</plugins>
    
    		
    		<resources>
    			<resource>
    				<directory>src/main/resources</directory>
    			</resource>
    			<resource>
    				<directory>src/main/java</directory>
    				<includes>
    					<include>**/*.xml</include>
    				</includes>
    				<filtering>true</filtering>
    			</resource>
    		</resources>
    </build>

**4.UserMapper.java  UserMapper.xml**

package edu.hohai.chapter1.gt.mapper;
    
    import edu.hohai.chapter1.gt.entity.User;
    import org.apache.ibatis.annotations.Mapper;
    
    /**
     * @author cronous
     * @create 2018-11-01 15:04
     */
    @Mapper //注意这里的Mapper注解
    public interface UserMapper {
    
        int insert(User user);
    }

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="edu.hohai.chapter1.gt.mapper.UserMapper">
    
        <insert id="insert" parameterType="edu.hohai.chapter1.gt.entity.User">
        INSERT INTO `t_user`(`username`,`password`) VALUES (#{username},#{password})
      </insert>
    
    </mapper>

**5.数据库表**

CREATE TABLE `t_user` (
      `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
      `username` varchar(50) NOT NULL COMMENT '用户名',
      `password` varchar(50) NOT NULL COMMENT '密码',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='用户表';

**6.测试**

package edu.hohai.chapter1;
    
    import edu.hohai.chapter1.gt.entity.User;
    import edu.hohai.chapter1.gt.mapper.UserMapper;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    
    /**
     * @author cronous
     * @create 2018-11-01 15:20
     */
    @RunWith(SpringRunner.class)
    @SpringBootTest
    public class ChapterTest {
    
        private static final Logger log = LoggerFactory.getLogger(ChapterTest.class);
    
        @Autowired
        private UserMapper userMapper;
    
        @Test
        public void test1() throws Exception {
    
    
            final int row1 = userMapper.insert(new User("u1", "p1"));
            log.info("[添加结果] - [{}]", row1);
            final int row2 = userMapper.insert(new User("u2", "p2"));
            log.info("[添加结果] - [{}]", row2);
            final int row3 = userMapper.insert(new User("u1", "p3"));
            log.info("[添加结果] - [{}]", row3);
    
    
        }
    }

**7.查看数据库**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0Nyb25vdXNHVA_size_16_color_FFFFFF_t_70 1][]

发现已经写入数据库，测试完成

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0Nyb25vdXNHVA_size_16_color_FFFFFF_t_70]: /images/20220422/c970f5bbf8774a90b00a0455f355b007.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0Nyb25vdXNHVA_size_16_color_FFFFFF_t_70 1]: /images/20220422/acda87ca373a4c2bb13f197ceb7180d0.png