teacher表：id、name、age、group_idbook表：id、name、description、teacher_id關(guān)系：一對多---------------------------------------------------------------------------------------------------------問題：我想?通過book的id查詢到對應(yīng)的book信息和teacher信息，他們之間在建立實(shí)體類的時候應(yīng)該如何關(guān)聯(lián)？
3 回答
浮云間
TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超4個贊
select * from book where id = xxx; select * from teacher where id = (select teacher_id from book where id = xxx);
幕布斯6054654
TA貢獻(xiàn)1876條經(jīng)驗(yàn) 獲得超7個贊
實(shí)體類就按照表字段建，然后傳bookid查book數(shù)據(jù)取得teacher_id查teacher表，數(shù)據(jù)不就都出來了
添加回答
舉報(bào)
0/150
提交
取消