取前6条信息的问题~~~~~~~~~~~~~~~

Question

 小弟想在页面上显示前5条信息,现在只能显示一条               personBean bean = new personBean();
         DBConnection dn = new DBConnection();
      String  top = "select top 5 s_name,s_money,s_img,s_introduces from FristShop ";
try{
PreparedStatement pt = dn.DBConnections().prepareStatement(top);
ResultSet rt = pt.executeQuery();
while(rt.next())
{
bean.setS_name(rt.getString(1));
bean.setS_money(rt.getString(2));
bean.setS_img(rt.getString(3));
bean.setS_introduces(rt.getString(4));
}
pt.close();
rt.close();
}catch (Exception e) {
e.printStackTrace();
}
  <td>的内容为:      <th height="27" scope="col"><%=bean.getS_name() %></th>目前问题只能取一条,该怎么循环下呢,哪为大哥能帮下忙  取出前5条显示在页面上

Answer 1

Vector vc = new Vector();
while(rt.next())
{
personBean bean = new personBean();   bean.setS_name(rt.getString(1));
   bean.setS_money(rt.getString(2));
   bean.setS_img(rt.getString(3));
   bean.setS_introduces(rt.getString(4)); 
   vc.add(bean);   
}

Answer 2

可以参考我们教程中的写法：http://test.family168.com/tutorial/jsp/html/jsp-ch-05.html#jsp-ch-05-06

Answer 3

DBConnection dn = new DBConnection();
         String  top = "select top 5 s_name,s_money,s_img,s_introduces from FristShop ";
        try{
            PreparedStatement pt = dn.DBConnections().prepareStatement(top);
            ResultSet rt = pt.executeQuery();
            List list=new ArrayList();
           while(rt.next())
            {
                PersonBean bean = new PersonBean();//类名要大写,楼主连这点也不知道
                bean.setS_name(rt.getString(1));   //属性名不要下划线,在数据库里可以,搂主的编码规范有很大问题啊
                bean.setS_money(rt.getString(2));
                bean.setS_img(rt.getString(3));
                bean.setS_introduces(rt.getString(4)); 
                list.add(bean);   
            }
            rt.close();//先开启的后关闭
              pt.close();
        }catch (Exception e) {
            e.printStackTrace();
        }
 在jsp页面
<table>
    <%
    for(int i=0;i<list.size();i++){
    PersonBean bean = (PersonBean)list.get(i);
   %>     <tr>   
          <td height="27" scope="col"> <%=bean.getS_name() %> </td> 
    </tr>
<%}%>
 </table>       
         

Answer 4

楼上正解，建议jsp页面用jstl输出

Answer 5

  List<personBean> list = new ArrayList<personBean> ;
 personBean bean = null;  
while(rt.next()) {
                bean = new personBean() ;
                bean.setS_name(rt.getString(1));
                bean.setS_money(rt.getString(2));
                bean.setS_img(rt.getString(3));
                bean.setS_introduces(rt.getString(4));   
                list.add(list);
            }
楼主就一个javabean ，怎么可能装下5条数据呢 ？？？？？ 
用集合 装载 javabean ,然后循环输出嘛 
 建议用 便签 输出 <c:foreach />
   

Answer 6

  用这个有线程安全 比其他的好 页面可以用迭代标签  <logic:iterate /> 根据情况自己选择