MyBatisPlus

目录

一、添加依赖

二、配置数据源

三、在启动类上扫描dao的路径

四、创建实体并与数据库表关联

五、创建dao继承自BaseMapper

六、在controller中测试

第1步：通过AutoWired注解实例化dao对象

第2步：调用dao方法实现增删改查

运行效果

源码 

---

一、添加依赖

在pom.xml中加入依赖

<!-- MyBatisPlus依赖-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>
<!--LomBok依赖-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId> <optional>true</optional>
</dependency>
<!--mysql依赖-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

二、配置数据源

在application.yml中添加数据库

server:
  port: 8070
spring:
  # 配置数据源信息
  datasource:
    # 配置数据源类型
    type: com.zaxxer.hikari.HikariDataSource
    # 配置连接数据库信息
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/car_manager?characterEncoding=utf-8&useSSL=false
    username: root
    password: 123456

三、在启动类上扫描dao的路径

注意:路径前要是整个大包

package demo;

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

@SpringBootApplication
@MapperScan("demo.dao")
public class test {
    public static void main(String[] args) {
        SpringApplication.run(test.class,args);
    }
}

四、创建实体并与数据库表关联

实体类 

package demo.entity;

import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data//生成Set和Get方法,重写toString
@AllArgsConstructor//生成有参构造器
@NoArgsConstructor//生成无参构造器
@TableName("t_user")
public class User {
    @TableId//指定主键id
    private Long id;
    private String userName;
    private String passwd;
}

五、创建dao继承自BaseMapper

DAO继承BaseMapper后面放泛型,泛型里放实体类

package demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import demo.entity.User;

public interface UserDAO extends BaseMapper<User> {
}

六、在controller中测试

第1步：通过AutoWired注解实例化dao对象

第2步：调用dao方法实现增删改查

运行效果

源码 

package demo.controller;

import demo.dao.UserDAO;
import demo.entity.User;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@Slf4j
public class TestController {
    @RequestMapping("/test")
    public String test(){
        return "这是一个test";
    }
    @RequestMapping("/num")
    public int num(){

        return 1;
    }
    @RequestMapping("/user")
    public User t2(){
        User user = new User(1001l,"admin","123");
        System.out.println(user.toString());
        log.info(user.toString());
        log.warn(user.toString());;
        log.error(user.toString());

        return user;
    }
    @Autowired(required = false)
    private UserDAO dao;

    @RequestMapping("/insert")
    public int insertUser(){
        int count = dao.insert(new User(null, "zed ", "123"));

        return count;
    }
}