IDEA中Hibernate的配置使用

比眉伴天荒 2022-04-03 13:14 391阅读 0赞

### IDEA中Hibernate的配置使用 ###

*  1.首先创建JavaEE Web Application项目，勾选Hibernate，Libraries选择Set up library later。（有hibernate jar包的前提下，没有jar包选择Download）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70][]

*  2.项目目录结构

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 1][]

*  3.把lib包中struts2的所有jar包选中，右键，选择Add as Library

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 2][]

*  4.Ctrl+Alt+Shift+s打开项目结构，进行配置

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 4][]

*  5.连接数据库
 *  5.1选择View-->Tool Windows-->Database

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 5][]

*  5.2建立连接（此次使用的是mysql8.0.13和对应的jar包）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 7][]

*  6.自动生成hibernate.xml
 *  6.1Ctrl+Alt+Shift+s打开项目结构,找到Module，点击Hibernate，点击右侧+号键
 *  6.2配置如下图，OK再src目录下自动生成hibernate.xml

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 8][]

*  6.3补全自动生成的hibernate.xml信息

<?xml version='1.0' encoding='utf-8'?>
    <!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
      <session-factory>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <property name="connection.url"><![CDATA[jdbc:mysql://localhost:3306/students?useSSL=false&serverTimezone=UTC]]></property>
        <property name="connection.driver_class">com.mysql.cj.jdbc.Driver</property>
         <property name="connection.username">root</property>
         <property name="connection.password">123456</property>
        
         <property name="hbm2ddl.auto">update</property>
        <mapping resource="pers/wpc/dao/Student.hbm.xml"/>
        <mapping class="pers.wpc.dao.Student"/>
      </session-factory>
    </hibernate-configuration>

此处为mysql8.0.13的配置，其他版本的dialect，driver和url请自行对应。

*  7.IDEA中自动生成实体类以及其配置文件
 *  7.1找到Persistence（左下）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 9][]

*  7.2选择Hibernate右键选择Generate...-->By Database Schema

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 10][]

*  7.3配置如下图，OK后自动生成实体类和配置文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 11][]

*  7.4实体类和配置文件

Student.java

package pers.wpc.dao;
    
    import javax.persistence.Basic;
    import javax.persistence.Column;
    import javax.persistence.Entity;
    import javax.persistence.Id;
    import java.util.Objects;
    
    @Entity
    public class Student {
        private int id;
        private String name;
        private String sex;
        private Integer age;
        private String grade;
        private Double score;
    
        @Id
        @Column(name = "id")
        public int getId() {
            return id;
        }
    
        public void setId(int id) {
            this.id = id;
        }
    
        @Basic
        @Column(name = "name")
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        @Basic
        @Column(name = "sex")
        public String getSex() {
            return sex;
        }
    
        public void setSex(String sex) {
            this.sex = sex;
        }
    
        @Basic
        @Column(name = "age")
        public Integer getAge() {
            return age;
        }
    
        public void setAge(Integer age) {
            this.age = age;
        }
    
        @Basic
        @Column(name = "grade")
        public String getGrade() {
            return grade;
        }
    
        public void setGrade(String grade) {
            this.grade = grade;
        }
    
        @Basic
        @Column(name = "score")
        public Double getScore() {
            return score;
        }
    
        public void setScore(Double score) {
            this.score = score;
        }
    
        @Override
        public boolean equals(Object o) {
            if (this == o) return true;
            if (o == null || getClass() != o.getClass()) return false;
            Student student = (Student) o;
            return id == student.id &&
                    Objects.equals(name, student.name) &&
                    Objects.equals(sex, student.sex) &&
                    Objects.equals(age, student.age) &&
                    Objects.equals(grade, student.grade) &&
                    Objects.equals(score, student.score);
        }
    
        @Override
        public int hashCode() {
            return Objects.hash(id, name, sex, age, grade, score);
        }
    }

Student.hbm.xml

<?xml version='1.0' encoding='utf-8'?>
    <!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    <hibernate-mapping>
    
        <class name="pers.wpc.dao.Student" table="student" schema="students">
            <id name="id" column="id"/>
            <property name="name" column="name"/>
            <property name="sex" column="sex"/>
            <property name="age" column="age"/>
            <property name="grade" column="grade"/>
            <property name="score" column="score"/>
        </class>
    </hibernate-mapping>

*  8.编写测试类

hbtest.java

package pers.wpc.test;
    
    import org.hibernate.Session;
    import org.hibernate.SessionFactory;
    import org.hibernate.Transaction;
    import org.hibernate.cfg.Configuration;
    import pers.wpc.dao.Student;
    
    public class hbtest {
        public static void main(String[] args) {
            Configuration conf = new Configuration().configure();
            SessionFactory sf = conf.buildSessionFactory();
            Session session = sf.openSession();
            Transaction tx = null;
            try{
                tx = session.beginTransaction();
                Student student = new Student();
                student.setId(4);
                student.setName("张国红");
                student.setSex("女");
                student.setGrade("16计科2班");
                student.setAge(19);
                student.setScore((double) 95);
                session.save(student);
                tx.commit();
            }catch (Exception e){
                if (null!=tx){
                    tx.rollback();
                }
                e.printStackTrace();
            }finally {
                session.close();
            }
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70]: /images/20220403/8bd01fc0e897490bb2904734d0ebeaac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 1]: /images/20220403/ce0e5a8e4024470497be6f60a4f099bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 2]: /images/20220403/cd2a852c3b784724b09838f9233f8b65.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 3]: /images/20220403/b6564ece356b47df8e251b5736bf2698.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 4]: /images/20220403/08bd87e3e304475589e0cbed512dea9e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 5]: /images/20220403/77b78ad23fb548f098bed12289f6965c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 6]: /images/20220403/f9cfc5e8235a47809495d7a709f9a0f7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 7]: /images/20220403/40d6a6678a61474a8fd80fe75eaae543.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 8]: /images/20220403/e7f15495320a4fa9b1b742ea88e1b3b9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 9]: /images/20220403/cf488776cf414cdb88bc193ca79beacb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 10]: /images/20220403/c32bba300ff74aae887d17d902b32590.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 11]: /images/20220403/45859f572c7b40ba8bfb24f9e0232148.png