springboot整合mybatis-plus

目录

前言

maven依赖

属性配置

目录结构

entity

controller

service

serviceImpl

mapper

mapper.xml

测试

结束语 

---

前言

在之前的文章中我们已经搭建好springboot加nacos了，现在我们来实现一下怎么从数据库中获取数据吧。

springboot整合nacos(2.x版本)-CSDN博客

maven依赖

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

<dependency>
   <groupId>com.mysql</groupId>
   <artifactId>mysql-connector-j</artifactId>
   <version>8.0.33</version>
</dependency>


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

属性配置

可以写在本地的application.yaml文件中，也可以写在nacos的配置文件中

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
    username: root
    password: root

目录结构

entity

package com.lyy.demo3.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

/**
 * @Description: TODO(这里用一句话描述这个类的作用)
 * @Author ly
 * @Date 2023/10/1721:48
 */
@Data
@TableName("roles")
public class Roles {

    private String username;
    private String role;

}

controller

package com.lyy.demo3.controller;

import com.lyy.demo3.entity.Roles;
import com.lyy.demo3.service.RolesService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

/**
 * @Description: TODO(这里用一句话描述这个类的作用)
 * @Author ly
 * @Date 2023/10/1721:57
 */
@RestController
@RequestMapping("/roles")
public class RolesController {

    @Autowired
    private RolesService rolesService;

    @GetMapping("/query")
    public Roles queryRoles(@RequestParam("username") String username){
        return rolesService.queryRoles(username);
    }
}

service

package com.lyy.demo3.service;

import com.lyy.demo3.entity.Roles;

public interface RolesService {

    Roles queryRoles(String username);
}

serviceImpl

package com.lyy.demo3.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.lyy.demo3.entity.Roles;
import com.lyy.demo3.mapper.RolesMapper;
import com.lyy.demo3.service.RolesService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Description: TODO(这里用一句话描述这个类的作用)
 * @Author ly
 * @Date 2023/10/1721:54
 */
@Service
public class RolesServiceImpl extends ServiceImpl<RolesMapper, Roles> implements RolesService {

    @Autowired
    private RolesMapper rolesMapper;

    @Override
    public Roles queryRoles(String username) {
        return rolesMapper.queryRoles(username);
    }
}

mapper

package com.lyy.demo3.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lyy.demo3.entity.Roles;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * @Description: TODO(这里用一句话描述这个类的作用)
 * @Author ly
 * @Date 2023/10/1721:47
 */
@Mapper
public interface RolesMapper extends BaseMapper<Roles> {

    Roles queryRoles(@Param("username") String username);
}

mapper.xml

<?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.lyy.demo3.mapper.RolesMapper">

    <select id="queryRoles" resultType="com.lyy.demo3.entity.Roles">
        select * from roles where username = #{username}
    </select>

</mapper>

测试

结束语 

已经完成了springboot对mybayis-plus的整合了，接下来添加一下链接池druid。