Springboot整合Mybatispuls的实例详解

Springboot整合MybatisPuls

Maven导入依赖，主要只需导入MyBatisPuls

<dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-jdbc</artifactId>
    </dependency>
    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>3.0.1</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>

配置数据源

spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
server.port=8082

编写实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("users")//连接的表名
public class Users implements Serializable {
  @TableId("id")标记该变量为主键
  private Integer id;
  private String Account;
  @TableField("passwraod" )//如果实体类变量和数据库不同使用
  private String password;
  private Integer Authority;
}

mapper接口编写
继承BaseMapper<这里为实体类>

@org.apache.ibatis.annotations.Mapper//让Spring容器扫描该类为Mapper
@Repository
public interface Mapper extends BaseMapper<Users> {
}

BaseMapper源码

实现接口方法

@RestController
public class Control {
  @Autowired
  Mapper mapper;
  @RequestMapping("/hello")
  public Users Select(){
    Users users = mapper.selectById(1);
    return users;
  }

}