Hibernate（二）——Springboot整合Hibernate

港控/mmm° 2024-03-22 11:39 13阅读 0赞

在了解了Hibernate后，进一步将Hibernate和Springboot整合。

#### 目录 ####

*  引入依赖
 *  配置文件
 *  代码
 *   *  Bean
     *  Dao层
     *  Service层
     *  Controller层
 *  测试
 *  JpaRepository接口

## 引入依赖 ##

<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.12</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>

## 配置文件 ##

server:
      port: 8080
    
    spring:
      application:
        name: springboot-hibernate
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        username: root
        password: 123456
        url : jdbc:mysql://local:3306/test?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8&useSSL=false
      jpa:
        database: mysql
        show-sql: true # 是否打印 sql 语句
        hibernate:
          ddl-auto: update
        properties:
          hibernate:
            dialect: org.hibernate.dialect.MySQL5Dialect

## 代码 ##

### Bean ###

@Entity
    @Data
    @Builder
    @Table(name = "t_user")
    public class UserBean {
        
    
        @Id
        @GeneratedValue(strategy = GenerationType.AUTO)
        private String id;
    
        @Column
        private String username;
        @Column
        private String password;
    
    }

### Dao层 ###

@Repository
    public interface UserRepository extends JpaRepository<UserBean,String> {
        
    }

### Service层 ###

public interface UserService {
        
    
        UserBean add(UserBean userBean);
    
        List<UserBean> queryAll();
    }

实现类

@Service
    public class UserServiceImpl implements UserService {
        
    
        @Autowired
        private UserRepository userRepository;
    
        @Override
        public UserBean add(UserBean userBean) {
        
            UserBean user = userRepository.save(userBean);
            return user;
        }
    
        @Override
        public List<UserBean> queryAll() {
        
            List<UserBean> userBeans = userRepository.findAll();
            return userBeans;
        }
    }

### Controller层 ###

@RestController
    @RequestMapping("user")
    public class UserController {
        
    
        @Autowired
        private UserService userService;
    
        @RequestMapping("findAll")
        public List<UserBean> findAll(){
        
            return userService.queryAll();
        }
    }

## 测试 ##

访问/user/findAll，当前数据库没有对应的表，返回为空  
![在这里插入图片描述][f2d9626b3d144d9dbbbca8b1ef211cce.png]、  
查看数据库已经创建对应的表  
![在这里插入图片描述][31c6fe63aff64fbcb287b1f15d9bafa0.png]

## JpaRepository接口 ##

通过JpaRepository泛型类，里面已经封装了集成的数据库操作方法  
![在这里插入图片描述][99a52054aab64b328148182c7aae4cdc.png]

[f2d9626b3d144d9dbbbca8b1ef211cce.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/10ccc38aa6aa4eb5900d3628be8547e6.png
[31c6fe63aff64fbcb287b1f15d9bafa0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/275bdf1cc16048f6ae492fd32b37298c.png
[99a52054aab64b328148182c7aae4cdc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/697b398a3bb04db7b9bdd4093494e6a4.png