java读取存储过程

/**
* 获取项目级构建
*
* @param Conditions
* 查询条件
* @return
*/
public List<?> getProject(Map<String, Object> conditions) {
Session session = getSession();
log.debug("获取项目级构建conditions(" + conditions + ")");
try {
// 存储过程
Query query = getSession().createSQLQuery("{Call PROCE_CI_SEL_PROJECT(?,?,?)}");
// 执行存储过程，返回结果集
return exeProcdure(conditions, query);
} catch (RuntimeException e) {
log.debug("获取项目级构建信息出现异常:", e);
throw e;
} finally {
session.close();
}
}



/**
* 执行存储过程，获得结果集
*
* @param conditions
* 参数列表
* @param query
* hibernate的query对象，用于执行存储过程
* @return 结果集列表
*/
private List<?> exeProcdure(Map<String, Object> conditions, Query query) {
// 起始时间
String startTime = String.valueOf(conditions.get("startTime"));
// 结束时间
String endTime = String.valueOf(conditions.get("endTime"));

// 查询开始时间一天内的值
startTime = startTime + " 00:00:00";
endTime = endTime + " 23:59:59";
query.setParameter(0, startTime);
query.setParameter(1, endTime);
query.setParameter(2, "false");
return query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
}


service:


@SuppressWarnings("unchecked")
public List<ProjectVessionScore> projectScorebyproc(Map<String, Object> conditions){

List<ProjectVessionScore> listVessionAndProjectproc =new ArrayList<ProjectVessionScore>();
//listProject根据bmt和pdu获得项目级集合
List<?> listProject=dao.getProject(conditions);
for (Map<String, Object> obj : (List<Map<String, Object>>) listProject) {
ProjectVessionScore vb=new ProjectVessionScore();
int scores=Integer.parseInt(String.valueOf(obj
.get("Score") == null ? 0 : obj
.get("Score")));
vb.setScore(scores);
vb.setBmt(String.valueOf(obj.get("BMT")));
vb.setPud(String.valueOf(obj.get("PDU")));
vb.setIscorp(String.valueOf(obj.get("IS_CORP")));
listVessionAndProjectproc.add(vb);
}
return listVessionAndProjectproc;
}