Spring - Hibernate Session Query 에서 List를 Object[] 로 받기
Posted 11 25, 2009 15:19, Filed under: Language/ㅡ Spring// org.hibernate.Session 또는 org.springframework.orm.hibernate3.HibernateTemplate 을 이용하여 리턴 받은 리스트값을 Object 배열을 이용하여 추출합니다.
//## Controller 에서 Service 호출 부분
List dataList = dataService.selectDataMain(currentPage, countPerPage); Iterator list = dataList .iterator(); while(list.hasNext()) { Object[] data = (Object[])list.next(); logger.debug("data[0] : " + data[0] +", data[1] : " + data[1]+", data[2] : " + data[2]+", data[3] : " + data[3]); if(data[2].equals(1)){branchL.setBranchName((String)data[0]);} if(data[2].equals(2)){branchM.setBranchName((String)data[0]);} if(data[2].equals(3)){branchS.setBranchName((String)data[0]);} }
// ## DAO 부분
public List selectDataMain(int currentPage, int countPerPage){
String[] paramNames = new String[]{"currentPage", "countPerPage"};
Object[] values = new Object[]{currentPage, countPerPage};
List list = getHibernateTemplate().findByNamedQueryAndNamedParam("select.selectDataMainList", paramNames, values);
return list;
}
###
branchListL = donationService.findByBranchL(bean.getBranchL());
branchListM = donationService.findByBranchM(bean.getBranchM());
branchListS = donationService.findByBranchS(bean.getBranchS());
BranchList branchM = new BranchList();
BranchList branchL = new BranchList();
BranchList branchS = new BranchList();
Iterator iter1 = branchListL.iterator();
Iterator iter2 = branchListM.iterator();
Iterator iter3 = branchListS.iterator();
if(iter1.hasNext()){
branchL = (BranchList)iter1.next();
}
if(iter2.hasNext()){
branchM = (BranchList)iter2.next();
}
if(iter3.hasNext()){
branchS = (BranchList)iter3.next();
}
if(branchM.getBranchName() != null) {
branchM.setBranchName(" / " + branchM.getBranchName());
}
if(branchS.getBranchName() != null){
branchS.setBranchName(" / " + branchS.getBranchName());
}
잘못된 정보나 보완이 필요한 부분을, 댓글 또는 메일로 보내주시면 많은 도움이 되겠습니다.
"Language / ㅡ Spring" 분류의 다른 글
Spring - action-servlet.xml 설정 (컨트롤러 추가후 에러 내용 확인 사항) (0) | 2009/04/05 |
Spring - Redirect 방식 (0) | 2009/02/09 |
Java - Spring 개발환경 모듈 구성 (0) | 2009/01/13 |
Trackback URL : http://develop.sunshiny.co.kr/trackback/342