我在邮递员中创建POST或GET请求时遇到问题。我有一个控制器,它想保存一个新项目或从DB接收所有项目。
如果我尝试将项目保存到在数据库中实现CommandLineRunner的类中,则一切正常。有关更多详细信息,我将代码放在下面:

这是Project类:

@Entity
@Table(name = "project")

public class Project {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "proj_id")
    private int projectId;

    @Column(name = "project_name")
    private String projectName;

    @Column(name = "dg_number")
    private int dgNumber;

    @ManyToMany(fetch = FetchType.EAGER)
    @JoinTable(
            name = "variant_gate_relation",
            joinColumns = {@JoinColumn(name = "proj_id")},
            inverseJoinColumns = {@JoinColumn(name = "gate_id")}
    )
    private Set<Gate> gates = new HashSet<>();

    @ManyToMany(fetch = FetchType.EAGER)
    @JoinTable(name = "variant_threshold_relation",
               joinColumns = @JoinColumn(name = "proj_id"),
               inverseJoinColumns = @JoinColumn(name = "threshold_id"))
    private Set<Threshold> thresholds = new HashSet<>();

    public Project() {

    }

    public Project(String projectName, int dgNumber, Set<Gate> gates, Set<Threshold> thresholds){
        this.projectName = projectName;
        this.dgNumber = dgNumber;
        this.gates = gates;
        this.thresholds = thresholds;
    }


控制者

@RestController
@RequestMapping(ProjectController.PROJECT_URL)
public class ProjectController {

    public static final String PROJECT_URL = "/cidashboard/projects";

    @Autowired
    private final ProjectService projectService;

    public ProjectController(ProjectService projectService) {
        this.projectService = projectService;
    }

    @GetMapping
    public List<Project> getAllProjects(){
        return projectService.findAllProjects();
    }

    @GetMapping("/{id}")
    public Project getProjectById(@PathVariable int id) {
        return projectService.findProjectById(id);
    }

    @PostMapping
 //   @Consumes(MediaType.APPLICATION_JSON_VALUE)
    public Project saveProject(@RequestBody Project newProj) {
        return projectService.saveProject(newProj);
    }
}


这是我的CommandLineRunner

@Component
public class Test implements CommandLineRunner {

        private final ProjectRepository projectRepository;

        private final GateRepository gateRepository;

        private final ThresholdRepository thresholdRepository;

        public Test(ProjectRepository projectRepository, GateRepository gateRepository, ThresholdRepository thresholdRepository) {
            this.projectRepository = projectRepository;
            this.gateRepository = gateRepository;
            this.thresholdRepository = thresholdRepository;
        }

        @Override
        public void run(String... args) throws Exception {
            Gate gate1 = new Gate("gate5", 23);
            gateRepository.save(gate1);

            Threshold threshold1 = new Threshold(101, "threshold5");
            thresholdRepository.save(threshold1);

            Set<Gate> gates = new HashSet<>();
            gates.add(gate1);

            Set<Threshold> thresholds = new HashSet<>();
            thresholds.add(threshold1);

            Project project1 = new Project("project1", 20, gates, thresholds);
            projectRepository.save(project1);

            List<Project> allProjectsFromDatabase = projectRepository.findAll();

            System.out.println("List of all projects from database : ");

            for (Project project : allProjectsFromDatabase) {
                System.out.println(project.toString());
            }

            System.out.println("---------------------------------------------");

            List<Gate> allGatesFromDatabase = gateRepository.findAll();

            for (Gate gate : allGatesFromDatabase) {
                System.out.println(gate);
            }
        }
    }


我的控制台输出是:

1 project1 201 gate5 23.0 threshold5 101


我尝试从邮递员发出此请求:

  {
   "projectName": "project2",
    "dgnumber": 1,
    "gates": {
        "gateType" : "gate2",
        "gateValue" : 13
    },
    "thresholds": {
        "thresholdType" : "threshold2",
        "thresholdValue" : 22
    }
 }


我收到以下输出:

 {
    "projectId": 3,
    "projectName": "project2",
    "dgnumber": 1
}


在DB中,仅在项目表中保存了数据,在门表,阈值表中,variable_gate_relation和variant_threshold_relation没有保存任何内容

最佳答案

在保存项目之前,请在CommandLineRunner中执行此操作。

        Gate gate1 = new Gate("gate5", 23);
        gateRepository.save(gate1);

        Threshold threshold1 = new Threshold(101, "threshold5");
        thresholdRepository.save(threshold1);

        Set<Gate> gates = new HashSet<>();
        gates.add(gate1);

        Set<Threshold> thresholds = new HashSet<>();
        thresholds.add(threshold1);


从端点保存时,也应复制该副本(gateRepository.save()thresholdRepository.save()在此处相关)。

09-27 23:50