Spring Boot 集成 H2 数据库

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

spring:
  datasource:
    url: jdbc:h2:mem:test
    username: sa
    password: sa
    driver-class-name: org.h2.Driver
    schema:  classpath:db/schema.sql # 表结构
    data: classpath:db/data.sql # 预先准备数据
  h2:
    console:
      enabled: true

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

DROP TABLE IF EXISTS user;

CREATE TABLE user
(
  id BIGINT(20) NOT NULL COMMENT '主键ID',
  name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
  age INT(11) NULL DEFAULT NULL COMMENT '年龄',
  email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (id)
);

1
2
3
4
5
6
7
8

DELETE FROM user;

INSERT INTO user (id, name, age, email) VALUES
  (1, 'Jone', 18, 'test1@mangobeta.com'),
  (2, 'Jack', 20, 'test2@mangobeta.com'),
  (3, 'Tom', 28, 'test3@mangobeta.com'),
  (4, 'Sandy', 21, 'test4@mangobeta.com'),
  (5, 'Billie', 24, 'test5@mangobeta.com');

1

compile group: 'com.h2database', name: 'h2', version: '1.4.200'

1

httpSecurity.headers().frameOptions().disable();

1
2
3
4
5
6

public class User {

    private Long id;

    private String name;

    private Integer age;

    private String email;
}

1
2

@Select("select * from user where id= #{id}")
User findById(Integer id);

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

@SpringBootTest
class UserDaoTest {
    @Autowired
    UserDao userDao;
    



 @Test

   void findById() {

       User user = userDao.findById(1);

        assertEquals(user.getName(), "Jone");
    }
}