Springboot mybatis-plus配置及用法代码解析

本篇文章小编给大家分享一下Springboot mybatis-plus配置及用法代码解析，文章代码介绍的很详细，小编觉得挺不错的，现在分享给大家供大家参考，有需要的小伙伴们可以来看看。

1.mybatis-plus初步实例

（1）创建一个spring boot web工程(具体创建过程就不再演示了，还不会的同学去看看spring boot专题第一节内容)

（2）引入依赖

 
   org.springframework.boot
   spring-boot-starter-web
 
 
 
   org.springframework.boot
   spring-boot-starter-validation
 
 
 
   com.baomidou
   mybatis-plus-boot-starter
   3.4.0
 
 
 
   mysql
   mysql-connector-java
 
 
 
   org.springframework.boot
   spring-boot-starter-thymeleaf
 
 
 
   org.projectlombok
   lombok
   true
 

(3)配置文件application.yml

# DataSource Config
 spring:
  datasource:
   username: root
   password: tx@mysql@2020
   url: jdbc:mysql://188.131.233.55:3306/spring_boot_topic
   driver-class-name: com.mysql.cj.jdbc.Driver（4）

(4)实体类User

package com.kinglead.demo.domain;
 import com.baomidou.mybatisplus.annotation.TableName;
 import lombok.Data;
 
 @Data
 @TableName(value = "t_user") //指明数据库表名
 public class User {
   private Long id;
   private String name;
   private Integer age;
   private String email;
 }

(5)创建Mapper接口

package com.kinglead.demo.mapper;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.kinglead.demo.domain.User;
 
 //未来使用mybatis-plus的公共接口，必须继承BaseMapper
 public interface UserMapper extends BaseMapper {
 }

(6)创建Service接口

UserService

package com.kinglead.demo.service;
 import com.kinglead.demo.domain.User;
 import java.util.List;
 public interface UserService {
   List queryUserList();
 }

UserServiceImpl

package com.kinglead.demo.service.impl;
 
 import com.kinglead.demo.domain.User;
 import com.kinglead.demo.mapper.UserMapper;
 import com.kinglead.demo.service.UserService;
 import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
 import java.util.List;
 
 @Service
 public class UserServiceImpl implements UserService {
   @Resource
   private UserMapper userMapper;
   @Override
   public List queryUserList() {
     //使用mybatis-plus公共查询接口完成列表查询
     return userMapper.selectList(null);
   }
 }

(7)创建controller

package com.kinglead.demo.controller;
 
 import com.kinglead.demo.domain.User;
 import com.kinglead.demo.service.UserService;
 import org.springframework.stereotype.Controller;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.servlet.ModelAndView;
 
 import javax.annotation.Resource;
 import java.util.List;
 
 @Controller
 @RequestMapping("/user")
 public class UserController {
 
   @Resource
   private UserService userService;
 
   @RequestMapping("/userList")
   public ModelAndView queryUserList(ModelAndView modelAndView){
     List userList = userService.queryUserList();
     modelAndView.addObject("userList", userList);
     modelAndView.setViewName("userList");
     return modelAndView;
   }
 
 }

(8)用户列表页面

 
   
     
     
     
     
   
   
     

       
用户列表
     
     >
         

       

         
序号
         
编码
         
用户名
       
       

       

         

         

       
       
     
   
 

(9)启动类

package com.kinglead.demo;
 import org.mybatis.spring.annotation.MapperScan;
 import org.springframework.boot.SpringApplication;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
 @SpringBootApplication
 @MapperScan("com.kinglead.demo.mapper")
 public class App {
   public static void main(String[] args) {
     SpringApplication.run(App.class, args);
   }
 }

(10)测试访问