hibernate自动建表+mysql配制+sqlserver配制_hibernate 配置mssql-优快云博客

本文链接：https://blog.youkuaiyun.com/quanquanfly/article/details/5363239

本文介绍了一种使用Hibernate框架自动创建数据库表的方法，并提供了连接SQL Server和MySQL数据库的具体配置示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

自动建表：

package mis.business.util;

import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;

public class ExportDB {

public static void main(String[] args) {

  //读取hibernate.cfg.xml文件
  Configuration cfg = new Configuration().configure();

  SchemaExport export = new SchemaExport(cfg);

  export.create(true, true);
}
}

连接sqlserver数据库：

<hibernate-configuration>
<session-factory>
  <property name="connection.url">jdbc:odbc:数据源名称</property>
  <property name="connection.driver_class">sun.jdbc.odbc.JdbcOdbcDriver</property>
  <property name="hibernate.connection.username">登录名</property>
  <property name="hibernate.connection.password">密码</property>
  <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
  <property name="hibernate.show_sql">true</property>
  <property name="hibernate.hbm2ddl.auto">update</property>

</session-factory>
</hibernate-configuration>

连接mysql数据库：

<hibernate-configuration>
<session-factory>
  <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/数据库名称</property>
  <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  <property name="hibernate.connection.username">登录名</property>
  <property name="hibernate.connection.password">密码</property>
  <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  <property name="hibernate.hbm2ddl.auto">update</property>
  <property name="hibernate.show_sql">true</property>

   </session-factory>
</hibernate-configuration>