100分求完整代码：在Action中开ResultSet放在request中，然后在jsp用<logic:iterate>完全显示

Question

信息类：
public class TitleInfo
{
  String title="";
  String titleContent="";
  String writer="";
  String createTime="";
  String lastTime="";
  String lastuser="";
  int  titleId=0;
  int bbsId=0;
  public TitleInfo()
  {
  }
  public int getTitleId()
  {
    return titleId;
  }
  public void setTitleId(int titleId)
  {
    this.titleId=titleId;
  }
  public String getTitle()
  {
    return title;
  }
  public void setTitle(String title)
  {
    this.title=title;
  }
  public String getTitleContent()
  {
    return titleContent;
  }
  public void setTitleContent(String titleContent)
  {
    this.titleContent=titleContent;
  }
  public String getWriter()
  {
    return writer;
  }
  public void setWriter(String writer)
  {
    this.writer=writer;
  }
  public String getCreateTime()
  {
    return createTime;
  }
  public void setCreateTime(String createTime)
  {
    this.createTime=createTime;
  }
  public String getLastTime()
  {
    return lastTime;
  }
  public void setLastTime(String lastTime)
  {
    this.lastTime=lastTime;
  }
  public String getLastuser()
  {
    return lastuser;
  }
  public void setLastuser(String lastuser)
  {
    this.lastuser=lastuser;
  }
  public int getBbsId()
  {
    return bbsId;
  }
  public void setBbsId(int bbsId)
  {
    this.bbsId=bbsId;
  }}import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Vector;
import java.sql.*;
import java.util.Collection;
数据查询实现类：
public class QueryTitle
{
  DataConn data=null;
  Connection con=null;
  Statement st=null;
  ResultSet rs=null;
  TitleInfo title=null;
  Collection v=null;
  String sql="";
  public QueryTitle()
  {
    data=new DataConn();
    v=new Vector();
  }
  public Collection getTitleInfo()
  {
    try
    {
      con=data.getDataConn();
      st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                               ResultSet.CONCUR_READ_ONLY);
      sql="select * from title order by titleId";
      rs=st.executeQuery(sql);
      if(rs.next())
      {
        while(rs.next())
        {
          title=new TitleInfo();
          title.titleId=rs.getInt("titleId");
          title.title=rs.getString("title");
          title.titleContent=rs.getString("titleContent");
          title.writer=rs.getString("writer");
          title.createTime=rs.getString("createTime").substring(0,16);
          title.lastuser=rs.getString("lastuser");
          title.lastTime=rs.getString("lastTime").substring(0,16);
          title.bbsId=rs.getInt("bbsId");
          //System.out.println(title.getTitleId());
          v.add(title);
        }
        System.out.println("已查到相关记录！");
      }
      rs.close();
      st.close();
      con.close();
    }
    catch (SQLException ex)
    {
      System.err.println("没有相关信息！");
      ex.printStackTrace();
    }
    return v;
  }
  public static void main(String[] args)
  {
    QueryTitle queryTitle1 = new QueryTitle();
    queryTitle1.getTitleInfo();
  }}
Action类：
import org.apache.struts.action.*;
import javax.servlet.http.*;
import java.util.Collection;public class LoginAction extends Action
{
  boolean flag=false;
  String target="";
  Login login=null;
  QueryTitle title=null;
  Collection v=null;
  public ActionForward perform(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse)
  {
    login=new Login();
    flag=login.check(httpServletRequest);
    if(flag)
    {
      target="success";
      title=new QueryTitle();
      v=title.getTitleInfo();
      httpServletRequest.setAttribute("title",v);
    }
    else
      target="failure";
    return actionMapping.findForward(target);
  }
}
页面部分代码： 
 <logic:iterate id="titleInfo" name="title">
  <tr bgcolor="#FFFFFF">
    <td height="20" align="left" valign="bottom"><a href="bbs.jsp?titleId=<bean:write name="titleInfo" property="titleId"/>"><bean:write name="titleInfo" property="title"/></a></td>
    <td height="20" align="left" valign="bottom"><bean:write name="titleInfo" property="titleContent"/></td>
    <td height="20" align="center" valign="bottom"><bean:write name="titleInfo" property="writer"/></td>
    <td height="20" align="center" valign="bottom"><bean:write name="titleInfo" property="createTime"/></td>
    <td align="center" valign="bottom"><bean:write name="titleInfo" property="lastuser"/></td>
    <td height="20" align="center" valign="bottom"><bean:write name="titleInfo" property="lastTime"/></td>
  </tr>
  </logic:iterate>
  <logic:iterate id="titleInfo" name="title">
  <tr bgcolor="#FFFFFF">
    <td height="20" align="left" valign="bottom"><a href="bbs.jsp?titleId=<bean:write name="titleInfo" property="titleId"/>"><bean:write name="titleInfo" property="title"/></a></td>
    <td height="20" align="left" valign="bottom"><bean:write name="titleInfo" property="titleContent"/></td>
    <td height="20" align="center" valign="bottom"><bean:write name="titleInfo" property="writer"/></td>
    <td height="20" align="center" valign="bottom"><bean:write name="titleInfo" property="createTime"/></td>
    <td align="center" valign="bottom"><bean:write name="titleInfo" property="lastuser"/></td>
    <td height="20" align="center" valign="bottom"><bean:write name="titleInfo" property="lastTime"/></td>
  </tr>
  </logic:iterate>

Answer 1

1、将结果集封装到java.util.LinkedList
java.util.LinkedList list = new LinkedList();
while (rs.next()){
  UsersBean uBean = new UsersBean();
  uBean.setId(rs.getString("INT_ID"));
  ……
  list.add(uBean);
}2、action 中 
   LinkedList usersList = new LinkedList();
   usersList = 数据库层返回来的list;
   request.setAttribute("usersList",usersList);//3、jsp页面
<logic:iterate id="list" name="usersList" type="com.ulika.eet.bean.UsersBean">
  <tr>     
    <td><bean:write name="list" property="usertypename" /></td>
    <td><bean:write name="list" property="username" /></td>
    <td><bean:write name="list" property="username" /></td>
  </tr>
</logic:iterate>
够详细的吧？

Answer 2

testInformation testInf=new testInformation();
              testInf.setId(id) ;
              testInf.setName(rs.getString(2) );
              httpServletRequest.setAttribute("testInf",testInf) ; <logic:iterate id="testInf" collection="<%=testInf%>">
<td valign="middle" align="center"><font color="black"><bean:write name="testInf" property="id"/></font></td>
  </logic:equal>
      <td valign="middle" align="center"><font color="black"><bean:write name="testInf" property="name"/></font></td>
 </logic:iterate>