Spring Boot集成JPA无法自动创建MySQL表问题求助

正在学习Spring Boot，尝试搭建JPA与MySQL数据库的集成环境。项目启动正常，无可见错误，但数据库中并未创建对应的表。以下是相关代码：

ProjectApplication.java #

package com.first.project;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class ProjectApplication {

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

Student 实体类 #

package com.first.project.student;

import org.springframework.data.annotation.Id;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Table;
import java.time.LocalDate;

@Entity
@Table
public class Student {
  @Id
  @GeneratedValue(
          strategy = GenerationType.IDENTITY
  )
  private Long id;
  private String name;
  private String email;
  private LocalDate dateOfBirth;
  private Integer age;

  public Student() {
  }
  public Student(Long studentId, String studentName, String studentEmail, LocalDate studentDoB, Integer studentAge) {
    this.id = studentId;
    this.name = studentName;
    this.email = studentEmail;
    this.dateOfBirth = studentDoB;
    this.age = studentAge;
  }

  public Student(String studentName, String studentEmail, LocalDate studentDoB, Integer studentAge) {
    this.name = studentName;
    this.email = studentEmail;
    this.dateOfBirth = studentDoB;
    this.age = studentAge;
  }

  public Long getId() {
    return id;
  }

  public void setId(Long id) {
    this.id = id;
  }

  public String getName() {
    return name;
  }

  public void setName(String name) {
    this.name = name;
  }

  public String getEmail() {
    return email;
  }

  public void setEmail(String email) {
    this.email = email;
  }

  public LocalDate getDateOfBirth() {
    return dateOfBirth;
  }

  public void setDateOfBirth(LocalDate dateOfBirth) {
    this.dateOfBirth = dateOfBirth;
  }

  public Integer getAge() {
    return age;
  }

  public void setAge(Integer age) {
    this.age = age;
  }

  @Override
  public String toString() {
    return "Student{" +
            "id=" + id +
            ", name='" + name + '\'' +
            ", email='" + email + '\'' +
            ", dateOfBirth=" + dateOfBirth +
            ", age=" + age +
            '}';
  }
}

application.properties 配置 #

spring.datasource.url=jdbc:mysql://localhost:3306/(my database)
spring.datasource.username=(my username)
spring.datasource.password=(my password)
spring.jpa.hibernate.ddl-auto=create-drop
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect
spring.jpa.properties.hibernate.format_sql=true
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.properties.hibernate.show_sql=true
spring.jpa.generate-ddl=true

pom.xml 依赖 #

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
        <groupId>com.mysql</groupId>
        <artifactId>mysql-connector-j</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>javax.persistence</groupId>
        <artifactId>javax.persistence-api</artifactId>
        <version>2.2</version>
    </dependency>
</dependencies>

项目结构为主包com.first.project下有ProjectApplication类，子包com.first.project.student中包含Student类。

问题原因及解决方法 #

• 依赖冲突：同时引入了spring-boot-starter-data-jdbc和spring-boot-starter-data-jpa，JDBC Starter会干扰JPA的自动配置，导致Hibernate无法触发DDL生成逻辑。
  解决：移除spring-boot-starter-data-jdbc依赖，保留spring-boot-starter-data-jpa即可。

• 实体类主键注解错误：当前使用的是Spring Data的org.springframework.data.annotation.Id，但JPA需要使用JPA规范的javax.persistence.Id（适配Spring Boot 2.x版本）。错误的Id注解会导致Hibernate无法识别实体类的主键，进而跳过表生成。
  解决：替换实体类中的Id导入语句为import javax.persistence.Id。

• 数据库URL格式错误：配置中的(my database)是占位符，需替换为实际存在的数据库名称（比如jdbc:mysql://localhost:3306/student_db），且该数据库必须提前手动创建——Hibernate只会生成表，不会自动创建数据库。

• JPA配置冗余与方言不匹配：

  • 配置中有重复的spring.jpa.properties.hibernate.show_sql=true，可删除其中一条；
  • spring.jpa.generate-ddl=true属于冗余配置，spring.jpa.hibernate.ddl-auto=create-drop已经覆盖了该功能；
  • 若使用MySQL 8.x版本，应将方言改为org.hibernate.dialect.MySQL8Dialect，避免因方言不兼容导致DDL生成失败。

内容的提问来源于stack exchange，提问作者Zeke Cachi