同一个名称的多条数据只显示最后一条！！！！！！！！！！

Question

 rs = ps.executeQuery();
List lt = new ArrayList();
while(rs.next()) {
wheps = new WeiHuEPS();
wheps.setWheorderId(rs.getString(1));
wheps.setWheuserDept(rs.getString(2));
wheps.setWhecontact(rs.getString(3));
wheps.setWhetel(rs.getString(4));
wheps.setEsetArea(rs.getString(5));
wheps.setWhesaveDate(rs.getString(6));
wheps.setWhesysId(rs.getString(7));
wheps.setWheprodtId(rs.getString(8));
wheps.setWhefaultDesb(rs.getString(9));
wheps.setWhefaultCode(rs.getString(10));
wheps.setWhedealMethod(rs.getString(11));
wheps.setWhefaultPartName(rs.getString(12));
wheps.setWhefaultPartId(rs.getString(13));
wheps.setWhecount(rs.getInt(14));
wheps.setWhechangePartId(rs.getString(15));
wheps.setWhecountt(rs.getInt(16));
wheps.setWhere(rs.getString(17));
wheps.setWherek(rs.getString(18));
wheps.setWheuserDaiBiao(rs.getString(19));
wheps.setWheweihuEngineer(rs.getString(20));
lt.add(wheps);
} 

Answer 1

