我正在使用郵遞員來處理 spring boot api。目前我正在嘗試將資料添加到相關表中。其中有2個地區和城鎮。城鎮有一個 regionid 列。這是我的要求。
{
"name": "test",
"regionid":"2"
}
雖然名稱發布得很好，但區域 ID 為空。我正在嘗試在控制器中列印出來。這是它的保存資料方法：
@PostMapping("/add")
public ResponseEntity<Towns> createtown(@RequestBody Towns town) {
try {
Towns _town = townsrepository
.save(new Towns( town.getName(), town.getRegionid()));
return new ResponseEntity<>(_town, HttpStatus.CREATED);
} catch (Exception e) {
System.out.println(e.getMessage());
System.out.println("region");
System.out.println(town.getRegionid());
return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
我遇到了例外，在列印 town.getName() 時我得到了測驗。但是，當我嘗試列印出 town.getRegionId() 時，我得到了空值。這是我的模型課
package com.example.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import org.hibernate.annotations.OnDelete;
import org.hibernate.annotations.OnDeleteAction;
@Entity
@Table(name = "towns")
public class Towns {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
@Column(name = "name")
private String name;
@ManyToOne(fetch = FetchType.LAZY, optional = false)
@JoinColumn(name = "regionid", nullable = false)
@OnDelete(action = OnDeleteAction.CASCADE)
private Regions regionid;
public Towns() {
}
public Towns(String name,Regions regionid) {
// super();
this.id=id;
this.name = name;
this.regionid=regionid;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Regions getRegionid() {
return regionid;
}
public void setRegionid(Regions regionid) {
this.regionid = regionid;
}
}
和存盤庫：
package com.example.repository;
import java.util.List;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import java.util.Optional;
import com.example.model.Towns;
import com.example.model.Regions;
public interface TownsRepository extends JpaRepository<Towns, Integer> {
List<Towns> findByNameContaining(String name);
Page<Regions> findByregionid(Integer regionid, Pageable pageable);
Optional<Regions> findByregionidAndId(Integer regionId, Integer id);
}
和 Application.properties 以防萬一
spring.datasource.url= jdbc:mysql://localhost:3306/appartmentbuilderbase?useSSL=false
spring.datasource.username= root
spring.datasource.password=
spring.jpa.properties.hibernate.dialect= org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.hibernate.ddl-auto= update
我在這里做錯了什么？
嘗試按照建議進行：
Towns _town = townsrepository .save(new Towns( town.getName(), regionsrepository.findById(town.getRegionid())));
并得到了這些錯誤：
Description Resource Path Location Type
The constructor Towns(String, Optional<Regions>) is undefined TownsController.java /apartmentbuilders/src/main/java/com/example/controller line 71 Java Problem
還有這個：
Description Resource Path Location Type
The method save(S) in the type CrudRepository<Towns,Integer> is not applicable for the arguments (Towns) TownsController.java /apartmentbuilders/src/main/java/com/example/controller line 71 Java Problem
添加完整的控制器代碼
package com.example.controller;
import java.util.ArrayList;
import java.util.List;
import java.util.Optional;
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.example.model.Towns;
import com.example.repository.TownsRepository;
import com.example.repository.RegionsRepository;
@CrossOrigin(origins = "http://localhost:8081")
@RestController
@RequestMapping("/towns")
public class TownsController {
@Autowired
TownsRepository townsrepository;
@Autowired
RegionsRepository regionsrepository;
@GetMapping("/list")
public ResponseEntity<List<Towns>> getAllTowns(@RequestParam(required = false) String name) {
try {
List<Towns> towns = new ArrayList<Towns>();
if (name == null)
townsrepository.findAll().forEach(towns::add);
else
townsrepository.findByNameContaining(name).forEach(towns::add);
if (towns.isEmpty()) {
return new ResponseEntity<>(HttpStatus.NO_CONTENT);
}
return new ResponseEntity<>(towns, HttpStatus.OK);
} catch (Exception e) {
return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
@GetMapping("/list/{id}")
public ResponseEntity<Towns> getTownById(@PathVariable("id") int id) {
Optional<Towns> townData = townsrepository.findById(id);
if (townData.isPresent()) {
return new ResponseEntity<>(townData.get(), HttpStatus.OK);
} else {
return new ResponseEntity<>(HttpStatus.NOT_FOUND);
}
}
@PostMapping("/add")
public ResponseEntity<Towns> createtown(@RequestBody Towns town) {
try {
Towns _town = townsrepository
.save(new Towns( town.getName(), town.getRegionid()));
// Towns _town = townsrepository .save(new Towns( town.getName(), regionsrepository.findByRegionId(town.getRegionid())));
return new ResponseEntity<>(_town, HttpStatus.CREATED);
} catch (Exception e) {
System.out.println(e.getMessage());
System.out.println("region");
System.out.println(town.getRegionid());
return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
@PutMapping("/edit/{id}")
public ResponseEntity<Towns> updateTown(@PathVariable("id") int id, @RequestBody Towns town) {
Optional<Towns> townData = townsrepository.findById(id);
if (townData.isPresent()) {
Towns _town = townData.get();
_town.setName(town.getName());
_town.setRegionid(town.getRegionid());
return new ResponseEntity<>(townsrepository.save(_town), HttpStatus.OK);
} else {
return new ResponseEntity<>(HttpStatus.NOT_FOUND);
}
}
@DeleteMapping("/delete/{id}")
public ResponseEntity<HttpStatus> deleteTown(@PathVariable("id") int id) {
try {
townsrepository.deleteById(id);
return new ResponseEntity<>(HttpStatus.NO_CONTENT);
} catch (Exception e) {
return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR);
}
}
}
添加區域存盤庫
package com.example.repository;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import com.example.model.Regions;
public interface RegionsRepository extends JpaRepository<Regions, Integer> {
List<Regions> findByNameContaining(String name);
}
uj5u.com熱心網友回復：
您缺少 DTO 課程。不要直接將 DB 物體類映射到請求正文。有一個像
@Data
public class TownDTO {
private String name;
private String regionid;
}
同樣在保存時，通過存盤庫獲取區域：
Towns _town = townsrepository
.save(new Towns( town.getName(), regionRepository.findByRegionId(town.regionId)));
所以在控制器中：
@PostMapping("/add")
public ResponseEntity<Towns> createtown(@RequestBody Town town) {
try {
Towns _town = townsrepository
.save(new Towns( town.getName(), regionRepository.findByRegionId(town.regionId)));
return new ResponseEntity<>(_town, HttpStatus.CREATED);
} catch (Exception e) {
System.out.println(e.getMessage());
System.out.println("region");
System.out.println(town.getRegionid());
return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/408183.html
標籤：