idea配置hibernate环境

• 下载hibernate所需jar包

  • 官网链接

    

  • 高速链接

• 用idea创建一个web项目 Create New Project–>选择Java Enterprise–>勾选Web Application–>Project SDK选择jdk版本–>next–>填写项目名–>finish

在WEB-INF目录下创建lib文件夹，导入前面索下载的jar包（下载文件解压后有一个lib文件夹，在lib文件夹下有一个required文件夹，将该文件夹下的所有jar包导入项目中）这里我用的是mysql5.5，导入对应的mysql驱动包(我所用的mysql驱动下载mysql5.1.32驱动下载)，导入jar包后，右键lib，点击Add as Library

• 创建test数据库

  -- 创建test数据库
  DROP DATABASE IF EXISTS  `student`;
  CREATE DATABASE `student`;
  
  -- 选择test数据库
  USE test;
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- 创建Student表
  DROP TABLE IF EXISTS `student`;
  CREATE TABLE `student`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `birthday` date NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  SET FOREIGN_KEY_CHECKS = 1;
  

• 在src下创建hibernate核心配置文件hibernate.cfg.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="connection.driver_class">com.mysql.jdbc.Driver</property>
        <!--连接url-->
        <property name="connection.url">jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8</property>
        <!--用户名-->
        <property name="connection.username">root</property>
        <!--密码-->
        <property name="connection.password">root</property>
        <!--数据库方言-->
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <!--显示SQL语句-->
        <property name="show_sql">true</property>
        <!--格式化SQL语句-->
        <property name="format_sql">true</property>
        <!--关系映射-->
        <mapping class="entity.Student"/>
        <mapping resource="entity/Student.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

• student类

  package entity;
  
  import java.util.Date;
  
  /**
   * student实体类
   *
   * @author Hervery
   */
  public class Student {
  
      private int id;
      private String name;
      private String sex;
      private Date birthday;
  
      public int getId() {
          return id;
      }
  
      public void setId(int id) {
          this.id = id;
      }
  
      public String getName() {
          return name;
      }
  
      public void setName(String name) {
          this.name = name;
      }
  
      public String getSex() {
          return sex;
      }
  
      public void setSex(String sex) {
          this.sex = sex;
      }
  
      public Date getBirthday() {
          return birthday;
      }
  
      public void setBirthday(Date birthday) {
          this.birthday = birthday;
      }
  }
  

• 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="entity.Student" table="student">
          <id name="id" column="id">
              <generator class="identity"/>
          </id>
          <property name="name" column="name"/>
          <property name="sex" column="sex"/>
          <property name="birthday" column="birthday"/>
      </class>
  </hibernate-mapping>
  

• StudentTest类

  package test;
  
  import entity.Student;
  import org.hibernate.Session;
  import org.hibernate.SessionFactory;
  import org.hibernate.boot.registry.StandardServiceRegistry;
  import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
  import org.hibernate.cfg.Configuration;
  
  import java.text.ParseException;
  import java.text.SimpleDateFormat;
  
  /**
   * @author Hervery
   */
  public class StudentTest {
      public static void main(String[] args) throws ParseException {
          Configuration configure = new Configuration().configure();
          StandardServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().configure().build();
          SessionFactory sessionFactory = configure.buildSessionFactory(serviceRegistry);
          Session session = sessionFactory.openSession();
          Student student = new Student();
          student.setName("Tom");
          student.setSex("male");
          student.setBirthday(new SimpleDateFormat("yyyy-MM-dd").parse("2020-09-27"));
          session.save(student);
          session.beginTransaction().commit();
          session.close();
          sessionFactory.close();
          serviceRegistry.close();
      }
  }
  

运行结果

现在我们打开数据库看看是否有记录

到这里，我们的hibernate环境就搭建完成了。