如何使用JPA操作数据库

接前一篇 SpringBoot&H2项目搭建

操作数据库

• 引入JPA依赖

  <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-jpa</artifactId>
  </dependency>
  

• 创建@Entity实体

  @Data
  @NoArgsConstructor
  @DynamicInsert
  @DynamicUpdate
  @Entity
  public class AdminAcc {
      @Id
      @Column(name = "USER_ID", nullable = false)
      private Integer userId;
  
      @Column(name = "USER_NAME")
      private String userName;
  }
  

• 创建@Repository操作对象

  import org.springframework.data.jpa.repository.JpaRepository;
  import org.springframework.stereotype.Repository;
  import privs.alan.autogeneration.repository.model.AdminAcc;
  
  @Repository
  public interface AdminAccRepository extends JpaRepository<AdminAcc, Long> {
  
  }
  

• 最后可通过注入Repository对象，使用其增删改查方法：

  // 举个查询的例子
  @Resource private AdminAccRepository adminAccRepository;
  ...
  AdminAcc condition = new AdminAcc();
  condition.setUserName("张三");
  
  ExampleMatcher matcher = ExampleMatcher.matching()
          .withMatcher("USER_NAME", ExampleMatcher.GenericPropertyMatchers.contains());
  
  Example<AdminAcc> example = Example.of(condition, matcher);
  return adminAccRepository.findAll(example);