ArrayList的问题

Question

有entity  十几个字段  在数据库取出了千把条数据后set到entity中 再add到list中for循环后就不执行后面的代码了 

Answer 1

没听明白楼主的意思 。for循环？应该是while循环把。for循环应该是在jsp调用的时候用的 。然后返回一个ArrayList对象 。同时希望楼主把代码贴出来。

Answer 2

while(rs.next()) {
    你的实体类 entity = new 你的实体类
    entity.setXX(rs.getXX(''));
    ……
    list.add(entity);
}LZ要的是这个吗？

Answer 3

if (rs != null && rs.getCount() > 0) {
for (int i = 0; i < rs.getCount(); i++) {
bo = new BO_M_townSumpPwdiagMon();
bo.setPwdiagId_(rs.getLong(i, "pwdiagId"));
bo.setPwdiagBlgFary_(rs.getLong(i, "pwdiagBlgFary"));
bo.setPwdiagNum_(rs.getDouble(i, "pwdiagNum"));
bo.setFactoryid_(rs.getLong(i, "factoryid"));
bo.setFillCorp_(rs.getString(i, "fillCorp"));
bo.setFillMon_(rs.getString(i, "fillMon"));
bo.setFillTime_(rs.getDate(i, "fillTime"));
bo.setFillUser_(rs.getString(i, "careaname"));
bo.setComName_(rs.getString(i, "comName"));
bo.setRe_(rs.getString(i, "re"));
bo.setWaterType_(rs.getString(i, "waterType"));
bo.setLayPipe_(rs.getDouble(i, "layPipe"));
bo.setInvestNum_(rs.getDouble(i, "investNum"));
bo.setAreaname_(rs.getString(i, "areaname"));
bo.setIfrefer_(rs.getString(i, "ifrefer"));
bo.setSareaName_(rs.getString(i, "sareaName"));
bo.setAuthId_(rs.getLong(i, "authId"));
bo.setAuthState_(rs.getBoolean(i, "authState"));
bo.setUpdateMemo_(rs.getString(i, "updateMemo"));
bo.setStandPipe_(rs.getDouble(i, "standPipe"));
bo.setWaterPipe_(rs.getDouble(i, "waterPipe"));
lst.add(bo); }
}

Answer 4

是数据过多 吗   for循环 之后的 return list 不执行了

Answer 5

for (int i = 0; i < rs.getCount(); i++) {
改
while(rs.next()){

Answer 6

rs 是用 Rows定义的 

Answer 7

从上到下都没有rs.next()，你叫ResultSet如何定位和移动？？？

Answer 8

没看出什么猫腻。
真没错误信息？？
那就DEBUG下

Answer 9

少了一句rs.next()不然你只有第一条数据的记录

Answer 10

 if( rs != null && rs.getCount() > 0 )
        {
            while( rs.next() )
            {
                bo = new BO_M_townSumpPwdiagMon();
                bo.setPwdiagId_( rs.getLong( i, "pwdiagId" ) );
                bo.setPwdiagBlgFary_( rs.getLong( i, "pwdiagBlgFary" ) );
                bo.setPwdiagNum_( rs.getDouble( i, "pwdiagNum" ) );
                bo.setFactoryid_( rs.getLong( i, "factoryid" ) );
                bo.setFillCorp_( rs.getString( i, "fillCorp" ) );
                bo.setFillMon_( rs.getString( i, "fillMon" ) );
                bo.setFillTime_( rs.getDate( i, "fillTime" ) );
                bo.setFillUser_( rs.getString( i, "careaname" ) );
                bo.setComName_( rs.getString( i, "comName" ) );
                bo.setRe_( rs.getString( i, "re" ) );
                bo.setWaterType_( rs.getString( i, "waterType" ) );
                bo.setLayPipe_( rs.getDouble( i, "layPipe" ) );
                bo.setInvestNum_( rs.getDouble( i, "investNum" ) );
                bo.setAreaname_( rs.getString( i, "areaname" ) );
                bo.setIfrefer_( rs.getString( i, "ifrefer" ) );
                bo.setSareaName_( rs.getString( i, "sareaName" ) );
                bo.setAuthId_( rs.getLong( i, "authId" ) );
                bo.setAuthState_( rs.getBoolean( i, "authState" ) );
                bo.setUpdateMemo_( rs.getString( i, "updateMemo" ) );
                bo.setStandPipe_( rs.getDouble( i, "standPipe" ) );
                bo.setWaterPipe_( rs.getDouble( i, "waterPipe" ) );
                lst.add( bo );
            }
        }
       或者 if( rs != null && rs.getCount() > 0 )
        {
            for( int i = 0; i < rs.getCount(); i ++ )
            {
                rs.next();
                bo = new BO_M_townSumpPwdiagMon();
                bo.setPwdiagId_( rs.getLong( i, "pwdiagId" ) );
                bo.setPwdiagBlgFary_( rs.getLong( i, "pwdiagBlgFary" ) );
                bo.setPwdiagNum_( rs.getDouble( i, "pwdiagNum" ) );
                bo.setFactoryid_( rs.getLong( i, "factoryid" ) );
                bo.setFillCorp_( rs.getString( i, "fillCorp" ) );
                bo.setFillMon_( rs.getString( i, "fillMon" ) );
                bo.setFillTime_( rs.getDate( i, "fillTime" ) );
                bo.setFillUser_( rs.getString( i, "careaname" ) );
                bo.setComName_( rs.getString( i, "comName" ) );
                bo.setRe_( rs.getString( i, "re" ) );
                bo.setWaterType_( rs.getString( i, "waterType" ) );
                bo.setLayPipe_( rs.getDouble( i, "layPipe" ) );
                bo.setInvestNum_( rs.getDouble( i, "investNum" ) );
                bo.setAreaname_( rs.getString( i, "areaname" ) );
                bo.setIfrefer_( rs.getString( i, "ifrefer" ) );
                bo.setSareaName_( rs.getString( i, "sareaName" ) );
                bo.setAuthId_( rs.getLong( i, "authId" ) );
                bo.setAuthState_( rs.getBoolean( i, "authState" ) );
                bo.setUpdateMemo_( rs.getString( i, "updateMemo" ) );
                bo.setStandPipe_( rs.getDouble( i, "standPipe" ) );
                bo.setWaterPipe_( rs.getDouble( i, "waterPipe" ) );
                lst.add( bo );
            }
        }