springboot 集成mybaits 和mybaitsplus

参考文档

一、创建工程

 二、创建数据库

CREATE TABLE `user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `age` int NOT NULL,
  `tel` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3

三、 启动

1. 修改 application.properties 为 application.yml

2. 配置pom.xml 文件

#数据库连接池
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.9</version>
</dependency>
#简化用户创建**实体对象(POJO)**的过程
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

3. 配置application.yml

#配置端口
server:
  port: 8085
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatisplus_db?serverTimezone=UTC
    username: root
    password: 123456
#指定 myBatis 核心配置文件与 Mapper 映射 xml 文件
mybatis:
  config-location: classpath:mybatis/mybatis-config.xml
  mapper-locations: classpath:mybatis/mapper/*.xml

 4. 配置mapper、mybatis-config.xml、pojo 

5. 配置扫描

@SpringBootApplication
@MapperScan(value = {"com.it.mapper"})
public class Application {

    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }

}

6. 测试

    @Test
    void contextLoads() {
        User user = new User();
        user.setId(1);
        System.out.println(userMapper.findUserById(user));
    }

7. 使用注解方式

    @Select("select count(1) from user")
    int count();

四、集成mybaitsPlus

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

修改application.yml

mybatis-plus:
  config-location: classpath:mybatis/mybatis-config.xml
  mapper-locations: classpath:mybatis/mapper/*.xml

@Mapper
public interface UserMapper extends BaseMapper<User> {
    User findUserById(User user);

    @Select("select count(1) from user")
    int count();
}