---
title: "关于for循环的跳出问题技巧及数据集的处理方式"
author: "ljl.java"
date: "2012-11-19T21:22:38Z"
tags: []
categories: ["编程语言"]
slug: "for"
draft: false
lastmod: "2012-11-19T21:22:38Z"
id: 1729795
url: "https://ljl-java.iteye.com/blog/1729795"
---

![](http://dl.iteye.com/upload/attachment/0076/8004/e5d2135d-5035-3b68-9e51-5ebbbc192a42.jpg)

如图所示：对结果集的操作主要步骤如下

String sql = "select * from emp";  
pstmt = conn.prepareStatement(sql);

//第四步，返会结果集  
rs = pstmt.executeQuery();  
while (rs.next()) {  
int ID = rs.getInt("ID");  
String org\_code = rs.getString("org\_code");

String org\_name = rs.getString("org\_name ");

String org\_count = rs.getString("org\_count");

}

这样就能够得到各个字段的值进而对各字段进行操作，这是jdbc提供的处理方法

但如果情况如下使用Hibernate查询返回的List 需要对其用Iterator遍历拆解在放入到实体中

代码如下：

 

public Pagination queryOrg\_InfoCount(int siteId,int areaId ,String orgName, int pageNo, int pageSize) {  
  ArrayList&lt;Org\_Info&gt; org\_Info\_list = new ArrayList();  
  Org\_Info bmsg=null;  
  String sql="";  
  try {  
   if(areaId!=0)  
   {  
    if(orgName!=null)  
    {  
     sql="select a.id,a.org\_code,a.org\_name,(select count(\*) from llt\_report b where b.send\_org\_id=a.id) as org\_count from llt\_org\_info a where a.area\_code="+ areaId + " and (a.org\_name like '"+ orgName+ "' or a.org\_code like '"+orgName+"') order by org\_count desc";  
    }  
    else  
    {  
     sql="select a.id,a.org\_code,a.org\_name,(select count(\*) from llt\_report b where b.send\_org\_id=a.id) as org\_count from llt\_org\_info a where a.area\_code="+ areaId + "  order by org\_count desc";  
    }  
   }  
   else  
   {  
    sql="select a.id,a.org\_code,a.org\_name,(select count(\*) from llt\_report b where b.send\_org\_id=a.id) as org\_count from llt\_org\_info a order by org\_count desc";  
   }  
   Query query =getSession().createSQLQuery(sql);  
   int totalCount = query.list().size();  
   Pagination p = new Pagination(pageNo, pageSize, totalCount);  
   query.setFirstResult(p.getFirstResult());  
   query.setMaxResults(p.getPageSize());  
   List list =query.list();  
   Iterator it=list.iterator();  
   Object \[] results;  
   while(it.hasNext())  
   {  
    bmsg = new Org\_Info();  
    results=(Object\[]) it.next();  
     
    for(int i=0;i&lt;results.length;i++)  
    {  
     bmsg.setId(Integer.parseInt(results\[i].toString()));  
     bmsg.setOrg\_code(results\[i+1].toString());  
     bmsg.setOrg\_name(results\[i+2].toString());  
     bmsg.setFource\_count(results\[i+3].toString());  
     i = i + results.length - 1; //注意这是重点  
     org\_Info\_list.add(bmsg);  
    }  
    p.setList(org\_Info\_list);  
     
   }  
   return p;  
  } catch (Exception e) {  
   e.printStackTrace();  
  }  
  return null;  
   
 }  
 

如上所示：注释行去掉程序就会在循环里重复读取某一行数据直到报错，这时要读取下一行数据就得跳出for 到while中

这时如注释行：对i索引操作使其条件自相矛盾跳出循环重而达到目的