Hibernate项目创建（IDEA版）

环境： Intellij IDEA 2018.3.3 +Mysql5.7

1、new project,选中下图选项。点next-->输入项目名称-->点击Finish 完成创建

2、在lib文件夹下导入MySQL驱动包。在src下创建如下文件

3、导入驱动包，右击选择Add as Library

3、连接数据库（在连接数据库之前需准备好数据库。本例中创建了db1库，内含books表） ，点击右侧Database.选择MySQL

4、输入数据库名称、用户名、密码。点击Test Connection,连接成功会提示successful。点击“Apply”，点击OK 

,

5、创建持久化类 （Books）：持久化类满足JavaBean规范

package com.example;

import javax.persistence.Entity;
import javax.persistence.Table;

/**
 * @Classname Books
 * @Description TODO
 * @Date 2019-8-1 18:31
 * @Created by Administrator
 */
@Entity
@Table(name="books")
public class Books {
    private String id;
    private String title;
    private float price;
    private String publishDate;

    public Books() {
    }

    public Books(String id, String title, float price, String publishDate) {
        this.id = id;
        this.title = title;
        this.price = price;
        this.publishDate = publishDate;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public float getPrice() {
        return price;
    }

    public void setPrice(float price) {
        this.price = price;
    }

    public String getPublishDate() {
        return publishDate;
    }

    public void setPublishDate(String publishDate) {
        this.publishDate = publishDate;
    }
}

6、创建持久化类的映射文件 （Book.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="com.example.Books" table="books">
        <id name="id" type="string">
            <!--<column name="id"></column>-->
            <generator class="assigned"></generator>
        </id>
        <property name="title" type="java.lang.String">
            <column name="title"></column>
        </property>
        <property name="price" type="java.lang.Float">
            <column name="price"></column>
        </property>
        <property name="publishDate" type="java.lang.String">
            <column name="publishDate"></column>
        </property>
    </class>
</hibernate-mapping>

注：映射文件中的type用string或java.lang.String否则会报错

7、创建hibernate配置文件 

<?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="connection.driver_class">com.mysql.jdbc.Driver</property>
        <!-- 指定连接数据库的url，hibernate连接的数据库名 -->
        <property name="connection.url">jdbc:mysql://localhost:3306/db1</property>
        <!-- 指定连接数据库的用户名 -->
        <property name="hibernate.connection.username">root</property>
        <!-- 数据库的登陆密码 -->
        <property name="hibernate.connection.password">zheng</property>
        <!-- 指定连接数据库的编码 -->
        <property name="connection.characterEncoding">utf8</property>
        <!-- 指定数据库方言 -->
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <!-- 显示Hibernate持久化操作所生成的SQL -->
        <property name="show_sql">true</property>
        <!-- 将SQL脚本进行格式化后再输出 -->
        <property name="format_sql">true</property>
        <!-- 指定自动生成数据表的策略 -->
        <property name="hbm2ddl.auto">update</property>

        <!-- 罗列所有的映射文件 -->
        <mapping resource="/com/example/Book.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

8、创建测试类（Test.java）

package com.example;


import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

/**
 * @Classname Test
 * @Description TODO
 * @Date 2019-8-2 11:10
 * @Created by Administrator
 */
public class Test {
    public static void main(String[] args) {
        Configuration configuration=new Configuration();
        configuration.configure("hibernate.cfg.xml");

        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session=sessionFactory.openSession();
        Transaction transaction=session.beginTransaction();

        Books books = new Books();
        books.setId("7");
        books.setTitle("活着");
        books.setPrice(88);
        books.setPublishDate("2010-11-09 00:00:00");

        //session.persist(books)
        session.save(books);
        transaction.commit();
        session.close();

        System.out.println("Successful saved.");

    }
}

注：所添加的数据不能与数据库中主键的数据重复（本例中主键为id）,否则会报Duplicate entry '0' for key 'PRIMARY'的错误

9、运行

10、查看数据是否添加到数据库中