return mapping.findForward("wheq"); 
======================================
(@^%(@*^%(@^%)(@^%)(@^%)@^
你的jsp呢。
我怀疑你显示的地方没有iterator。
<logic:iterator>

Answer 2

先
把rs放到list里面
Iterator ite = list.iterator();
while (ite.hasNext()) 不然他不会显示list的而是显示rs

Answer 3

改一下SQL语句。
select top 1 ......... order by DESC

Answer 4

实现类：public List<WeiHuEPS> queryByWHEWeihuEngineer(String wheweihuEngineer) throws Exception {
    List<WeiHuEPS> retval = new ArrayList<WeiHuEPS>();
    WeiHuEPS wheps = null; 
    PreparedStatement ps = null; 
    ResultSet rs = null; 
    String sql = null; 
    DBConnection db = null; 
    db = new DBConnection(); 
    sql = "select wheorderId,wheuserDept,whecontact,whetel,esetArea,convert(varchar(10),whesaveDate,120),whesysId,wheprodtId,whefaultDesb,whefaultCode,whedealMethod,whefaultPartName,whefaultPartId,whecount,whechangePartId,whecountt,where,wherek,wheuserDaiBiao from weiHuEPS where wheweihuEngineer=?";     try { 
        ps = db.getConnection().prepareStatement(sql); 
        ps.setString(1, wheweihuEngineer.trim()); 
        rs = ps.executeQuery(); 
        while(rs.next()) { 
            wheps = new WeiHuEPS(); 
            wheps.setWheorderId(rs.getString(1)); 
            wheps.setWheuserDept(rs.getString(2)); 
            wheps.setWhecontact(rs.getString(3)); 
            wheps.setWhetel(rs.getString(4)); 
            wheps.setEsetArea(rs.getString(5)); 
            wheps.setWhesaveDate(rs.getString(6)); 
            wheps.setWhesysId(rs.getString(7)); 
            wheps.setWheprodtId(rs.getString(8));
            wheps.setWhefaultDesb(rs.getString(9)); 
            wheps.setWhefaultCode(rs.getString(10)); 
            wheps.setWhedealMethod(rs.getString(11)); 
            wheps.setWhefaultPartName(rs.getString(12)); 
            wheps.setWhefaultPartId(rs.getString(13)); 
            wheps.setWhecount(rs.getInt(14)); 
            wheps.setWhechangePartId(rs.getString(15)); 
            wheps.setWhecountt(rs.getInt(16)); 
            wheps.setWhere(rs.getString(17)); 
            wheps.setWherek(rs.getString(18)); 
            wheps.setWheuserDaiBiao(rs.getString(19)); 
            wheps.setWheweihuEngineer(rs.getString(20)); 
            retval.add(wheps);
        } 
    } 
    catch(Exception e) { 
        System.out.println(e); 
    } 
    finally { 
        db.cloesConnection(); 
    } 
    return retval; 
} Action类：public ActionForward queryByWHEWeihuEngineer(ActionMapping mapping, ActionForm form, 
HttpServletRequest request, HttpServletResponse response) { 
    String wheweihuEngineer = request.getParameter("wheweihuEngineer"); 
    WeiHuEPS wheps = new WeiHuEPS();     try { 
        List <WeiHuEPS> list = WeiHuEPSDAOFactory.getWeiHuEPSDAOInstance().queryByWHEWeihuEngineer(wheweihuEngineer); 
        request.setAttribute("wheq", list); 
    } 
    catch(Exception e) { 
        System.out.println(e); 
    } 
    return mapping.findForward("wheq"); 
} 

Answer 5

实现类： public List<WeiHuEPS> queryByWHEWeihuEngineer(String wheweihuEngineer) throws Exception {
    List<WeiHuEPS> retval = new ArrayList<WeiHuEPS>();
    WeiHuEPS wheps = null; 
    PreparedStatement ps = null; 
    ResultSet rs = null; 
    String sql = null; 
    DBConnection db = null; 
    db = new DBConnection(); 
    sql = "select wheorderId,wheuserDept,whecontact,whetel,esetArea,convert(varchar(10),whesaveDate,120),whesysId,wheprodtId,whefaultDesb,whefaultCode,whedealMethod,whefaultPartName,whefaultPartId,whecount,whechangePartId,whecountt,where,wherek,wheuserDaiBiao from weiHuEPS where wheweihuEngineer=?";     try { 
        ps = db.getConnection().prepareStatement(sql); 
        ps.setString(1, wheweihuEngineer.trim()); 
        rs = ps.executeQuery(); 
        while(rs.next()) { 
            wheps = new WeiHuEPS(); 
            wheps.setWheorderId(rs.getString(1)); 
            wheps.setWheuserDept(rs.getString(2)); 
            wheps.setWhecontact(rs.getString(3)); 
            wheps.setWhetel(rs.getString(4)); 
            wheps.setEsetArea(rs.getString(5)); 
            wheps.setWhesaveDate(rs.getString(6)); 
            wheps.setWhesysId(rs.getString(7)); 
            wheps.setWheprodtId(rs.getString(8));
            wheps.setWhefaultDesb(rs.getString(9)); 
            wheps.setWhefaultCode(rs.getString(10)); 
            wheps.setWhedealMethod(rs.getString(11)); 
            wheps.setWhefaultPartName(rs.getString(12)); 
            wheps.setWhefaultPartId(rs.getString(13)); 
            wheps.setWhecount(rs.getInt(14)); 
            wheps.setWhechangePartId(rs.getString(15)); 
            wheps.setWhecountt(rs.getInt(16)); 
            wheps.setWhere(rs.getString(17)); 
            wheps.setWherek(rs.getString(18)); 
            wheps.setWheuserDaiBiao(rs.getString(19)); 
            wheps.setWheweihuEngineer(rs.getString(20)); 
            retval.add(wheps);
        } 
    } 
    catch(Exception e) { 
        System.out.println(e); 
    } 
    finally { 
        db.cloesConnection(); 
    } 
    return retval; 
} Action类： public ActionForward queryByWHEWeihuEngineer(ActionMapping mapping, ActionForm form, 
HttpServletRequest request, HttpServletResponse response) { 
    String wheweihuEngineer = request.getParameter("wheweihuEngineer"); 
    WeiHuEPS wheps = new WeiHuEPS();     try { 
        List <WeiHuEPS> list = WeiHuEPSDAOFactory.getWeiHuEPSDAOInstance().queryByWHEWeihuEngineer(wheweihuEngineer); 
        request.setAttribute("wheq", list); 
    } 
    catch(Exception e) { 
        System.out.println(e); 
    } 
    return mapping.findForward("wheq"); 
} 

Answer 6

 rs = ps.executeQuery();
while(rs.next()) {
wheps = new WeiHuEPS(); }你查出来了，可为何不在while中放到List
List <WeiHuEPS> list = new ArrayList <WeiHuEPS>();
list.add(wheps); 这儿只有一个WeiHuEPS对象了，当然只有一条记录

Answer 7

你查出来的结果存在bean里面,然后将bean放入list中,就这么回事
List <WeiHuEPS> list = new ArrayList <WeiHuEPS>(); 
list.add(wheps); 

Answer 8

实现类李加了list后，后台报异常，java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 20 is out of range.怎办是好？

Answer 9

你自己对一下你的sql，一共只查了19个字段出来。这句报错的意思就是你rs.getString(20)取第20个字段出界了。

Answer 10

跳转 别的网页怎么做？
比如跳转到这个 www.5y9y.com 
怎么做？

Answer 11

跳转 别的网页怎么做？ 
比如跳转到这个 http://www.5y9y.com 
怎么做？

Answer 12

一楼说的方法就可以用
得到结果集后，循环结果集，每循环一次得到一个对象放入List
该方法返回一个list就OK了，如果要展现，到页面直接<c:forEach>就行了