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);
}
}
启动项目后会自动创建库和表。