Springboot2+thymeleaf+Jpa实现CRUD操作

1 引入pom依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

2 配置yaml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/musicblog?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true
    username: root
    password: marlon

  jpa:
    hibernate:
      ddl-auto: none
    show-sql: true

  thymeleaf:
    cache: false
    check-template-location: true  #check-tempate-location: 检查模板路径是否存在
    prefix: classpath:/template/
    suffix: .html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

3 主启动类JpaApplication

@SpringBootApplication
public class JpaApplication{

    public static void main(String[] args) {
        SpringApplication.run(JpaApplication.class,args);
    }
}
1
2
3
4
5
6
7

4 新建表

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `PHONE` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话',
  `NAME` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AGE` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1
2
3
4
5
6
7
8

5 编写业务代码

请参阅码云：https://gitee.com/marlon1999/springboot-learnning
springboot-learnning的springboot-jpa-thymeleaf模块