Java根据SQL语句条件查询，循环保存查询到的结果

根据SQL语句条件查询，循环保存查询结果

IBaseDAOHibernate dao = PersistentFactory.getHibernateDao();
IBaseDAOJdbc daoJdbc = PersistentFactory.getJdbcDao();
String sqlLast = "from XyEvLastResult where unitJoinProjectId in (" + buffer.toString() + ") order by unitScore desc";
List<LastResult> lastResults = new ArrayList<LastResult>();
lastResults = dao.find(sqlLast, parameters.toArray());
List<XyEvDirectGrading> cDirectGradingResults = new ArrayList<XyEvDirectGrading>();
        for(XyEvLastResult xyEvLastResult : lastResults) {
            String unitJoinProjectID = xyEvLastResult.getUnitJoinProjectId().substring(0, 32);
            String sqlForDirectGrading = "select * from T_XY_EV_DIRECT_GRADING where SEGMENT_ID = '" + unitJoinProjectID + "' and CHECK_STATUS = '1' and UNIT_LEVEL = 'C'";
            List<XyEvDirectGrading> gradingList = daoJdbc.query(sqlForDirectGrading, BeanPropertyRowMapper.newInstance(XyEvDirectGrading.class));
            cDirectGradingResults.addAll(gradingList);
        }

作用：将通过xyEvLastResult的unitJoinProjectID 查询XyEvDirectGrading对象的数据存入cDirectGradingResults ！
记录一下，以便后续学习！