JPA Repos-有没有一种方法可以在不使用ID的情况下返回所有数据？

Question

我正在尝试根据前端的食物名称返回结果搜索栏。因此，在后端，我需要一个 GetMapping 根据名称返回所有数据。基本上，我想按名称查找所有食品。是否可以在不使用序列号 ID 的情况下执行此操作？

这是我的模型：

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="food")
public class Food {

    @Id
    @Column
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private int id; 
    
    @Column(name="category")
    private String category;
    
    @Column
    private String name;
    
    @Column
    private String price;
    
    @Column
    private String image;
    
    @Column
    private String description;

    public int getId() {
        return id;
    }
//  public void setId(int id) {
//      this.id = id;
//  }

    public String getCategory() {
        return category;
    }
    public void setCategory(String category) {
        this.category = category;
    }

    
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }

    
    public String getPrice() {
        return price;
    }
    public void setPrice(String price) {
        this.price = price;
    }

    
    public String getImage() {
        return image;
    }
    public void setImage(String image) {
        this.image = image;
    }

    
    public String getDescription() {
        return description;
    }
    public void setDescription(String description) {
        this.description = description;
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
}

这是我的存储库

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import com.winecoff.backend.models.Food;

@Repository
public interface FoodRepository extends JpaRepository<Food, Integer> {
    
    List<Food> findByName(String name); 
    List<Food> findByCategory(String category);
    
}

这是我的控制器

package com.winecoff.backend.controllers;

import java.util.ArrayList;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import com.winecoff.backend.exceptions.ResourceNotFoundException;
import com.winecoff.backend.models.Food;
import com.winecoff.backend.repositories.FoodRepository;

@RestController
@CrossOrigin
@RequestMapping("/api/v1/")
public class FoodController {

    @Autowired
    private FoodRepository foodRepo; 
    
    
    // Read and return all food items
    @GetMapping("allfood")
    public List<Food> getAllFood(){
        return foodRepo.findAll(); 
    }
    
//  This is where I am having trouble
    @GetMapping("food/name")
    public List<Food> findAllByFoodName(String name) {
        return (List<Food>) foodRepo.findByName(name);
    }
    
    //Read and return all by category
    @GetMapping("food/category/{category}")
    public List<Food> findByCategory(@PathVariable String category){
        return (List<Food>) foodRepo.findByCategory(category); 
    }

    
//  Get food item by id
    @GetMapping("food/{id}")
    public ResponseEntity<Food> getFoodById(@PathVariable int id){
        Food food = foodRepo.findById(id)
                .orElseThrow(() -> new ResourceNotFoundException("Food not found.")); 
        return ResponseEntity.ok(food); 
    }
    
    
//   Delete by id 
//  Question: Wont this change the whole menu and not whats just in the cart? 
    @DeleteMapping("food/{id}")
    public ResponseEntity<String> deleteFood(@PathVariable int id) {
            foodRepo.findById(id);
//              .orElseThrow(() -> new ResourceNotFoundException("Student not found."));
            
//          Delete method from jpa
            foodRepo.deleteById(id); 
            return new ResponseEntity<>("Food has been deleted", HttpStatus.OK); 
        }
    
//  add food to api
    @PostMapping("addfood")
    public Food newFood(@RequestBody Food food) {
        return foodRepo.save(food); 
    }
    
    
//  update food obj keys, such as name to the api
    @PutMapping("food/{id}")
    public ResponseEntity<Food> updateFood(@PathVariable int id, @RequestBody Food newFoodInfo){
        Food foundFood = foodRepo.findById(id)
                .orElseThrow(() -> new ResourceNotFoundException("Food not found."));
        
        foundFood.setCategory(newFoodInfo.getCategory()); 
        foundFood.setName(newFoodInfo.getName()); 
        foundFood.setPrice(newFoodInfo.getPrice()); 
//      foundFood.setId(newFoodInfo.getId()); 
        
        Food updatedFood = foodRepo.save(foundFood);
        
        return ResponseEntity.ok(updatedFood);  
    }
    
}

Answer 1

您可以使用@Query注释并编写自己的自定义查询。

 @Query("SELECT e FROM food e WHERE e.name = :name")
 List<Food> findByName(@Param("name") String name); 

或者从 FoodRepository 接口创建自定义存储库类实现并创建自定义查询。

@PersistenceContext
private EntityManager entityManager;

@Override
public List<Food> findAllByFoodName(String name) {
        String query = String.format("SELECT * FROM food WHERE name = '%s' ", name);
        Query q = entityManager.createNativeQuery(query);
        List<Food> result = q.getResultList();
        return result;
    }

Answer 2

是的，您可以在存储库中进行自定义查询：

尝试

@Query(value="your query")
List<Food> getFoodByFilter(@Param("filter") String filter);

此页面可以帮助您： https:// /www.baeldung.com/spring-data-jpa-query