第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定
已解決430363個(gè)問(wèn)題,去搜搜看,總會(huì)有你想問(wèn)的

不以逗號(hào)分隔的 Java JPA Left Join

不以逗號(hào)分隔的 Java JPA Left Join

富國(guó)滬深 2022-05-12 18:40:04
JPA結(jié)構(gòu)中MYSQL結(jié)構(gòu)翻譯錯(cuò)誤我有 100% 的 mysql 查詢:SELECT DISTINCT * FROM list_orders LEFT JOIN orders_translate where list_orders._id=orders_translate._order_idquery JPA String query = "SELECT t1 FROM ListOrders t1 LEFT JOIN t1.speakers e WHERE e._id = t1._id";public class OrdersTranslate implements Serializable {private static final long serialVersionUID = 1L;@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Basic(optional = false)@Column(name = "_id")private Long id;@Size(max = 50)@Column(name = "_english_name")private String englishName;@Size(max = 50)@Column(name = "_arabic_name")private String arabicName;@Size(max = 50)@Column(name = "_russian_name")private String russianName;@Size(max = 50)@Column(name = "_french_name")private String frenchName;@Basic(optional = false)@NotNull@Column(name = "_order_id")private int order_id;}公共類 ListOrders 實(shí)現(xiàn) Serializable {private static final long serialVersionUID = 1L;@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Basic(optional = false)@Column(name = "_id")@SerializedName("_id")private Integer id;@Basic(optional = false)@NotNull@Column(name = "_number_id")@SerializedName("_number_id")private int numberId;@Basic(optional = false)@NotNull@Size(min = 1, max = 50)@Column(name = "name")@SerializedName("name")private String name;@OneToOne(cascade = CascadeType.ALL)private List<OrdersTranslate> speakers;}我得到下一個(gè)錯(cuò)誤:[53, 54] FROM 子句具有'ListOrders t1 LEFT JOINN t1.oerders'和'e',它們沒(méi)有用逗號(hào)分隔。[42, 53] 標(biāo)識(shí)變量“t1.oerders”未遵循 Java 標(biāo)識(shí)符的規(guī)則。[56, 56] 必須為范圍變量聲明提供標(biāo)識(shí)變量。JPA查詢有什么問(wèn)題?MySQL 查詢工作正常!
查看完整描述

1 回答

?
長(zhǎng)風(fēng)秋雁

TA貢獻(xiàn)1757條經(jīng)驗(yàn) 獲得超7個(gè)贊

起初 - 如果您在 ListOrders 表中有 OrdersTranslate 數(shù)組,則您沒(méi)有 OneToOne 連接。這是 OneToMany 加入。


請(qǐng)?jiān)谀?ListOrders 課程中嘗試:


@OneToMany(mappedBy="listOrders")

private List<OrdersTranslate> speakers;

在您的 OrdersTranslate 類中:


@ManyToOne

@JoinColumn(name = "_order_id")

private ListOrders listOrders;

然后您的 JPA 查詢將如下所示:


SELECT t1 FROM ListOrders t1 LEFT JOIN t1.speakers e


查看完整回答
反對(duì) 回復(fù) 2022-05-12
  • 1 回答
  • 0 關(guān)注
  • 143 瀏覽
慕課專欄
更多

添加回答

舉報(bào)

0/150
提交
取消
微信客服

購(gòu)課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)