时间戳

首页 > 解决方案 > 通过 java 代码将实体导出到数据库模式

spring - 通过 java 代码将实体导出到数据库模式

问题描述

很久以前，我用这样的代码做到了这一点：

Configuration config = new Configuration();

Properties props = new Properties();
FileInputStream fos = = new FileInputStream( file_name );
props.load(fos);
fos.close();
config.setProperties(props);

config.addAnnotatedClass(...);

Connection conn = DriverManager.getConnection(url,usuario,senha);
SchemaExport schema = new SchemaExport();
schema.create(true, true);

但是现在，如果我尝试使用此代码，则会出现编译错误。查看 SchemaExport 的 javadoc，我注意到此示例中使用的方法发生了很多变化。

Hpw 我现在可以这样做吗？

更新

根据建议的链接，我以这种方式实现了该方法：

  public void criarTabelas(String server, String user, String pass) throws Exception {
    StandardServiceRegistry standardRegistry = new StandardServiceRegistryBuilder().applySetting("hibernate.hbm2ddl.auto", "create").applySetting("hibernate.dialect", dialect).applySetting("hibernate.id.new_generator_mappings", "true").build();

    MetadataSources sources = new MetadataSources(standardRegistry);
    for(Class<?> entity : lista_entidades())
      sources.addAnnotatedClass(entity);

    MetadataImplementor metadata = (MetadataImplementor) sources.getMetadataBuilder().build();

    SchemaExport export = new SchemaExport();
    export.create(EnumSet.of(TargetType.DATABASE), metadata);
  }

  private List<Class<?>> lista_entidades() throws Exception {
      List<Class<?>> lista = new ArrayList<Class<?>>();

      ClassPathScanningCandidateComponentProvider scanner = new ClassPathScanningCandidateComponentProvider(false);
      scanner.addIncludeFilter(new AnnotationTypeFilter(Entity.class));
      for (BeanDefinition bd : scanner.findCandidateComponents("org.loja.model"))
        lista.add(Class.forName(bd.getBeanClassName()));

      return lista;
    }

现在我需要一种方法来建立 jdbc 连接并关联到 SchemaExport。

标签： springhibernatedatabase-schemaschemaexport

解决方案

我用这段代码解决了这个问题：

  public void criarTabelas(String server, String user, String pass) throws Exception {
    Connection conn = DriverManager.getConnection(url_prefix+server+"/"+url_suffix, user, pass);
    StandardServiceRegistry standardRegistry = new StandardServiceRegistryBuilder()
    .applySetting("hibernate.hbm2ddl.auto", "create")
    .applySetting("hibernate.dialect", dialect)
    .applySetting("hibernate.id.new_generator_mappings", "true")
    .applySetting("javax.persistence.schema-generation-connection", conn)
    .build();

    MetadataSources sources = new MetadataSources(standardRegistry);
    for(Class<?> entity : lista_entidades())
      sources.addAnnotatedClass(entity);

    MetadataImplementor metadata = (MetadataImplementor) sources.getMetadataBuilder().build();

    SchemaExport export = new SchemaExport();
    export.create(EnumSet.of(TargetType.DATABASE), metadata);
    conn.close();
  }

  private List<Class<?>> lista_entidades() throws Exception {
      List<Class<?>> lista = new ArrayList<Class<?>>();

      ClassPathScanningCandidateComponentProvider scanner = new ClassPathScanningCandidateComponentProvider(false);
      scanner.addIncludeFilter(new AnnotationTypeFilter(Entity.class));
      for (BeanDefinition bd : scanner.findCandidateComponents("org.loja.model"))
        lista.add(Class.forName(bd.getBeanClassName()));

      System.out.println("lista: "+lista);
      return lista;
    }

推荐阅读