你可以用XML实现离线结果集合,这样查询简单多了
或者你可以通过封装结果集合到SESSION等中介中也可以实现得

解决方案 »

  1.   

    XML我不会阿,而且没有时间学呢
      

  2.   

    <!--------------peiwei创建------最后修改日期 11-18czx ------------------------------>
    <!--中文字符处理GBK-->
    <%@ page contentType="text/html;charset=gb2312"%>
    <%@ page language="java"  %>
    <%@ page import="java.util.*" %>
    <%@ page import="ces.ctcensor.info.DatumInfo" %><jsp:useBean    id="datumInfo"    scope="page"   class="ces.ctcensor.info.DatumInfo" />
    <jsp:useBean    id="paperManager" scope="page" class="ces.ctcensor.info.PaperManager" /> <html>
    <head>
    <link href="css/global.css" rel="stylesheet" type="text/css">
    <link href="css/spec.css" rel="stylesheet" type="text/css">
    </head>
        <body>
    <%
    int  intPage;  //待显示页码  
    String strPage =request.getParameter("page").equals("")?"1":request.getParameter("page");  
    int intRowCount =0; 
    int intPageCount=0;
    int intPageSize=22;  
    intRowCount =paperManager.getMaxRowNo();

    intPageCount  =(intRowCount+intPageSize-1)/intPageSize;
    if( Integer.parseInt(strPage) > intPageCount) {  
    intPage = intPageCount; 
    }else{
        intPage=Integer.parseInt(strPage);
        }

    Vector vcPaperList=new Vector();
    int intFrom=(intPage-1)*intPageSize+1;
    int intTo=intPage*intPageSize+1;

    vcPaperList=paperManager.selectPaperFromTo(intFrom,intTo);
    Vector vcPaperListAll=paperManager.getAllPaperList(false);
        
    if(vcPaperListAll.isEmpty()){
    %>
    <table width="100%" border="0" align="center" bordercolor="#FF9900" cellpadding="0" cellspacing="1" bgcolor="#999999">
    <tr> 
    <td height="24" colspan="7" bgcolor="#FFFFFF"> <div align="center" class="title">共有<%=vcPaperListAll.size()%>条法律文书</div></td>
    </tr>
    <tr>
    <td><input type="button" name="delPaper" value="新 增.." onClick="addPaper()"></td>
    </tr>
    <%  }else{
    %> <table width="100%" border="0" align="center" bordercolor="#FF9900" cellpadding="0" cellspacing="1" bgcolor="#999999">
    <tr> 
    <td height="24" colspan="7" bgcolor="#FFFFFF"> <div align="center" class="title">共有<%=vcPaperListAll.size()%>条法律文书</div></td>
    </tr>
    <tr bgcolor="#E3EEF9">
    <td colspan="7">
    第<input type=text size=1 value=<%=intPage%>>页&nbsp;&nbsp;共<font color="red"><%=intPageCount%></font>页&nbsp;&nbsp;
      
    <%if(intPage>1){%>
    <a  href="pageList.jsp?page=<%=intPage-1%>"><img src="images/dateback.gif"></a>
    <%}%>
      
    <%if(intPage<intPageCount){%>
    <a href="pageList.jsp?page=<%=intPage+1%>"><img src="images/datefwd.gif"></a>
    <%}%>
    </td>
    </tr> <tr bgcolor="#E3EEF9">
    <td width="5%"></td>
    <td width="15%"><div align="center">法律文书编号</div></td>
    <td width="30%"><div align="center">法律文书名称</div></td>
    <td width="20%"><div align="center">主标题</td>
    <td width="20%"><div align="center">主题词</td>
    <td width="10%"><div align="center">创建日期</div></td>
    </tr><form name="paperList" action="delPaper.jsp" method="post">
    <%
    int j=0;
    for(int i=0;i<vcPaperList.size();i++){
    datumInfo=(DatumInfo)vcPaperList.get(i);
    if(i%2==0){
    j=i+1;
    %>
    <tr bgcolor="#FFFFFF" id="tr<%=j%>" onmouseover="javascript:document.all['tr<%=j%>'].bgcolor='#F3F4F5'" onmouseout='' >
    <td bgcolor="#F5EEF7"><div align="center"><%=j%></div></td>
    <td><div align="center"><%=datumInfo.getFileId()%></div></td>
    <td><div align="center"><a href="javascript:" onclick="javascript:window.open('showPaper.jsp?id=<%=datumInfo.getFileId()%>','addpaper','height=480,width=560,scrollbars=yes,left=200,top=100,toolbar=0,status=yes,menubar=0,scrollbars=1,resizable=0,alwaysRaised=1')">
    <%=datumInfo.getFileName()%></a></div></td>
    <td><div align="center"><%=datumInfo.getPaperMainTitle()%></div></td>
    <td><div align="center"><%=datumInfo.getPaperKeyWords()%></div></td>
    <td><div align="center"><%=datumInfo.getFileCreateDate()%></div></td>
    </tr>
    <%
       }else{
    j=i+1;
    %>
    <tr bgcolor="#FFFFEC" onmouseover="javascript:this.bgcolor='blue'">
    <td bgcolor="#F5EEF7"><div align="center"><%=j%></div></td>
    <td><div align="center"><%=datumInfo.getFileId()%></div></td>
    <td><div align="center"><a href="javascript:" onclick="javascript:window.open('showPaper.jsp?id=<%=datumInfo.getFileId()%>','addpaper','height=480,width=560,scrollbars=yes,left=200,top=100,toolbar=0,status=yes,menubar=0,scrollbars=1,resizable=0,alwaysRaised=1')">
    <%=datumInfo.getFileName()%></a></div></td>
    <td><div align="center"><%=datumInfo.getPaperMainTitle()%></div></td>
    <td><div align="center"><%=datumInfo.getPaperKeyWords()%></div></td>
    <td><div align="center"><%=datumInfo.getFileCreateDate()%></div></td>
    </tr>
    <% }//end else
    }//end for
     }//end else
    %>
          </table>
       </form>    
    </body>
    <script>
    function addPaper() { //增加法律文书
    var win = window.open("fillPaper.jsp?id="+-1,"addpaper","height=480,width=560,scrollbars=yes,left=200,top=100,toolbar=0,status=yes,menubar=0,scrollbars=1,resizable=0,alwaysRaised=1");
    win.focus();
    }
    </script>
    </html>