我有以下代碼用于從多個(gè)表中檢索數(shù)據(jù)（使用連接），然后將每一行映射到 DTOList 但我還需要根據(jù)用戶首選項(xiàng)應(yīng)用過(guò)濾器：每個(gè) table1.name 或 table2.name、table3 等.所以我只想知道在性能和最佳實(shí)踐方面最好的方法是什么；檢索所有行，然后使用 lambda 應(yīng)用過(guò)濾器（更簡(jiǎn)單）使用 Criteria 或其他方式將查詢更改為動(dòng)態(tài)查詢？任何其他解決方案=？@Repositorypublic class ArchiveRepository { @Autowired EntityManager em; String queryStr = "select wsr.id as sampleid, s.id as slideid, tb.name as batchname, k.lot_number as kitlot, " + " 'STRING' as slidetype, tb.worklist_name as worklist, wsr.final_call as results, " + " wa.final_pattern_ids as patterns, 'edited/yesno' as edited, wsr.last_modified_by as user, wsr.last_modified_date as time " + " from slide s " + " left join table2 tb on s.test_batch_id = tb.id " + " left join table3 k on tb.kit_lot_id = k.id " + " left join table4 w on s.id = w.slide_id " + " left join tabl5 pw on pw.well_id = w.id " + " left join tabl6 cw on cw.well_id = w.id " + " left join tabl7 wsr on wsr.patient_well_sample_id = pw.id or wsr.control_sample_id = cw.id " + " left join (select * from *** (other subselect)) wa on wa.well_sample_id = wsr.**id or wa.well_sample_id = wsr.**id " + "where tb.state = 'STATENEEDED'"; public ArchiveDataListDTO getArchiveData(){ Query query = em.createNativeQuery(queryStr); ArchiveDataListDTO archiveDataListDTO = new ArchiveDataListDTO(); List<Object[]> resultL = (List<Object[]>)query.getResultList(); for( Object[] o : resultL){ archiveDataListDTO.addArchiveDataRow( new ArchiveDataDTO((String)o[0], String.valueOf(o[1]), (String) o[2], (String) o[3], (String) o[4], (String) o[5], (String) o[6], (String) o[7], (String) o[8], (String) o[9], (String) o[10])); } return archiveDataListDTO; }}
2 回答
牧羊人nacy
TA貢獻(xiàn)1862條經(jīng)驗(yàn) 獲得超7個(gè)贊
我最終即時(shí)創(chuàng)建了查詢；根據(jù)我從 UI 獲得的過(guò)濾器，我用 Java 組裝查詢并將其發(fā)送到 DB，這更容易，因?yàn)檫@需要很多表......
添加回答
舉報(bào)
0/150
提交
取消