根据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 !
记录一下,以便后续学习!