使用hibernate连接mysql数据库正向工程hibernate.cfg.xml文件和xxx.hbm.xml配置文件

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>