Spring笔记(8):SpringBoot整合mybatis

最新推荐文章于 2025-07-24 17:10:39 发布

原创最新推荐文章于 2025-07-24 17:10:39 发布 · 235 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#spring #spring boot #java

Spring学习笔记专栏收录该内容

10 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中集成Mybatis，包括设置依赖、配置数据库连接、指定mapper和实体类路径，以及使用注解方式简化配置。从编写映射文件到调用SQL，提供了完整的步骤和关键代码示例。

构建项目时选好mybatis的依赖

在这里插入图片描述

使用映射文件的访问方法

配置连接源信息包括mybatis的配置信息

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

#指定mapper文件位置
mybatis.mapper-locations=classpath:mapper/*Mapper.xml 
#指定各映射数据类的包位置
mybatis.type-aliases-package=com.cakecn.domain

SpringBoot启动类要注解mybatis的注解扫描包路径

package com.cakecn.springboot_test04;

import com.cakecn.mapper.UserMapper;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;



@SpringBootApplication(scanBasePackages = "com.cakecn") //Web控制类的扫描路径
@MapperScan("com.cakecn.mapper") //mybatis映射类的扫描位置
public class SpringbootTest04Application {

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

}

数据实体类

package com.cakecn.domain;

public class User {
    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int 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;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

编写接口类作为mybatis调用SQL的途径

package com.cakecn.mapper;

import com.cakecn.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper //标记是mybatis的映射接口类
@Repository //加上  取消错误误报
public interface UserMapper {
    //@Select("select * from t_user") 这里是使用mybatis注解时需要的代码
    public List<User> findAll();
}

Mapper.xml文件，配置映射方法对应的SQL语句

namespace中为映射接口类，表映射文件和映射接口的对应关系
其它内容与springmvc中的运用一致

<?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.cakecn.mapper.UserMapper">
    <select id="findAll" resultType="User">
        select * from t_user
    </select>
</mapper>

示例控制类

package com.cakecn.controller;

import com.cakecn.domain.User;
import com.cakecn.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class MainController {
    @Autowired
    private UserMapper userMapper;

    @RequestMapping("/save")
    public String save(){
        List<User> list = userMapper.findAll();
        System.out.println(list);
        return "success";
    }
}