eclipse使用hibernate tools插件生成mysql数据表的pojo

「爱情、让人受尽委屈。」 2022-06-06 06:35 190阅读 0赞

参考文章：[http://www.cnblogs.com/mrsui/archive/2013/06/20/3146335.html][http_www.cnblogs.com_mrsui_archive_2013_06_20_3146335.html]

本文环境：eclipse4.4.0+hibernate4.1+hibernate tools4.0.1+mysql5.7

**1 安装hibernate tools插件：**

help -> Eclipse Marketplace  
注：eclipse会搜索出适合该版本eclipse安装的hibernate tools，点击安装即可安装  
![这里写图片描述][SouthEast]

**2 创建hibernate配置文件hibernate.cfg.xml及console配置文件**

2.1新建Java或者Java web项目，这里建立了一个Java web项目hibernate\_taotao，建立cn.com.pojo package存放pojo等

2.2选中项目，右键-> new -> other -> hibernate -> hibernate configuration file  
![这里写图片描述][SouthEast 1]

![这里写图片描述][SouthEast 2]

2.3然后 next，配置console文件，创建了配置文件hibernate.cfg.xml  
![这里写图片描述][SouthEast 3]

<?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="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
            <property name="hibernate.connection.password">ccssxx</property>
            <property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/taotao?characterEncoding=utf-8</property>
            <property name="hibernate.connection.username">root</property>
            <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
        </session-factory>
    </hibernate-configuration>

**3 创建hibernate.reveng.xml文件:**

3.1选中项目，右键 -> new -> other -> hibernate -> hibernate reverse engineering file  
![这里写图片描述][SouthEast 4]

![这里写图片描述][SouthEast 5]

3.2下一步，配置要生成POJO对应的表  
![这里写图片描述][SouthEast 6]

3.3finish生成hibernate.reveng.xml文件

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >
    
    <hibernate-reverse-engineering>
      <table-filter match-catalog="taotao" match-name="tb_content"/>
      <table-filter match-catalog="taotao" match-name="tb_content_category"/>
      <table-filter match-catalog="taotao" match-name="tb_item"/>
      <table-filter match-catalog="taotao" match-name="tb_item_cat"/>
      <table-filter match-catalog="taotao" match-name="tb_item_desc"/>
      <table-filter match-catalog="taotao" match-name="tb_item_param"/>
      <table-filter match-catalog="taotao" match-name="tb_item_param_item"/>
      <table-filter match-catalog="taotao" match-name="tb_order"/>
      <table-filter match-catalog="taotao" match-name="tb_order_item"/>
      <table-filter match-catalog="taotao" match-name="tb_order_shipping"/>
      <table-filter match-catalog="taotao" match-name="tb_user"/>
    </hibernate-reverse-engineering>

**4 反向工程创建pojo：**

4.1 在java模式下的hibernate code generation configuration菜单中配置  
![这里写图片描述][SouthEast 7]

![这里写图片描述][SouthEast 8]

4.2点击run配置成功，生成pojo和对应的XX.hbm.xml文件  
![这里写图片描述][SouthEast 9]

**5 一般自动生成的mapping文件（XX.hbm.xml）都需要修改后才能使用：**

[http_www.cnblogs.com_mrsui_archive_2013_06_20_3146335.html]: http://www.cnblogs.com/mrsui/archive/2013/06/20/3146335.html
[SouthEast]: /images/20220606/3789455a6d114192ad7e68c6e1af6f86.png
[SouthEast 1]: /images/20220606/ad4a67cf85234fc5b6a8c2be7208be48.png
[SouthEast 2]: /images/20220606/bc1a05c28c244b5498cfd077c97ef134.png
[SouthEast 3]: /images/20220606/3981b31145134b189501b28dabd4a187.png
[SouthEast 4]: /images/20220606/55374b143e614e3da64de5720d315d6d.png
[SouthEast 5]: /images/20220606/4f55ff3aef764fd4bda387072423c4fc.png
[SouthEast 6]: /images/20220606/f594df7709ea48a4a9a6fd83eacb7410.png
[SouthEast 7]: /images/20220606/96b3c93c45af454fb7a397abc08256d9.png
[SouthEast 8]: /images/20220606/74760af146b1466993493bf8717d95d6.png
[SouthEast 9]: /images/20220606/7c10571d91a9480f8f2207d5e0c2e979.png