这个教程会通过hibernate的api来实现数据库表的增删改插操作,快速入门hibernate的操作
1. 概述
这个案例会通过api完成对表"TBL_EMPLOYEES"的操作,此演示目的是展示基础写法,不涉及实际应用程序的业务逻辑复杂性
-- ----------------------------
-- Table structure for tbl_employees
-- ----------------------------
DROP TABLE IF EXISTS `tbl_employees`;
CREATE TABLE `tbl_employees` (
`id` int NOT NULL AUTO_INCREMENT,
`first_name` varchar(20) DEFAULT NULL,
`last_name` varchar(20) DEFAULT NULL,
`email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
2. Maven 依赖
spring-boot-starter-data-jpa:包含spring data、hibernate、HikariCP、JPA API、JPA Implementation(默认为hibernate)、JDBC等需要的库
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>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.5.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>org.example</groupId>
<artifactId>hibernate_springboot</artifactId>
<version>1.0-SNAPSHOT</version>
<name>hibernate_springboot</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId