SSH项目中根据Hibernate的映射文件生成数据库表的方案：

墨蓝 2024-04-20 11:18 71阅读 0赞

1.首先在项目的根目录下配置:hibernate.cfg.xml文件：如下：

<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE hibernate-configuration PUBLIC  
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"  
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">  
<hibernate-configuration>  
<session-factory>  
  
  
   
<property name="connection.driver\_class">oracle.jdbc.driver.OracleDriver</property>  
<property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:ORCL</property>  
<property name="connection.username">WMS</property>  
<property name="connection.password">WMS</property>  
  
  
  
<property name="connection.pool\_size">1</property>  
  
  
  
<property name="dialect">org.hibernate.dialect.OracleDialect</property>  
  
  
  
  
  
<property name="show\_sql">true</property>  
  
  
  
<property name="hbm2ddl.auto">create</property>  
  
<mapping resource="com/ydsn/tms/hbm/Tbcharges.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbcoffersfiles.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbconsigneesfiles.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbcustomerfiles.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbdefectivegoodsinventory.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbgoodsdisplacement.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbgoodsfiles.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbgoodsmovecoffer.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbgoodspositionfiles.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbinventory.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbinvoices.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tboutstorehouseorder.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbpermissiongroups.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbprofitloss.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbserialnumfiles.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbstorageinvoices.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbstorageinvoicesdetail.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbstorageorder.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbstorehouselist.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbstorehouselistdetail.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbuserinfo.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbuserpermission.hbm.xml" />  
<mapping resource="com/ydsn/tms/hbm/Tbvoucher.hbm.xml" />  
  
  
</session-factory>  
</hibernate-configuration>

2.写一个测试类，让它自动生成数据库表文件，我这里使用的是oracle数据库：

package com.ydsn.tms.test;  
  
  
import org.hibernate.cfg.Configuration;  
import org.hibernate.tool.hbm2ddl.SchemaExport;  
  
  
public class TestSprinig \{  
  
  
public static void main(String\[\] args) \{  
  
Configuration cfg = new Configuration().configure();  
SchemaExport export = new SchemaExport(cfg);  
export.create(true, true);  
\}  
\}