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="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.url">jdbc:mysql://localhost:3306/vote</property>
<property name="connection.username">dyb</property>
<property name="connection.password">123456</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<!-- 显示数据库语句 -->
<property name="show_sql">true</property>
<!-- 创建数据库 -->
<property name="hbm2ddl.auto">create</property>
<!-- 格式化显示数据库SQL语句 -->
<property name="hibernate.format_sql">true</property>
<!-- 实体类配置映射文件 -->
<mapping resource="org/dyb/bean/VoteAdmin.hbm.xml" />
<mapping resource="org/dyb/bean/Vote.hbm.xml" />
<mapping resource="org/dyb/bean/VoteSelect.hbm.xml" />
<mapping resource="org/dyb/bean/VoteLog.hbm.xml" />
</session-factory>
</hibernate-configuration>
Vote.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="org.dyb.bean.Vote" table="vote" schema="vote">
<id name="voteID" type="java.lang.Integer">
<column name="voteID" />
<!-- MySQL使用identity自增长-->
<generator class="identity" />
</id>
<property name="voteName" type="java.lang.String">
<column name="voteName" length="50" not-null="true" unique="true" />
</property>
<property name="voteState" type="java.lang.Integer">
<column name="voteState" />
</property>
<property name="voteStartTime" type="java.util.Date" >
<column name="voteStartTime" length="7" />
</property>
<property name="voteEndTime" type="java.util.Date">
<column name="voteEndTime" length="7" />
</property>
<property name="voteNote" type="java.lang.String">
<column name="voteNote" length="30" />
</property>
<!-- 多对一的数据库关系-->
<many-to-one name="voteAdmin" class="org.dyb.bean.VoteAdmin">
<column name="adminName"></column>
</many-to-one>
<!-- 一对多的数据库关系-->
<set name="voteSelects">
<key>
<column name="voteName"></column>
</key>
<one-to-many class="org.dyb.bean.VoteSelect" />
</set>
</class>
</hibernate-mapping>