spring JPA整合hibernate，IDEA社区版，Java

不念不忘少年蓝@ 2023-09-26 09:09 59阅读 0赞

## spring JPA整合hibernate，IDEA社区版，Java ##

本文基于IDEA社区版，不是IDEA企业版。

（1）首先用IDEA新建一个spring web项目。参考文章：

[IDEA社区版(Community Edition)创建Springboot-Web项目，Java\_zhangphil的博客-CSDN博客除了可以通过application.yml文件配置MyApp外，也可以通过application.properties配置，application.properties与application.yml配置写法不同。特别注意，如果resources下面同时存在application.yml和application.properties两个配置文件，那么application.properties里面的配置将覆盖application.yml的配置。（3）在main目录下建立项目的代码包（目录层次结构）![favicon32.ico][]https://zhangphil.blog.csdn.net/article/details/126894920][IDEA_Community Edition_Springboot-Web_Java_zhangphil_-CSDN_application.yml_MyApp_application.properties_application.properties_application.yml_resources_application.yml_application.properties_application.properties_application.yml_3_main_favicon32.ico_https_zhangphil.blog.csdn.net_article_details_126894920]

（2）pom.xml添加引用：

<parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.7.4</version>
        </parent>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.hibernate.orm</groupId>
                <artifactId>hibernate-core</artifactId>
                <version>6.1.3.Final</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
        </dependencies>
    
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>

（3）在resources下面的application.properties里面写入配置，如果application.properties不存在，新建application.properties：

spring.datasource.url=jdbc:mysql://localhost:3306/db_demo?useSSL=false&allowPublicKeyRetrieval=true&allowMultiQueries=true&serverTimezone=UTC
    spring.datasource.username=root
    spring.datasource.password=123456
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    
    spring.jpa.hibernate.ddl-auto=update
    spring.jpa.show-sql=true
    spring.jpa.properties.hibernate.format_sql=true
    spring.jpa.properties.hibernate.generate_statistics=false

（4）在本机上启动mysql数据库。启动端口在3306，参考文章：

[mysql数据库环境配置和安装启动，Windows\_zhangphil的博客-CSDN博客先下载mysql的zip压缩包：MySQL :: Download MySQL Community Serverhttps://dev.mysql.com/downloads/mysql/下载解压后，配置my.ini文件，放到mysql的程序目录里面，my.ini文件：\[mysqld\]port=3306basedir=D:\\mysql\\mysql-8.0.27-winx64datadir=D:\\mysql\\data\[client\] port=3306default-character-s![favicon32.ico][]https://blog.csdn.net/zhangphil/article/details/122414377][mysql_Windows_zhangphil_-CSDN_mysql_zip_MySQL _ Download MySQL Community Serverhttps_dev.mysql.com_downloads_mysql_my.ini_mysql_my.ini_mysqld_port_3306basedir_D_mysql_mysql-8.0.27-winx64datadir_D_mysql_data_client_ port_3306default-character-s_favicon32.ico_https_blog.csdn.net_zhangphil_article_details_122414377]启动mysql后，创建一个名为 db\_demo 的数据库（对应（3）中的数据库链接url里面数据库名字）

把账号root的密码改成(3)中的相同，本例是123456。参考：

[mysql数据库重置root用户名和密码\_zhangphil的博客-CSDN博客先下载mysql的zip压缩包：MySQL :: Download MySQL Community Serverhttps://dev.mysql.com/downloads/mysql/下载解压后，配置my.ini文件，放到mysql的程序目录里面，my.ini文件：\[mysqld\]port=3306basedir=D:\\mysql\\mysql-8.0.27-winx64datadir=D:\\mysql\\data\[client\] port=3306default-character-s。![favicon32.ico][]https://blog.csdn.net/zhangphil/article/details/126688161][mysql_root_zhangphil_-CSDN_mysql_zip_MySQL _ Download MySQL Community Serverhttps_dev.mysql.com_downloads_mysql_my.ini_mysql_my.ini_mysqld_port_3306basedir_D_mysql_mysql-8.0.27-winx64datadir_D_mysql_data_client_ port_3306default-character-s_favicon32.ico_https_blog.csdn.net_zhangphil_article_details_126688161]

![ac23b2e616ba4d0bb4ae59a0d5dedda0.png][]

命令：

mysql -uroot -p123456

登录mysql数据库，创建db\_demo：

create database db_demo;
    show databases;

![c4750c5411804a4da71876f59cc41ac8.png][]

（5）在IDEA开发工具的左下角打开JPA Structure，新建一个JPA的实体User

![bc6f73150a82436cac65788102a4f816.png][]

![623708c6ac6f453d9a003b397ce4b1f2.png][]

再新建一个Spring Data Repository,名字可以取为UserRepository。

![7655fb1f101345ae873f19e854e69637.png][]

![53cd09fc632e41bda611f5ec49e7bfc8.png][]

此时的main/java/test代码包里面有User.java和UserRepository.java，

import org.springframework.data.jpa.repository.JpaRepository;
    import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
    
    public interface UserRepository extends JpaRepository<User, Long>, JpaSpecificationExecutor<User> {
    }

在IDEA自动生成的代码基础上补全User.java，根据自己的需要添加字段(name和age是自己添加的)：

import javax.persistence.*;
    
    @Entity
    @Table(name = "user")
    public class User {
        @Id
        @GeneratedValue(strategy = GenerationType.AUTO)
        @Column(name = "id", nullable = false)
        private Long id;
    
        public Long getId() {
            return id;
        }
    
        public void setId(Long id) {
            this.id = id;
        }
    
        private String name;
    
        public int age;
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
    }

新建一个UserController,这个类主要为了测试往数据库写数据（不重要，和JPA无关，仅作数据添加）：

import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class UserController {
        @Autowired
        private UserRepository userRepository;
    
        @GetMapping(path = "/add")
        public User addUser() {
            User user = new User();
            user.setName("zhang");
            user.setAge(18);
    
            User save = userRepository.save(user);
            return save;
        }
    }

启动的main application类：

import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.context.ConfigurableApplicationContext;
    
    @SpringBootApplication
    public class Main {
        public static void main(String[] args) {
            ConfigurableApplicationContext context = SpringApplication.run(Main.class, args);
        }
    }

（6）最终的项目代码结构为：

![879909c3b8a7476eb7cf4d24052cc7f3.png][]

（7）以上完成后，启动Main.java，日志输出部分内容为：

![ed7152b706214f97ae65d71192449bd2.png][]

spring jpa自动连接Mysql数据库创建user表结构。此时在mysql执行命令查看JPA对mysql的写的表：

use db_demo;
    show tables;
    describe user;

![367ac2044f3f49c289f0fb9e1561a539.png][]

说明JPA正常工作了。

（8）此时在浏览器访问 localhost:8080/add

![49556be5064b45f99c1c7b5b326de649.png][]

在mysql控制台查看JPA是否真正写入了mysql数据：

![a4d1798f9e23472c9019e44ac6893fb2.png][]

JPA写入成功。

[favicon32.ico]: https://g.csdnimg.cn/static/logo/favicon32.ico
[IDEA_Community Edition_Springboot-Web_Java_zhangphil_-CSDN_application.yml_MyApp_application.properties_application.properties_application.yml_resources_application.yml_application.properties_application.properties_application.yml_3_main_favicon32.ico_https_zhangphil.blog.csdn.net_article_details_126894920]: https://zhangphil.blog.csdn.net/article/details/126894920
[mysql_Windows_zhangphil_-CSDN_mysql_zip_MySQL _ Download MySQL Community Serverhttps_dev.mysql.com_downloads_mysql_my.ini_mysql_my.ini_mysqld_port_3306basedir_D_mysql_mysql-8.0.27-winx64datadir_D_mysql_data_client_ port_3306default-character-s_favicon32.ico_https_blog.csdn.net_zhangphil_article_details_122414377]: https://blog.csdn.net/zhangphil/article/details/122414377
[mysql_root_zhangphil_-CSDN_mysql_zip_MySQL _ Download MySQL Community Serverhttps_dev.mysql.com_downloads_mysql_my.ini_mysql_my.ini_mysqld_port_3306basedir_D_mysql_mysql-8.0.27-winx64datadir_D_mysql_data_client_ port_3306default-character-s_favicon32.ico_https_blog.csdn.net_zhangphil_article_details_126688161]: https://blog.csdn.net/zhangphil/article/details/126688161
[ac23b2e616ba4d0bb4ae59a0d5dedda0.png]: https://img-blog.csdnimg.cn/ac23b2e616ba4d0bb4ae59a0d5dedda0.png
[c4750c5411804a4da71876f59cc41ac8.png]: https://img-blog.csdnimg.cn/c4750c5411804a4da71876f59cc41ac8.png
[bc6f73150a82436cac65788102a4f816.png]: https://img-blog.csdnimg.cn/bc6f73150a82436cac65788102a4f816.png
[623708c6ac6f453d9a003b397ce4b1f2.png]: https://img-blog.csdnimg.cn/623708c6ac6f453d9a003b397ce4b1f2.png
[7655fb1f101345ae873f19e854e69637.png]: https://img-blog.csdnimg.cn/7655fb1f101345ae873f19e854e69637.png
[53cd09fc632e41bda611f5ec49e7bfc8.png]: https://img-blog.csdnimg.cn/53cd09fc632e41bda611f5ec49e7bfc8.png
[879909c3b8a7476eb7cf4d24052cc7f3.png]: https://img-blog.csdnimg.cn/879909c3b8a7476eb7cf4d24052cc7f3.png
[ed7152b706214f97ae65d71192449bd2.png]: https://img-blog.csdnimg.cn/ed7152b706214f97ae65d71192449bd2.png
[367ac2044f3f49c289f0fb9e1561a539.png]: https://img-blog.csdnimg.cn/367ac2044f3f49c289f0fb9e1561a539.png
[49556be5064b45f99c1c7b5b326de649.png]: https://img-blog.csdnimg.cn/49556be5064b45f99c1c7b5b326de649.png
[a4d1798f9e23472c9019e44ac6893fb2.png]: https://img-blog.csdnimg.cn/a4d1798f9e23472c9019e44ac6893fb2.png