Spring Boot整合Mybatis

推荐课程：SpringBoot整合Mybatis_哔哩哔哩_bilibili

目录

1> 创建数据库，创建表

2> 创建项目，导入逆向工程相对应的依赖与配置

3> 配置application.yml

4> 实体/mapper接口/mapper.xml映射文件/业务逻辑接口/业务逻辑实现

5> 创建控制类，调用 业务逻辑接口 来处理用户相关的业务逻辑

6> 运行启动类，观察返回结果

---

• 1> 创建数据库，创建表
• 2> 创建项目，导入逆向工程相对应的依赖与配置
• 3> 配置application.yml
• 4> 逆向工程创建  实体/mapper接口/mapper.xml映射文件/业务逻辑接口/业务逻辑实现
• 5> 创建控制类，调用 业务逻辑接口 来处理用户相关的业务逻辑
• 6> 运行启动类，观察返回结果

 （从UserController起始）

1> 创建数据库，创建表

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '姓名',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '类型',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `sex` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
  `hobby` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '爱好',
  `identity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '身份',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '咸瑜', '编程爱好者', '18', '男', 'Java、C、E、Python', '学生');
INSERT INTO `user` VALUES ('2', '罗老师', '法律讲师', '18', '男', '张三、普法、宣传、演讲', '教授');
INSERT INTO `user` VALUES ('3', '谭老师', '编程讲师', '50', '男', 'C语言、C++、Java', '教授');

2> 创建项目，导入逆向工程相对应的依赖与配置

<?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 https://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>3.2.4</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>springboot-mybatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springboot-mybatis</name>
    <description>springboot-mybatis</description>
    <properties>
        <java.version>21</java.version>
    </properties>


    <dependencies>
        <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>3.0.3</version>
        </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-test</artifactId>
            <version>3.0.3</version>
            <scope>test</scope>
        </dependency>

        <!-- mysql -->
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>

        <!-- druid数据库连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.18</version>
        </dependency>

        <!-- lang工具包 -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-lang3</artifactId>
            <version>3.8.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

3> 配置application.yml

# 连接池
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8
    username: root
    password: 123456
    druid:
      driver-class-name: com.mysql.jdbc.Driver

# 日志配置
logging:
  level:
    com:
      example:
        boot: debug

# mybatis
mybatis:
  # Mapper文件存放位置 classpath：指向的是 resources 文件夹
  mapper-locations: classpath:/mapper/*.xml
  # 是否开启驼峰命名，Ming =  m_ing，不区分大小写，下划线
  map-underscore-to-camel-case: true
  # 包 - 别名，把实体类包名注册为别名，在 SQL 映射文件中使用这些别名代替实体类的全限定名
  type-aliases-package: com.example.boot.entity

4> 实体/mapper接口/mapper.xml映射文件/业务逻辑接口/业务逻辑实现

User.java 

package com.example.boot.entity;

public class User {
    private Integer id;
    private String name;
    private String type;
    private Integer age;
    private String sex;
    private String hobby;
    private String identity;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getHobby() {
        return hobby;
    }

    public void setHobby(String hobby) {
        this.hobby = hobby;
    }

    public String getIdentity() {
        return identity;
    }

    public void setIdentity(String identity) {
        this.identity = identity;
    }


    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", type='" + type + '\'' +
                ", age=" + age +
                ", sex='" + sex + '\'' +
                ", hobby='" + hobby + '\'' +
                ", identity='" + identity + '\'' +
                '}';
    }

}

UserMapper.java

package com.example.boot.mapper;

import com.example.boot.entity.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper {
    /**
     * 新增
     * @param user
     * @return
     */
    int insert(User user);
    /**
     * 删除
     * @param user
     * @return
     */
    int delete(User user);
    /**
     * 修改
     * @param user
     * @return
     */
    int update(User user);
    /**
     * 查询
     * @param user
     * @return
     */
    List<User> select(User user);
    /**
     * 根据用户名查询
     * @param userName
     * @return
     */
    User selectByName(String userName);

    /**
     * 查找所有用户
     * @param
     * @return
     */
    List<User> FindAllUser();


}

UserMapper.xml 

• <mapper> 标签用于包裹映射文件中的内容，namespace 属性指定了映射文件对应的 Mapper 接口的全限定名；
• <select> 标签定义了一个查询语句，id 属性指定了方法名，resultType 属性指定了返回结果的类型；
• <insert> 标签定义了一个插入语句，id 属性指定了方法名，parameterType 属性指定了传入参数的类型。
• <update> 标签用于定义更新语句。
• <delete> 标签用于定义删除语句。

<?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.example.boot.mapper.UserMapper">
    <select id="FindAllUser" resultType="User">
        select * from user;
    </select>
</mapper>

 UserService.java

package com.example.boot.service;

import com.example.boot.entity.User;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public interface UserService {
    List<User> FindAllUser();
}

UserServiceImpl.java

package com.example.boot.service.impl;

import com.example.boot.entity.User;
import com.example.boot.mapper.UserMapper;
import com.example.boot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;

import java.util.List;

@Component
public class UserServiceImpl implements UserService {

    @Autowired
    // 在上面的例子中，@Autowired 注解用于将 UserMapper 类型的 Bean 注入到 UserService 类中
    private UserMapper UserMapper;

    @Override
    public List<User> FindAllUser() {
        List<User> allUser = UserMapper.FindAllUser();
        return allUser;
    }
}

5> 创建控制类，调用 业务逻辑接口 来处理用户相关的业务逻辑

UserController.java 

package com.example.boot.controller;

import com.example.boot.entity.User;
import com.example.boot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class UserController {
    @Autowired
    private UserService userService;

    @GetMapping("/user")
    public List<User> getAllUser(){
        List<User> allUser = userService.FindAllUser();
        return allUser;
    }
}

6> 运行启动类，观察返回结果

App.java

package com.example.boot;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
//@MapperScan("com.example.boot.mapper")
public class App {

    public static void main(String[] args) {
        SpringApplication.run(App.class, args);
    }

}

运行启动类，访问localhost:8080/user