如何为Springboot JPA建立通用的通用存储库

Question

以下是我的模型：-

    @MappedSuperclass
public class IdCommon {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private Long id;

    @Version
    private Long version;

    @CreatedBy
    @Column(name = "created_by")
    private String createdBy;

    @CreatedDate
    private Instant created;

    @LastModifiedBy
    @Column(name = "updated_by")
    private String updatedBy;

    @LastModifiedDate
    private Instant updated;

}



    @Entity
@Table(name="TBL_EMPLOYEES")
public class EmployeeEntity extends IdCommon {
    
    @Column(name="first_name")
    private String firstName;
    
    @Column(name="last_name")
    private String lastName;
    
    @Column(name="email", nullable=false, length=200)
    private String email;
    
    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "EmployeeEntity [id=" + 0 + ", firstName=" + firstName +
                ", lastName=" + lastName + ", email=" + email   + "]";
    }
}

我的存储库和服务：-

@Repository
public interface CommonRepository<E extends IdCommon> extends JpaRepository<E, Long>, 
JpaSpecificationExecutor<E> {

  }

 @Service
 public class EmployeeService {

//@Autowired
EmployeeRepository repository;

//@Autowired
CommonRepository<EmployeeEntity> commonRepository;

@Autowired
public EmployeeService(EmployeeRepository repository, CommonRepository<EmployeeEntity> commonRepository) {
    this.repository = repository;
    this.commonRepository = commonRepository;
}

public Page<EmployeeEntity> getAll(Pageable pageable){
    Specification<EmployeeEntity> specification = (Specification<EmployeeEntity>) (root, query, builder) -> null;
    return commonRepository.findAll(specification, pageable);
}
}

控制器：-

    @RestController
@RequestMapping(path = "/employee")
public class EmployeeController2 {

    @Autowired
    private EmployeeService employeeService;

    @GetMapping(path = "/all")

    @ApiImplicitParams({
            @ApiImplicitParam(name = "page", dataType = "integer", paramType = "query",
                    value = "page number"),
            @ApiImplicitParam(name = "size", dataType = "integer", paramType = "query",
                    value = "Number of records per page."),
    })
    public Page<EmployeeEntity> getAll(@RequestParam(value = "sortBy", required = false, defaultValue = "created") String sortBy,
                                       @ApiIgnore Pageable pageable,
                                       @ApiParam(value = "sortDirection (desc/asc)")
                                       @RequestParam(value = "sortDirection", required = false, defaultValue = "asc") String sortDirection){
        if (sortDirection.equals("desc")) {
            pageable = PageRequest.of(pageable.getPageNumber(), pageable.getPageSize(), Sort.by(sortBy).descending());
        } else {
            pageable = PageRequest.of(pageable.getPageNumber(), pageable.getPageSize(), Sort.by(sortBy).ascending());
        }
        return employeeService.getAll(pageable);
    }
}

org.springframework.beans.factory.beanCreationException：创建类路径资源[org/springframework/boot/autocconfigure/orm/jpa/hibernatejpaconfiguration.class]中定义的名为“Entity ManagerFactory”的bean时出错：调用init方法失败；嵌套异常为org.hibernate.AnnotationException：不能同时用@entity和@MappedSuperClass:com.howtoDoinjava.demo.model.idCommon对实体进行注释

我如何实现这一点？我的要求是具有通用存储库类型。我会有很多类似的实体。为了避免很多代码，我应该使用泛型。

Answer 1

现在已经有一段时间了，我希望你已经得到了你的解决方案。但是，对于其他面临同样问题的人，我会试着解释为什么你的解决方案不起作用。

第一件事是，您的存储库必须用@norepositorybean进行注释，如下所示：

@NoRepositoryBean
public interface CommonRepository<E extends IdCommon> extends JpaRepository<E, Long>, JpaSpecificationExecutor<E> {}

并将在employeeRepository中显示：

public interface EmployeeRepository extends CommonRepository<EmployeeEntity> {
    //you can override some or all of the methods if necessary
}

@Service
public class EmployeeService {

    private EmployeeRepository empRepository;

    public EmployeeService(EmployeeRepository repository) {
        this.empRepository = repository;
    }

    public void saveEmployee(EmployeeEntity entity) {//I added this for a test
        empRepository.save(entity);
    }
    
    public Page<EmployeeEntity> getAll(Pageable pageable) {
        Specification<EmployeeEntity> specification = (Specification<EmployeeEntity>) (root, query, builder) -> null;
        return empRepository.findAll(specification, pageable);
    }
}

@SpringBootApplication
public class DemoApplication implements CommandLineRunner {

    @Autowired
    private EmployeeService service;

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

    @Override
    public void run(String... args) throws Exception {
        EmployeeEntity entity = new EmployeeEntity();
        entity.setEmail("[e-mail]");
        entity.setFirstName("First name");
        entity.setLastName("Last name");
        
        service.saveEmployee(entity);
        
        Page<EmployeeEntity> page = service.getAll(PageRequest.of(0, 1));
        page.getContent().stream().forEach(System.out::println); //output: EmployeeEntity [id=0, firstName=First name, lastName=Last name, email=[e-mail]]
    }

}