Question

jsp+sql2000模糊查询不能分页，只能显示第一页。新手急需高手解救以下按顺序的跳跃的贴部分代码。

<%
String str2,searchkindstr;
String seachkind = request.getParameter("seachkind");
String seachstr = request.getParameter("seachstr");

if(seachkind==null){
searchkindstr="";
}
else{
searchkindstr="where " +seachkind+ " like '%"+seachstr+"%'";
}
%>

<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<form name="form1" method="post" action="q_dd_q.jsp">
<tr bgcolor="#d6dff7">
<td height="30" align="right" bgcolor="#d6dff7"><div align="center"><span class="STYLE5">搜索用户：</span>
<input name="seachstr" type="text" id="seachstr" size="20">
<select name="seachkind">
<option value="qcbh" select>汽车编号</option>
<option value="qcmc">汽车名</option>
<option value="cx">车型</option>
<option value="cj">厂家</option>
<option value="ccrq">出厂日期</option>
<option value="rksj">入库时间</option>
</select>
<input type="submit" name="Submit" value=" 搜 索 ">
</div></td>
</tr>
</form>
接发的代码： <div align="center">
<%out.print("共<font color=red>"+intRowCount+"</font>辆汽车 <font color=red>"+intPageSize+"</font>/页 共<font color=red>"+intPageCount+"</font>页");%>
当前第<font color=red><%=intPage%></font>页 </div></td>
<td width="58%" >   <div align="right">
<%if(intPage<=1){%>首页<%}else{%><a href="q_dd_q.jsp?pages=1&seachkind<%=seachkind%>&seachstr=<%=seachstr%>">首页</a><%}%><%if(intPage>1){%>
<a href="q_dd_q.jsp?pages=<%=intPage-1%>&seachkind<%=seachkind%>&seachstr=<%=seachstr%>">上一页</a>
<%}else{%>上一页 <% }%><%if(intPage<intPageCount){%>
<a href="q_dd_q.jsp?pages=<%=intPage+1%>&seachkind<%=seachkind%>&seachstr=<%=seachstr%>">下一页</a>
<%}else{%>下一页 <%}%><%if(intPageCount<=1||intPage==intPageCount){%>尾页<%}else{%>  <a href="q_dd_q.jsp?pages=<%=intPageCount%>&seachkind<%=seachkind%>&seachstr=<%=seachstr%>">尾页</a> 
<%}%>
</div></td>

Answer 1

你要手写一个分页类，分页类里面要有几个属性：当前页数，总页数，当前页数有几行数据，总行数，

再写几个方法，进行判断，有没有上一页，下一页，

再手写一个标签。引用分页类，

Answer 2

>&seachkind<%=seachkind%>& 你这样传参数是不对的。等号哪里去了。

Answer 3

用JAVABEAN分页