STRUTS框架中，如何从数据库表中取数据（100条）？300分

在SQL里加一句TOP 100，再用楼上的办法就OK了。

错误：
500 Internal Server Error
javax.servlet.jsp.JspException: Cannot find bean guide in any scope
at org.apache.struts.util.RequestUtils.lookup(RequestUtils.java:938)
at org.apache.struts.taglib.logic.IterateTag.doStartTag(IterateTag.java:277)
at _admin._gzxx._P040201._jspService(P040201.jsp:84)
[/admin/gzxx/P040201.jsp]
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for J2EE].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:721)
at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for J2EE].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for J2EE].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:536)

package  OST;import OST.jdbc.util.ConnectionPool;
import OST.lykDAO;import java.lang.reflect.InvocationTargetException;
import java.util.Locale;
import javax.servlet.ServletException;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.beanutils.PropertyUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionServlet;
import org.apache.struts.util.ModuleException;
import org.apache.struts.util.MessageResources;import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Collection;public final class lykAction extends Action
{
    // 变量定义：
    private Log log = LogFactory.getLog("org.apache.struts.webapp.Example");    private ConnectionPool pool;    public lykAction() {
        pool = ConnectionPool.getInstance();
    }
    //函数定义：
    public ActionForward execute(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception
    {
// Extract attributes and parameters we will need
Locale locale = getLocale(request);
MessageResources messages = getResources(request);
HttpSession session = request.getSession();
lykForm m_lykForm = (lykForm) form;

     Connection con = null;    try
        {
       con = pool.getConnection();
       lykDAO m_lykDAO = new lykDAO(con);              String action=request.getParameter("action");

       if(action==null)action="find";

           if(action.equals("delete"))
           {
               String expression=request.getParameter("expression");
               m_lykDAO.removeID(expression);
           }
            ////////////
           if(action.equals("update"))
           {
                 String expression=request.getParameter("expression");
                 lyk m_lyk= new lyk();
               //<update>
                 m_lyk.setUser_id(m_lykForm.getUser_id());
                 m_lyk.setPassword(m_lykForm.getPassword());
                 m_lyk.setName(m_lykForm.getName());
                 m_lyk.setDescription(m_lykForm.getDescription());
                 m_lyk.setWeb_site(m_lykForm.getWeb_site());
                 m_lyk.setAddress(m_lykForm.getAddress());
                 //</update>

               m_lykDAO.update(m_lyk,expression);
           }
           ///////////////
       //<sqlstr>
       String sql="SELECT * FROM dbo.attraction";
       //</sqlstr>
      Collection col = m_lykDAO.findSQL(sql);
      request.setAttribute("lyk",col);              //<分页>
      m_lykForm.setRowCount(col.size());
      m_lykForm.setLength(5);//设置每页显示记录数

      String page=request.getParameter("page");
      int ipage;
      try
      {
          ipage=java.lang.Integer.parseInt(page,10);
      }
      catch (Exception e)
            {
                ipage=m_lykForm.getPage();
            }
      m_lykForm.setPage(ipage);
      m_lykForm.setOffset(ipage*m_lykForm.getLength());
      m_lykForm.setPageCount(m_lykForm.getRowCount()/m_lykForm.getLength()+1);

      String strPage="";

      strPage+="共";
      strPage+=String.valueOf(m_lykForm.getRowCount());
      strPage+="条记录，共";
      strPage+=String.valueOf(m_lykForm.getPageCount());
      strPage+="页，当前是第";
      strPage+=String.valueOf(ipage+1);
      strPage+="页，      ";

      int istart,iend;
      istart=ipage-5;
      if(istart<0) {istart=0;}
      iend=istart+10;
      if(iend>m_lykForm.getPageCount()) {iend=m_lykForm.getPageCount();}
      istart=iend-10;
      if(istart<0) {istart=0;}
      for(int i=istart;i<iend;i++)
      {
          strPage+="<a href='lykAction.do?action=find&page=";
          strPage+=String.valueOf(i);
          strPage+="'>";
          strPage+=String.valueOf(i+1);
          strPage+="</a>";
          strPage+="  ";
      }

      m_lykForm.setMybeanvariable1(strPage);
              m_lykForm.setAction(action);
      request.setAttribute("lykForm",m_lykForm);
              //</分页>       return mapping.findForward("success");
    }
catch (SQLException e)
        {
       e.printStackTrace();
       throw new RuntimeException("Unable to get connection.");
     }
        finally
        {
           try
             {
         if (con != null)
           con.close();
            }
             catch (SQLException e)
             {
         throw new RuntimeException(e.getMessage());
            }
       }    }}

调试易

STRUTS框架中，如何从数据库表中取数据（100条）？300分

解决方案 »