mapper連接表的問題:
要連接兩個(gè)表進(jìn)行查詢, 這時(shí)候要寫出要展示的兩個(gè)表的字段犯戏, 參見SettleOrderVOMapper
當(dāng)作過濾條件的字段不需要放到BaseResultMap中喻犁,不然會(huì)報(bào)set錯(cuò)誤录淡,要排序的話拾枣,將pageable放到map中缺菌,傳入
${pageable.orderProperty} ${pageable.orderDirection}
mapper.jpg
mapper連接表的問題:
要連接兩個(gè)表進(jìn)行查詢, 這時(shí)候要寫出要展示的兩個(gè)表的字段犯戏, 參見SettleOrderVOMapper
當(dāng)作過濾條件的字段不需要放到BaseResultMap中喻犁,不然會(huì)報(bào)set錯(cuò)誤录淡,要排序的話拾枣,將pageable放到map中缺菌,傳入
${pageable.orderProperty} ${pageable.orderDirection}