该段代码主要展示了如何使用Hibernate和JDBC DAO进行SQL查询。首先通过Hibernate DAO获取查询结果，然后遍历这些结果，根据每个结果中的unitJoinProjectId字段生成新的SQL，查询XyEvDirectGrading数据，并将这些数据保存到cDirectGradingResults列表中。整个过程用于从不同表中聚合数据。
根据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 ！
记录一下，以便后续学习！
1939
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
