使用条件的java查询
如何使用条件编写以下查询
StringBuilder queryString = new StringBuilder("from BorrowerEvaluationDTO b where b.hasEvaluation = TRUE"+" ");
if(sector != null && !sector.trim().equals("")){
queryString.append (" AND b.sector = '" + sector + "'");
}
queryString.append(" AND b.id in (select needProfile.id from Investment where investor.id = '"+investorId + "')");
# 1 楼答案
我不确定您的模型具体是什么样子,但我认为您的查询或多或少会是这样的: