我正在嘗試使用帶有 H2 資料庫的 Spring Data Jdbc 實作 Spring Boot Rest API。這是一個微服務，我正在嘗試從 Angular 應用程式向微服務發送 POST 請求。我知道我的 POST 從 Angular 正常作業。在微服務內部，我試圖將 POST 請求保存到本地 H2 資料庫。根據我在網上閱讀的檔案，這應該是相對簡單的，但我收到了錯誤訊息。任何幫助將不勝感激。以下是我在 Spring Boot 微服務中設定的檔案（標題為“訂單”）：
訂單控制器.java：
package com.clothingfly.order;
import java.util.ListIterator;
import org.springframework.web.client.RestTemplate;
import com.clothingfly.order.Model.Item;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import com.clothingfly.order.Model.Order;
@RestController
@CrossOrigin(origins = "http://localhost:4200")
public class OrderController {
@Autowired
TempOrderRepository orderRepository;
@PostMapping("/order")
public Order postOrder(@RequestBody Order order) {
Order _order = orderRepository.save(new Order(order.getId(), order.getAddress(), order.getPayment(), order.getItems()));
return _order;
}
}
TempOrderRepository.java：
package com.clothingfly.order;
import org.springframework.data.jpa.repository.JpaRepository;
import com.clothingfly.order.Model.Order;
public interface TempOrderRepository extends JpaRepository<Order, Long>{
}
訂單應用程式.java：
package com.clothingfly.order;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class OrderApplication {
public static void main(String[] args) {
SpringApplication.run(OrderApplication.class, args);
}
}
我有一個名為 Order.java 的模型：
package com.clothingfly.order.Model;
import java.util.List;
import javax.persistence.*;
import org.springframework.data.annotation.Id;
@Entity
@Table(name = "orders")
public class Order {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@Column(name = "Address")
private Address address;
@Column(name = "Payment")
private PaymentInfo payment;
@Column(name = "Items")
private List<Item> items;
@Column(name = "Error")
private String error;
public Order() {
}
public Order(long id, Address address, PaymentInfo payment, List<Item> items){
this.id = id;
this.address = address;
this.payment = payment;
this.items = items;
this.error = "";
}
public long getId() {
return id;
}
public Address getAddress() {
return address;
}
public PaymentInfo getPayment() {
return payment;
}
public List<Item> getItems() {
return items;
}
public String getError() {
return error;
}
public void setError(String error) {
this.error = error;
}
}
Order 模型包含其他三個模型： Item.java：
package com.clothingfly.order.Model;
import javax.persistence.*;
@Entity
@Table(name = "items")
public class Item {
@Id
@GeneratedValue
@Column(name = "id")
private long id;
@Column(name = "name")
private String name;
@Column(name = "price")
private float price;
@Column(name = "imageUrl")
private String imageUrl;
@Column(name = "quantity")
private long quantity;
@Column(name = "inventory")
private long inventory;
public long getId() {
return id;
}
public String getName() {
return name;
}
public float getPrice() {
return price;
}
public long getQuantity() {
return quantity;
}
public long getInventory() {
return inventory;
}
public String getImageUrl(){
return imageUrl;
}
public void setInventory(long inventory) {
this.inventory = inventory;
}
public void setName(String name) {
this.name = name;
}
public void setPrice(float price) {
this.price = price;
}
public void setQuantity(long quantity) {
this.quantity = quantity;
}
public Item(long id, String name, float price, long quantity, long inventory, String imageUrl) {
this.id = id;
this.name = name;
this.price = price;
this.quantity = quantity;
this.inventory = inventory;
this.imageUrl = imageUrl;
}
public Item() {
}
}
地址.java：
package com.clothingfly.order.Model;
import javax.persistence.*;
@Entity
@Table(name = "addresses")
public class Address {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@Column(name = "firstName")
private String firstName;
@Column(name = "lastName")
private String lastName;
@Column(name = "address")
private String address;
@Column(name = "country")
private String country;
@Column(name = "apartmentNo")
private String apartmentNo;
@Column(name = "state")
private String state;
@Column(name = "city")
private String city;
@Column(name = "zipcode")
private String zipcode;
public Address() {
}
public Address(String firstName, String lastName, String address, String country, String apartmentNo, String state,
String city, String zipcode) {
this.firstName = firstName;
this.lastName = lastName;
this.address = address;
this.country = country;
this.apartmentNo = apartmentNo;
this.state = state;
this.city = city;
this.zipcode = zipcode;
}
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 getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getCountry() {
return country;
}
public void setCountry(String country) {
this.country = country;
}
public String getApartmentNo() {
return apartmentNo;
}
public void setApartmentNo(String apartmentNo) {
this.apartmentNo = apartmentNo;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getZipcode() {
return zipcode;
}
public void setZipcode(String zipcode) {
this.zipcode = zipcode;
}
}
支付資訊.java：
package com.clothingfly.order.Model;
import javax.persistence.*;
@Entity
@Table(name = "payments")
public class PaymentInfo {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@Column(name = "cardHolder")
private String cardHolder;
@Column(name = "cardNumber")
private String cardNumber;
@Column(name = "expirationDate")
private String expirationDate;
@Column(name = "cvv")
private String cvv;
public PaymentInfo(String cardHolder, String cardNumber, String expirationDate, String cvv) {
this.cardHolder = cardHolder;
this.cardNumber = cardNumber;
this.expirationDate = expirationDate;
this.cvv = cvv;
}
public String getCardHolder() {
return cardHolder;
}
public void setCardHolder(String cardHolder) {
this.cardHolder = cardHolder;
}
public String getCardNumber() {
return cardNumber;
}
public void setCardNumber(String cardNumber) {
this.cardNumber = cardNumber;
}
public String getExpirationDate() {
return expirationDate;
}
public void setExpirationDate(String expirationDate) {
this.expirationDate = expirationDate;
}
public String getCvv() {
return cvv;
}
public void setCvv(String cvv) {
this.cvv = cvv;
}
}
嘗試運行微服務時出現以下錯誤：
Unable to build Hibernate SessionFactory; nested exception is org.hibernate.MappingException: Could not determine type for: com.clothingfly.order.Model.Address, at table: orders, for columns: [org.hibernate.mapping.Column(address)]
我將如何解決這個問題？我希望能夠在表格中顯示我的所有模型。
我嘗試更改地址模型，使其僅回傳城市的字串，但這似乎導致的問題比任何事情都多。
uj5u.com熱心網友回復：
請注意，一對一總是會給您帶來問題，總是更好地實施many to one and one to many。并將其添加到您正在映射的兩個物體中。它會做同樣的作業而沒有錯誤。
首先，創建包，不要將所有東西都放在一個包中。創造
package com.clothingfly.repo or com.clothingfly.order.repo
package com.clothingfly.controller or com.clothingfly.order.controller
其次，將注釋添加@Repository到您的存盤庫界面
package com.clothingfly.repo;
import org.springframework.data.jpa.repository.JpaRepository;
import com.clothingfly.order.Model.Order;
@Repository
public interface TempOrderRepository extends JpaRepository<Order, Long>{
}
第三，將注釋添加@EnableJpaRepositories(basePackages = "com.clothingfly.repo")到您的主應用程式類中。
package com.clothingfly.order;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@EnableJpaRepositories(basePackages = "com.clothingfly.repo")
public class OrderApplication {
public static void main(String[] args) {
SpringApplication.run(OrderApplication.class, args);
}
}
最后，這將無法正常作業。不知道你在這里做什么。
@Column(name = "Address")
private Address address;
試試這個：在你的地址物體中添加這個
@ManyToOne(fetch = FetchType.LAZY, optional = false)
@JoinColumn(name="order_id", nullable = false)// add this column
// order_id in your Address database not the entity
@OnDelete(action = OnDeleteAction.CASCADE)
@JsonIgnore
private Order order;
然后，將其添加到您的 Order 類。
@OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, mappedBy="order")
@OnDelete(action = OnDeleteAction.CASCADE)
@JsonIgnore
List<Address> address = new ArrayList<Address>(); // I use list cause sometimes it throws an error
// try to simply use this, if it throws expection then use the list
//private Address address;
您的 Order 建構式應如下所示：
public Order(long id, List<Address> address ...etc
或者干脆
public Order(long id, Address address ...etc
對所有映射物體執行此操作，不要忘記為所有欄位添加 setter 和 getter。
uj5u.com熱心網友回復：
您必須告訴休眠地址物件來自另一個表以及如何連接這些表，因為您的訂單表很可能沒有包含孔地址的列，而是地址的地址 id/主鍵作為外部地址鑰匙。這是可能的，具體取決于您是否與相應的 @OneToOne、@OneToMany、@ManyToOne 和 @ManyToMany 注釋有 1:1、1:n、n:1 或 n:m 關系。對于您的示例，它可能類似于
@OneToOne
@JoinColumn(name = "address_id", referencedColumnName = "id")
private Address address;
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/527959.html
標籤：弹簧靴jpah2
上一篇：初識設計模式 - 備忘錄模式
下一篇：醒醒！你不是真的需要微服務