创建数据库和表
安装MySQL：https://blog.csdn.net/qq_59636442/article/details/141926105
通过Navicat 创建数据库test
创建表student后随便添加一条数据
CREATE TABLE `student` (`id` int NOT NULL AUTO_INCREMENT,`name` varchar(255) DEFAULT NULL,`email` varchar(255) DEFAULT NULL,`age` int DEFAULT NULL,`photo` varchar(255) DEFAULT NULL,`password` varchar(255) DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
添加依赖(pom.xml)
在项目的pom.xml中添加
在标签<dependencies></dependencies>内添加
<!-- MySQL数据库 --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId></dependency><dependency><groupId>com.mysql</groupId><artifactId>mysql-connector-j</artifactId><scope>runtime</scope></dependency>
MySQL配置(application.properties)
# MySQL配置
spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
