mybatis-plus快速入門體驗

1、快速入門體驗

• 準備一個資料庫表

  DROP TABLE IF EXISTS user;
  
  CREATE TABLE user
  (
  	id BIGINT(20) NOT NULL COMMENT '主鍵ID',
  	name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
  	age INT(11) NULL DEFAULT NULL COMMENT '年齡',
  	email VARCHAR(50) NULL DEFAULT NULL COMMENT '郵箱',
  	PRIMARY KEY (id)
  );
  
             

• 插入資料

  DELETE FROM user;
  
  INSERT INTO user (id, name, age, email) VALUES
  (1, 'Jone', 18, '[email protected]'),
  (2, 'Jack', 20, '[email protected]'),
  (3, 'Tom', 28, '[email protected]'),
  (4, 'Sandy', 21, '[email protected]'),
  (5, 'Billie', 24, '[email protected]');
  
             

• 引入依賴

<dependencies>
          <dependency>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-starter</artifactId>
          </dependency>
  
          <dependency>
              <groupId>org.projectlombok</groupId>
              <artifactId>lombok</artifactId>
              <version>1.18.12</version>
          </dependency>
          <dependency>
              <groupId>mysql</groupId>
              <artifactId>mysql-connector-java</artifactId>
              <version>8.0.21</version>
          </dependency>
          <dependency>
              <groupId>com.baomidou</groupId>
              <artifactId>mybatis-plus-boot-starter</artifactId>
              <version>3.4.1</version>
          </dependency>
  
          <dependency>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-starter-test</artifactId>
              <scope>test</scope>
          </dependency>
      </dependencies>
           

• 配置資料庫連接配接

  spring:
    datasource:
      driver-class-name: com.mysql.jdbc.Driver
      url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
      username: root
      password:
             

• 在啟動類中添加@MapperScan注解，掃描mapper檔案夾

• 編寫Mapper類

  @Repository
  public interface  UserMapper extends BaseMapper<User> {
  }
             

• 測試

  @SpringBootTest
  class MybatisPlusApplicationTests {
  
      @Autowired
      private UserMapper userMapper;
  
      @Test
      void contextLoads() {
          List<User> users = userMapper.selectList(null);
          for (User user : users) {
              System.out.println(user);
          }
      }
  
  }
             

2、配置日志

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl