mybatis-plus的使用

最新推荐文章于 2025-06-10 18:06:27 发布

Tony-1fan

最新推荐文章于 2025-06-10 18:06:27 发布

阅读量107

点赞数

分类专栏：框架文章标签： spring mybatis mybatis-plus

本文链接：https://blog.youkuaiyun.com/qq_39497997/article/details/119335076

版权

框架专栏收录该内容

9 篇文章

订阅专栏

1. 导入依赖

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.2.1.RELEASE</version>
</parent>

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>


    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.0.5</version>
    </dependency>

    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.10</version>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.22</version>
    </dependency>
</dependencies>

<build>
    <resources>
        <!-- mapper.xml文件在java目录下
                idea默认只能识别resources目录下面的xml文件,不能识别我们自己包中的xml文件,所以我们需要自己构建时指定
            -->
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.xml</include>
            </includes>
        </resource>
    </resources>
</build>

2. 配置数据源

server.port=8080
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#数据库数据源的配置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/db1?serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=root

#配置XXXmapper.xml的路径
mybatis-plus.mapper-locations=classpath:/com/xkd/goods/mapper/*.xml

3. 编写Mapper接口

package com.xkd.goods.mapper;
import com.xkd.goods.entity.User;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface UserMapper {
    User selectById(Integer id);
}

3. 访问接口

package com.xkd.goods.controller;
import com.xkd.goods.entity.User;
import com.xkd.goods.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserMapper userMapper;

    @GetMapping("/findById")
    public void findById() {
        System.out.println("请求进来了...");
        User user = userMapper.selectById(1);
        System.out.println(user);
    }
}