2021暑期项目实训之Hibernate学习

配置Hibernate

hibernate下载 下载任意一个版本（此处选择5.5.2）
解压后将lib/required中的jar包移动到了C:\Users\dell.m2\repository\org\hibernate目录下

pom.xml文件配置：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>hibernate</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.25</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>5.5.2.Final</version>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.4</version>
        </dependency>
    </dependencies>

</project>

hibernate.cfg.tld:

<?xml version="1.0" encoding="UTF-8"?>
<!--标准的XML文件的起始行，version='1.0'表明XML的版本，encoding=' '表明XML文件的编码方式-->

<!--表明解析本XML文件的DTD文档位置，DTD是Document Type Definition 的缩写,即文档类型的定义,XML解析器使用DTD文档来检查XML文件的合法性。hibernate.sourceforge.net/hibernate-configuration-3.0dtd可以在Hibernate3.1.3软件包中的src\org\hibernate目录中找到此文件-->
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!--声明Hibernate配置文件的开始-->
<hibernate-configuration>
    <session-factory>
        <!-- 数据源配置 -->
        <property name="connection.username">root</property>
        <property name="connection.password">Lly011015</property>
        <property name="connection.driver_class">com.mysql.cj.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/study?useUnicode=true</property>

        <!-- C3P0 数据库连接池 -->
        <!-- 自增数量 -->
        <property name="hibernate.c3p0.acquire_increment">10</property>
        <!-- 失效时间 -->
        <property name="hibernate.c3p0.idle_test_period">10000</property>
        <!-- 超时时间 -->
        <property name="hibernate.c3p0.timeout">5000</property>
        <!-- 最大约束 -->
        <property name="hibernate.c3p0.max_size">30</property>
        <!-- 最小约束 -->
        <property name="hibernate.c3p0.min_size">5</property>
        <!-- 最大项目数 -->
        <property name="hibernate.c3p0.max_statements">10</property>

        <!-- 数据库方言 -->
        <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>

        <!-- 打印SQL -->
        <property name="show_sql">true</property>

        <!-- 格式化SQL -->
        <property name="format_sql">true</property>

        <!-- 是否自动生成数据库 -->
        <property name="hibernate.hbm2ddl.auto">create</property>

        <!-- 注册实体关系映射文件 -->
        <mapping resource="com/learn/entity/People.hbm.tld"></mapping>
    </session-factory>
</hibernate-configuration>

HQL查询：
hibernate提供的面向对象的查询语言。
查询的是对象以及对象的属性，区分大小写。

SQL查询的是表以及列，不区分大小写。

实体类：

People类：

package com.learn.entity;

import lombok.Data;

import java.util.Set;

@Data
public class People {
    private Integer id;
    private String name;
    private Double money;
}

Customer类：

package com.learn.entity;

import lombok.Data;

import java.util.Set;

@Data
public class Customer {
    private Integer id;
    private String name;
    private Set<Orders> orders;
}

Orders类：

package com.learn.entity;

import lombok.Data;

@Data
public class Orders {
    private Integer id;
    private String name;
    private Customer customer;
}

Customer.hbm.tld:

<?xml version="1.0"?>
<!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="com.learn.entity.Customer" table="customer">
        <id name="id" type="java.lang.Integer">
            <column name="id"></column>
            <generator class="identity"></generator>
        </id>

        <property name="name" type="java.lang.String">
            <column name="name"></column>
        </property>
    </class>
</hibernate-mapping>

People.hbm.tld:

<?xml version="1.0"?>
<!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="com.learn.entity.People" table="people">
        <id name="id" type="java.lang.Integer">
            <column name="id"></column>
            <generator class="identity"></generator>
        </id>

        <property name="name" type="java.lang.String">
            <column name="name"></column>
        </property>

        <property name="money" type="java.lang.Double">
            <column name="money"></column>
        </property>
    </class>
</hibernate-mapping>

测试：

package com.learn.test;

import com.learn.entity.People;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class Test {
    public static void main(String[] args) {
        //创建Configuration
        Configuration configuration = new Configuration();
//        System.out.println(configuration);
        //获取SessionFactory
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        //获取Session
        Session session = sessionFactory.openSession();
        People people = new People();
        people.setName("张三");
        people.setMoney(1000.0);
        session.save(people);
        session.beginTransaction().commit();
        session.close();
    }
}