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

[liuhong_20]

小弟想在页面上显示前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条显示在页面上

[longshenls]

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);
}

[临远]

可以参考我们教程中的写法：

http://test.family168.com/tutorial/jsp/html/jsp-ch-05.html#jsp-ch-05-06

[liuhong_20]

没有在详细的了吗?

[淡定的峰哥]

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>

[sun606]

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 />

[eric0cn]

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

[i_saw_you]

[Quote=引用 1 楼 longshenls 的回复:]
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);
}


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

[huihui0103]

Vector 就可以

[liuhong_20]

有最佳答案了 呵呵~~~