i have 3 tables in database: room, roomtype , booking.
room entity:
@id @generatedvalue(strategy = generationtype.identity) private long roomid; private long doorcode; @manytoone(optional = false, fetch = fetchtype.lazy) @joincolumn(name = "roomtypeid") private roomtype roomtype;
roomtype entity:
@id @generatedvalue(strategy = generationtype.identity) private long roomtypeid; private string name; private string photo;
booking entity:
@id @generatedvalue(strategy = generationtype.identity) private long bookingid; @manytoone(optional = false, fetch = fetchtype.lazy) @joincolumn(name = "roomid") private room room; private date fechar;
i want make join between room , booking see rooms between dates when try make join, can between room , roomtype entities.
"select u room h left join h.roomtype"
how join room booking?
Comments
Post a Comment