前言
使用hibernate实现对mysql数据库的增删改查
一、CRUD前的hibernate配置
1.导入maven依赖
<dependencies>
<!--junit依赖,用于单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!--添加hibernate的核心依赖-->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.0.12.Final</version>
</dependency>
<!--添加mysql的jdbc驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.41</version>
</dependency>
<!--添加log4j依赖-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.10</version>
<scope>provided</scope>
</dependency>
</dependencies>
2.配置配置文件
配置文件这东西一般都是hibernate.cfg.xml命名的,其他的命名方式没试过,感兴趣的可以去搜一下
该文件放在src目录下,其他地方可能会报异常,文件找不到
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//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>
<property name="connection.url">jdbc:mysql://localhost:3306/hibernate?serverTimezone=UTC</property>
<property name="connection.username">root</property>
<property name="connection.password">123456</property>
<!-- SQL dialect -->
<!--使用MYSQL方言,告诉hibernate数据库类型-->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!--事务管理方式,即每个线程一个事务-->
<property name="current_session_context_class">thread</property>
<!--是否在控制台显示执行的sql语句-->
<property name="show_sql">true</property>
<!--是否会自动更新数据库的表结构,不需要创建表,Hibernate会自动去创建表结构-->
<property name="hbm2ddl.auto">update</property>
<!--去识别UsersEntity实体类-->
<mapping resource="mapper/Student.hb.xml" />
</session-factory>
</hibernate-configuration>
3.映射实体类和数据库表关系
一般的命名规则是实体类ming.hbn.xml
该文件位置没有特别要求,我一般都是放在resource下面的mapper里面,在hibernate.hbn.xml里面进行文件路径映射即可
<?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">
<!--映射实体类Student-->
<hibernate-mapping package="entity">
<class name="Student" table="student">
<!--属性id,映射表里的字段id-->
<id name="id" column="id">
<!--id的自增长方式采用数据库的本地方式-->
<generator class="native"></generator>
</id>
<property name="name" />
<property name="source" />
</class>
</hibernate-mapping>
4.创建测试类
package util;
import entity.Student;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
/**
* @author :LSS
* @description: hibernate的增删改查
* @date :2020/12/25 10:08
*/
public class Test {
public static void main(String[] args) {
//获取SessionFactory
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
//获取Session
Session session = sessionFactory.openSession();
//开启事务
session.beginTransaction();
//get查询方式
Student student = session.get(Student.class, 2);
System.out.println("student = " + student);
//load查询方式
Student load = session.load(Student.class, 1);
System.out.println("load = " + load);
//插入数据
Student xz = new Student(5,"小庄", 150);
session.save(xz);
//更改数据
student.setName("cl");
session.update(student);
Student student1 = session.get(Student.class, 2);
System.out.println("student1 = " + student1);
//删除数据
session.delete(load);
//事务提交
session.getTransaction().commit();
//关闭事务,SessionFactory
session.close();
sessionFactory.close();
}
}
总结
这只是最基本的hibernate操作mysql的用法,后面会有更多深入的用法!