spring-boot学习（一）之spring-boot整合mybatis

绝地灬酷狼 2023-06-19 04:22 19阅读 0赞

## spring-boot整合mybatis ##

## 1.pom.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    <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/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.10.RELEASE</version>
        </parent>
    
        <groupId>com.bjsxt</groupId>
        <artifactId>springboot-mybatis</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <dependencies>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.1</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
            </dependency>
        </dependencies>
    
    </project>

## 2.创建实体类User ##

package com.bjsxt.entity;
    
    import java.io.Serializable;
    import java.util.Objects;
    
    public class User implements Serializable {
        private Integer id;
        private String username;
        private String password;
    
        @Override
        public String toString() {
            return "User{" +
                    "id=" + id +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    '}';
        }
    
        @Override
        public boolean equals(Object o) {
            if (this == o) return true;
            if (o == null || getClass() != o.getClass()) return false;
            User user = (User) o;
            return Objects.equals(id, user.id) &&
                    Objects.equals(username, user.username) &&
                    Objects.equals(password, user.password);
        }
    
        @Override
        public int hashCode() {
            return Objects.hash(id, username, password);
        }
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getUsername() {
            return username;
        }
    
        public void setUsername(String username) {
            this.username = username;
        }
    
        public String getPassword() {
            return password;
        }
    
        public void setPassword(String password) {
            this.password = password;
        }
    
        public User() {
        }
    
        public User(Integer id, String username, String password) {
            this.id = id;
            this.username = username;
            this.password = password;
        }
    }

## 3.创建mapper接口UserMapper ##

package com.bjsxt.mapper;
    
    import com.bjsxt.entity.User;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    /**
     * springboot环境中使用mybatis注解开发，则不需要提供任何配置文件
     * 因为@Mapper注解会通知springboot容器，到当前接口同名包中找同名的.xml配置文件，
     * 生成动态代理对象。
     */
    
    @Mapper
    public interface UserMapper {
        @Insert("insert into my_user(id,username,password) values (#{id},#{username},#{password})")
        int insertUser(User user);
        @Select("select  id,username,password from my_user")
        List<User> selectAllUser();
    }

创建对应的UserMapper.xml---->创建位置在resources/com/bjsxt/mapper下

<?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="com.bjsxt.mapper.UserMapper">
        
        <insert id="insertUser">
            insert into my_user(id,username,password) values (#{id},#{username},#{password}) ;
    
            <selectKey keyColumn="id" keyProperty="id" order="AFTER">
                select @@identity as id;
            </selectKey>
        </insert>
    
        <select id="selectAllUser" resultType="com.bjsxt.entity.User">
            select  id,username,password from my_user;
        </select>
    
    
    
    </mapper>

## 4.配置文件application.properties ##

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2D8
    
    # mybatis生成mapper动态代理需要什么？
    # springboot自动创建sqlsessionFactoryBean
    mybatis.type-aliases-package=com.bjsxt.entity
    # 配置mapper扫描的配置
    mybatis.config-location=classpath:com/bjsxt/mapper/*.xml

## 5.创建启动类 ##

package com.bjsxt;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    public class SpringMybatisApp {
        public static void main(String[] args) {
            SpringApplication.run(SpringMybatisApp.class,args);
        }
    }

## 6.创建测试类 ##

package com.bjsxt.test;
    
    import com.bjsxt.SpringMybatisApp;
    import com.bjsxt.entity.User;
    import com.bjsxt.mapper.UserMapper;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    import java.util.List;
    
    
    @RunWith(value = SpringRunner.class)
    @SpringBootTest(classes = SpringMybatisApp.class)
    public class TestMybatis {
        @Autowired
        private UserMapper userMapper;
    
        @Test
        public void testInsert(){
            User user = new User();
            user.setUsername("admin7");
            user.setPassword("admin7");
            this.userMapper.insertUser(user);
            System.out.println(user);
        }
        @Test
        public void testSelect(){
            List<User> userList = this.userMapper.selectAllUser();
            for(User user:userList){
                System.out.println(user);
            }
        }
    
    
    }