POM

<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.3.1</version>
</dependency>

application.yml

spring:
  datasource:
    driver-class-name: org.h2.Driver
    url: jdbc:h2:file:./v2/test
    username: sa
    password: 123456

  resources:
    static-locations: classpath:/templates/,classpath:/static/

  jpa:
    hibernate:
      ddl-auto: update
  #      ddl-auto: create     #----每次运行该程序，没有表格会新建表格，表内有数据会清空
  #      ddl-auto:create-drop----每次程序结束的时候会清空表
  #      ddl-auto:update----每次运行程序，没有表格会新建表格，表内有数据不会清空，只会更新
  #      ddl-auto:validate----运行程序会校验数据与数据库的字段类型是否相同，不同会报错

  h2:
    console:
      path: /h2-console
      enabled: true
      settings:
        web-allow-others: true

@Configuration
@MapperScan("com.myh2.mapper")
public class MybatisPlusConfig {

   /**
    * 分页配置
    * @return
    */
   @Bean
   public MybatisPlusInterceptor mybatisPlusInterceptor() {
      MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
      interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
      return interceptor;
   }
   
}

mapper

@Component
public interface CameraMapper extends BaseMapper<Camera>{}

entity

@TableName("camera")
@Entity
@Table(name="camera")  //jpa自动创建表
public class Camera implements Serializable {
   /**
    * 
    */
   private static final long serialVersionUID = -5575352151805386129L;
   
   @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
   
   @Column
   private String url;
   @Column
   private String remark;
   @Column
   private int flv;
   @Column
   private int hls;
   @Column
   private int ffmpeg;
   @Column
   private int autoClose;
   @Column
   private int type = 0;
   @Column
   private String mediaKey;}