SpringBoot使用Mybatis Plus

SpringBoot整合Mybatis Plus

依赖

• <dependencies>
      <!-- 起步依赖 -->
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-web</artifactId>
      </dependency>
      <!-- mybatis plus依赖 -->
      <dependency>
          <groupId>com.baomidou</groupId>
          <artifactId>mybatis-plus-boot-starter</artifactId>
          <version>3.5.1</version>
      </dependency>
      <!-- mysql驱动 -->
      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.46</version>
      </dependency>
      <!-- 数据库连接池 -->
      <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>1.1.21</version>
      </dependency>
      <!-- 测试 -->
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-test</artifactId>
          <scope>test</scope>
      </dependency>
  </dependencies>
  

配置文件

• # 端口
  server.port=8080
  # 访问根路径
  server.servlet.context-path=/
  
  # DataSource
  spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
  spring.datasource.url=jdbc\:mysql\://localhost\:3306/soc?useUnicode\=true&characterEncoding\=UTF-8&useSSL\=false&rewriteBatchedStatements\=true
  spring.datasource.username=root
  spring.datasource.password=Wnt.1@3456
  spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  

数据准备

• CREATE TABLE `soc_user_info` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `user_name` varchar(100) NOT NULL COMMENT '用户名称',
    `user_password` varchar(100) NOT NULL COMMENT '用户密码',
    PRIMARY KEY (`id`),
    UNIQUE KEY `soc_user_info_un` (`user_name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
      
  INSERT INTO soc.soc_user_info (user_name, user_password) VALUES('hjx', '123456');
  

实体类

• public class SocUserInfo {
      private Integer id;
      private String userName;
      private String userPassword;
  
      public SocUserInfo() {
      }
  
      public Integer getId() {
          return id;
      }
  
      public void setId(Integer id) {
          this.id = id;
      }
  
      public String getUserName() {
          return userName;
      }
  
      public void setUserName(String userName) {
          this.userName = userName;
      }
  
      public String getUserPassword() {
          return userPassword;
      }
  
      public void setUserPassword(String userPassword) {
          this.userPassword = userPassword;
      }
  
      @Override
      public String toString() {
          return "SocUserInfo{" +
                  "id=" + id +
                  ", userName='" + userName + '\'' +
                  ", userPassword='" + userPassword + '\'' +
                  '}';
      }
  }
  

Mapper接口

• public interface UserMapper extends BaseMapper<SocUserInfo> {
  }
  

MapperScan

• 在启动项上面添加扫描器
• @MapperScan("com.hjx.mybatis.core")
• 

项目结构

• 

测试类

• @SpringBootTest
  class SpringBootMybatisPlusApplicationTests {
  
      @Autowired
      private UserMapper userMapper;
  
      @Test
      void contextLoads() {
          List<SocUserInfo> socUserInfos = userMapper.selectList(new QueryWrapper<>());
          socUserInfos.forEach(socUserInfo -> System.out.println(socUserInfo.toString()));
      }
  
  }
  

•