MybatisPlus（MP）快速入门

创建工程
这里采用的是Springboot的项目 就不演示创建了
添加依赖

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

---

导入sql脚本

CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_name` varchar(20) NOT NULL COMMENT '用户名',
  `password` varchar(20) NOT NULL COMMENT '密码',
  `name` varchar(30) DEFAULT NULL COMMENT '姓名',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `address` varchar(100) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

insert  into `user`(`id`,`user_name`,`password`,`name`,`age`,`address`) values (1,'ruiwen','123','瑞文',12,'山东'),(2,'gailun','1332','盖伦',13,'平顶山'),(3,'timu','123','提姆',22,'蘑菇石'),(4,'daji','1222','妲己',221,'狐山');

实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Long id;
    private String user_name;
    private String password;
    private String name;
    private String age;
    private String addressStr;
}

Mapper接口

public interface UserMapper extends BaseMapper<User> {
}

SpringBoot的启动类

@SpringBootApplication
@MapperScan("com.hgzy.mapper")
public class Springboot01MpApplication {
    public static void main(String[] args) {
        SpringApplication.run(Springboot01MpApplication.class, args);
    }
}

---

yml的配置

server:
  port: 80

# SpringBoot 整合druid相关配置
spring:
  datasource:
      url: jdbc:mysql://localhost:3306/mp?characterEncoding=utf-8&serverTimezone=UTC
      username: root
      password: 317311
      driver-class-name: com.mysql.cj.jdbc.Driver
mybatis-plus:
  #      开启日志
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
   #      使用数据库的自动增长 默认使用雪花算法
    db-config:
     

整体结构

---

测试

@SpringBootTest
class Springboot01MpApplicationTests {
    @Autowired
    UserMapper userMapper;
    @Test
    
    // 查询id为1的用户
    void contextLoads() {
        System.out.println(userMapper.selectById(1));
    }
  }