SpringBoot（02）整合MybatisPlus()-MyBatis

SpringBoot（02）整合MybatisPlus()

1.引入相关依赖

<!-- 数据库池 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.6</version>
</dependency>
<!-- mysql 依赖-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

<!--mybatis-plus 依赖-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.3</version>
</dependency>

<!-- lombok -->
<!--
  用来简化 setter/getter 和其他相关 pojo 类的操作
-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

<!-- 测试 -->
<!--
  用来进行测试的依赖
-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>

2.yml配置

yml

server:
  port: 80

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

mybatis-plus:
  global-config:
    db-config:
      table-prefix: tbl_
      id-type: auto

3.pojo类

pojo

import lombok.Data;

@Data // lombok
public class Book {
    private Integer id;
    private String type;
    private String name;
    private String description;
    private String fileurl;
}

4.BookDao

BookDao

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ssp.pojo.Book;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface BookDao extends BaseMapper<Book> {
}

5. BookService接口和实现类

BookService

import com.baomidou.mybatisplus.extension.service.IService;
import com.ssp.pojo.Book;

import java.util.List;

public interface IBookService extends IService<Book> {

    List<Book> getAll();

}

@Service
public class BookServiceImpl extends ServiceImpl<BookDao, Book> implements IBookService {

    @Autowired
    private BookDao bookDao;

    @Override
    public List<Book> getAll() {
        return bookDao.selectList(null);
    }
}

5.BookController

BookController

@RestController
@RequestMapping("/book")
public class BookController {
    
    @Autowired
    private IBookService bookService;
    
    @GetMapping()
    public List<Book> list(){
        return bookService.list();
    }
}

6.启动项目

在地址栏输入
得到全部Book的结果，整合成功！

在地址栏输入
得到全部Book的结果，整合成功！

http://localhost/book

1.引入相关依赖

<!-- 数据库池 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.6</version>
</dependency>
<!-- mysql 依赖-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

<!--mybatis-plus 依赖-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.3</version>
</dependency>

<!-- lombok -->
<!--
  用来简化 setter/getter 和其他相关 pojo 类的操作
-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

<!-- 测试 -->
<!--
  用来进行测试的依赖
-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>

2.yml配置

yml

server:
  port: 80

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

mybatis-plus:
  global-config:
    db-config:
      table-prefix: tbl_
      id-type: auto

3.pojo类

pojo

import lombok.Data;

@Data // lombok
public class Book {
    private Integer id;
    private String type;
    private String name;
    private String description;
    private String fileurl;
}

4.BookDao

BookDao

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ssp.pojo.Book;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface BookDao extends BaseMapper<Book> {
}

5. BookService接口和实现类

BookService

import com.baomidou.mybatisplus.extension.service.IService;
import com.ssp.pojo.Book;

import java.util.List;

public interface IBookService extends IService<Book> {

    List<Book> getAll();

}

@Service
public class BookServiceImpl extends ServiceImpl<BookDao, Book> implements IBookService {

    @Autowired
    private BookDao bookDao;

    @Override
    public List<Book> getAll() {
        return bookDao.selectList(null);
    }
}

5.BookController

BookController

@RestController
@RequestMapping("/book")
public class BookController {
    
    @Autowired
    private IBookService bookService;
    
    @GetMapping()
    public List<Book> list(){
        return bookService.list();
    }
}

6.启动项目

在地址栏输入
得到全部Book的结果，整合成功！

在地址栏输入
得到全部Book的结果，整合成功！

http://localhost/book