Spring Boot3+Hibernate6下编程式创建实体对应表（禁用ddl-auto=update）

方案一：使用Hibernate 6 原生SchemaManager API #

Hibernate 6 废弃了旧的SchemaExport，改用SchemaManager管理数据库schema。可以通过它实现「检查表存在性+按需建表」的逻辑：

1. 编写初始化组件，在Spring容器启动完成后执行逻辑
2. 通过EntityManagerFactory获取Hibernate的SchemaManager
3. 遍历实体类，检查对应表是否存在，不存在则创建

代码示例：

import jakarta.persistence.EntityManagerFactory;
import org.hibernate.engine.spi.SessionFactoryImplementor;
import org.hibernate.schema.SchemaManager;
import org.springframework.stereotype.Component;
import jakarta.annotation.PostConstruct;

@Component
public class TableInitializer {

    private final EntityManagerFactory entityManagerFactory;

    public TableInitializer(EntityManagerFactory entityManagerFactory) {
        this.entityManagerFactory = entityManagerFactory;
    }

    @PostConstruct
    public void initTables() {
        SessionFactoryImplementor sessionFactory = entityManagerFactory.unwrap(SessionFactoryImplementor.class);
        SchemaManager schemaManager = sessionFactory.getSchemaManager();

        // 遍历所有实体对应的表名
        sessionFactory.getMetadata().getEntityBindings().forEach(entityBinding -> {
            String tableName = entityBinding.getTableName().getText();
            boolean tableExists = schemaManager.tableExists(tableName);
            
            if (!tableExists) {
                schemaManager.createTable(entityBinding.getTableName(), entityBinding);
                System.out.println("表 " + tableName + " 已创建");
            } else {
                System.out.println("表 " + tableName + " 已存在");
            }
        });
    }
}

方案二：JDBC 检查表存在 + Hibernate SchemaCreator 批量建表 #

如果需要适配不同数据库的表存在性查询逻辑，可以结合JDBC查询元数据，再调用SchemaCreator批量创建不存在的表：

代码示例：

import jakarta.persistence.EntityManagerFactory;
import org.hibernate.engine.spi.SessionFactoryImplementor;
import org.hibernate.schema.SchemaCreator;
import org.hibernate.schema.TargetType;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;
import jakarta.annotation.PostConstruct;

import java.util.EnumSet;
import java.util.Set;
import java.util.stream.Collectors;

@Component
public class JdbcTableInitializer {

    private final EntityManagerFactory entityManagerFactory;
    private final JdbcTemplate jdbcTemplate;

    public JdbcTableInitializer(EntityManagerFactory entityManagerFactory, JdbcTemplate jdbcTemplate) {
        this.entityManagerFactory = entityManagerFactory;
        this.jdbcTemplate = jdbcTemplate;
    }

    @PostConstruct
    public void initTables() {
        SessionFactoryImplementor sessionFactory = entityManagerFactory.unwrap(SessionFactoryImplementor.class);
        SchemaCreator schemaCreator = sessionFactory.getSchemaCreator();

        // 获取所有实体对应的表名
        Set<String> entityTableNames = sessionFactory.getMetadata().getEntityBindings().stream()
                .map(binding -> binding.getTableName().getText())
                .collect(Collectors.toSet());

        // 查询数据库中已存在的表名（MySQL示例，其他数据库需调整SQL）
        Set<String> existingTables = jdbcTemplate.queryForSet(
                "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = DATABASE()",
                String.class
        );

        // 筛选需创建的表
        Set<String> tablesToCreate = entityTableNames.stream()
                .filter(table -> !existingTables.contains(table))
                .collect(Collectors.toSet());

        if (!tablesToCreate.isEmpty()) {
            schemaCreator.create(
                    EnumSet.of(TargetType.DATABASE),
                    sessionFactory.getMetadata(),
                    (metadata, formatter) -> metadata.getEntityBindings().stream()
                            .filter(binding -> tablesToCreate.contains(binding.getTableName().getText()))
                            .map(binding -> formatter.format(binding.getTable().createTableSqlString(metadata)))
                            .collect(Collectors.toList())
            );
            System.out.println("已创建表：" + tablesToCreate);
        } else {
            System.out.println("所有实体表均已存在");
        }
    }
}

注意事项 #

• 确保数据库账号拥有CREATE TABLE权限，若需创建外键等约束需额外权限
• 不同数据库的元数据查询SQL需调整：PostgreSQL用SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'，Oracle用SELECT table_name FROM user_tables
• 实体类需正确配置@Entity、@Table等注解，保证Hibernate能识别映射关系

内容的提问来源于stack exchange，提问作者MD MOHOSIN MIAH