服務中
當我使用列印輸出 null 的鍵時
但列印正確的 id
請告訴我為什么
我確定資料庫有資料
訂單豆
@EntityListeners(AuditingEntityListener.class)
@Entity
@Table(name = "`Order`")
public class OrderBean {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private String orderNumber;
private String account;
public String getOrderNumber() {
return orderNumber;
}
public void setOrderNumber(String orderNumber) {
this.orderNumber = orderNumber;
}
//Getters and Setter ....
}
訂單DAO
public interface OrderDAO extends JpaRepository<OrderBean, Long>{
@Query(value = "SELECT * FROM `order` WHERE account=?", nativeQuery = true)
public List<OrderBean> findOrderByAccount(String account);
}
訂單服務
public List<OrderBean> findOrderByAccount(String account) {
List<OrderBean> orderBeanList = orderDAO.findOrderByAccount(account);
for(OrderBean orderBean : orderBeanList) {
String key = orderBean.getOrderNumber();
//output:null null
String id = orderBean.getId();
//output:1 2
}
uj5u.com熱心網友回復：
試試這個查詢。
@Query("value = "SELECT * FROM `Order` WHERE account=?1", nativeQuery = true")
public List<OrderBean> findOrderByAccount(String account);
您也可以嘗試將表名稱從“訂單”更改為僅訂單
訂單服務
public List<OrderBean> findOrderByAccount(String account) {
List<OrderBean> orderBeanList = orderDAO.findOrderByAccount(account);
String id = "";
String key = "";
for(OrderBean orderBean : orderBeanList) {
key = orderBean.getOrderNumber();
// or you can try System.out.println(orderBean.getOrderNumber);
//output:null null
id = orderBean.getId();
// or you can try System.out.println(orderBean.getId);
//output:1 2
}
試試這個它可能會解決你的錯誤。
uj5u.com熱心網友回復：
你可以看看這個例子，看起來查詢應該是：
SELECT * FROM OrderBean ob WHERE ob.account=?1
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/515692.html