goods.hbm.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping >
<class name="package077.GoodsInfo" table="商品数据表">
<!-- 商品ID -->
<id name="goodsId" column="商品ID" type="int">
<generator class = "identity" />
</id>
<!-- 商品编码 -->
<property name="goodsCode" column="商品编码" type="string" length="10">
</property>
<property name="goodsName" column="商品名称" type="string" length="10">
</property>
<property name="goodsPrice" column="价格" type="double" >
</property>
<property name="goodsPreferentialPrice" column="优惠价格" type="double" >
</property>
<!-- 库存数量-->
<property name="goodsStockNumber" column="库存数量" type="int" length="10">
</property>
<!-- 多对一单向映射 -->
<many-to-one name="goodsCategory" column="类型" class="package077.GoodsCategory"
lazy="false" >
</many-to-one>
</class>
</hibernate-mapping>
category.hbm.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping >
<class name="package077.GoodsCategory" table="商品类型表">
<!-- 标识 -->
<id name="id" column="类型ID" type="int">
<generator class = "identity" />
</id>
<!-- 类别名称-->
<property name="cname" column="类型名称" type="string" length="20" />
</class>
</hibernate-mapping>
hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.username">sa</property>
<property name="connection.url">jdbc:sqlserver://localhost:1433;DatabaseName=ECommerce</property>
<property name="dialect">org.hibernate.dialect.SQLServer2008Dialect</property>
<property name="connection.password">123456</property>
<property name="show_sql">true</property>
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<mapping resource="package077/goods.hbm.xml" />
<mapping resource="package077/category.hbm.xml" />
</session-factory>
</hibernate-configuration>