H2 的使用

 

1.配置application.yml

datasource:
  url: jdbc:h2:mem:console
  username: sa
  password:
  driver-class-name: org.h2.Driver
  schema: classpath:schema.sql
  data: classpath:data.sql

jpa:
  show-sql: false
  hibernate:
    ddl-auto: create
  database: h2

h2:
  console:
    enabled: true
    path: /h2

 

2.pom.xml 配置

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <scope>runtime</scope>
</dependency>
<dependency>
   <groupId>com.h2database</groupId>
   <artifactId>h2</artifactId>
   <scope>runtime</scope>
</dependency>
<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-autoconfigure</artifactId>
</dependency>
<dependency>
   <groupId>org.projectlombok</groupId>
   <artifactId>lombok</artifactId>
</dependency>

 

3.schema.sql

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
`name` varchar(64) NOT NULL DEFAULT '0' COMMENT '用户名',
`password` varchar(64) NOT NULL DEFAULT '' COMMENT '密码',
`create_time` datetime NOT NULL COMMENT '创建时间'
)ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

 

4.data.sql

INSERT INTO user(`id`,`name`,`password`,`create_time`) values (1,'root','root','2018-10-16 16:20:20');

 

5. User.java

@Entity
@Table(name = "user")
@Data
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    private String password;
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Timestamp createTime;
}

 

6.UserRepository.java

@Repository
public interface UserRepository extends JpaRepository<User, Long> {
}

 

7.service 和controller 略

 

8. main

@SpringBootApplication
@Configuration
@EnableAutoConfiguration
public class AdministrativeConsoleApplication extends VcreditApplication {

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

  启动项目后会自动创建库和表。