1.SpringBoot整合Mybatis

最新推荐文章于 2024-04-16 23:20:35 发布

喝瓶冰阔乐

最新推荐文章于 2024-04-16 23:20:35 发布

阅读量205

点赞数

CC 4.0 BY-SA版权

分类专栏： SpringBoot 文章标签： mybatis spring spring boot

本文链接：https://blog.csdn.net/weixin_44269312/article/details/104246334

SpringBoot 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍如何在SpringBoot项目中整合Mybatis，包括配置Maven依赖，设置application.yml，创建数据库表，编写POJO、Mapper、Service和Controller类，以及启动类的编写。通过访问特定URL，成功展示数据库查询结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.SpringBoot整合Mybatis

File| New|Project |Spring Initializr|
选择需要的组件：
配置Maven:
修改配置文件

application.yml

spring:
  profiles:
    active: dev

application.yml-dev

server:
  port: 8080
spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
#  让mybatis自动扫描到自定义POJO
    type-aliases-package: com.example.pojo

test数据库建立user表并添加数据测试：

id int 20 primarykey
name varchar 20

在com.example下建立pojo、mapper、service、controller包
pojo->User.java

package com.example.pojo;

public class User {
    int id;
    String name;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

mapper->UserMapper.java

package com.example.mapper;

import com.example.pojo.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper {
    @Select("select * from user where id=#{id}")
    User getUserById(@Param("id") int id);
}

service->UserService.java

package com.example.service;

import com.example.mapper.UserMapper;
import com.example.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;
    public User getUserById(int id){
        return userMapper.getUserById(id);
    }
}

controller->UserController.java

package com.example.controller;

import com.example.pojo.User;
import com.example.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("user")
public class UserController {
    @Autowired
    private UserService userService;
    @GetMapping("get/{id}")
    public User getUserById(@PathVariable int id){ return this.userService.getUserById(id);}
}

编写启动类：Springbootdemo1Application.java

package com.example;

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

@SpringBootApplication
//扫描mapper
@MapperScan("com.example.mapper")
public class Springbootdemo1Application {

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