jsp回显问题!!!!!!!!!!
查询分页显示后,点"下一页"等,它就变成总查询了,不知道怎么在<A Href=test.jsp?ToPage=<%= 1 %>>到第一页</A>行加查询条件代码,请各位帮哈忙!能写哈代码!谢谢
代码如下:
<%!
static Logger log = Logger.getLogger("test.jsp");
int PageSize = 6; //每页显示的记录数量
int ShowPage = 1; //设顶预显示页数
int RowCount = 0; //数据库中的记录数
int PageCount = 0; //总共要显示的页数
if(request.getParameter("nameSearch") != null)
{
if(request.getParameter("nameSearch").length() > 0)
{
ShowPage = 1;
sql = new String("....");
}
if(request.getParameter("citySearch").length() > 0)
{
ShowPage = 1;
sql = new String(".......");
}
String timeTextStart = request.getParameter("timeTextStart");
String timeTextEnd = request.getParameter("timeTextEnd");
if((timeTextStart.length() > 0) && (timeTextEnd.length() > 0))
{
ShowPage = 1;
sql = new String("........");
}
}
else
{
sql = new String(".......");
}
rs = stmt.executeQuery(sql);
if(rs.next())
{
rs.last();
RowCount = rs.getRow();
PageCount = ((RowCount % PageSize) == 0? (RowCount/PageSize) : (RowCount/PageSize)+1);
}
else
{
request.setAttribute("reportErr","Please Enter right information!");
%>
<jsp:forward page="reportErr.jsp"></jsp:forward>
<%
}
String ToPage = request.getParameter("ToPage");
if(ToPage != null)
{
ShowPage = Integer.parseInt(new String(ToPage.getBytes("ISO8859-1"),"UTF-8"));
if(ShowPage > PageCount)
{
ShowPage = PageCount;
}
else if(ShowPage <= 0)
{
ShowPage = 1;
}
}
rs.absolute((ShowPage - 1) * PageSize + 1);
%>
</h3>
<form name="selectform" method="post" action="test.jsp">
<H3 align="left">
请选择姓名查看方式:
</H3>
<label>
<input type="text" name="nameSearch" size="12" height="17.5"> //////
</label>
<h3 align="left">
请选择城市查看方式:
</h3>
<label>
<input type="text" name="citySearch" size="12" height="17.5"> //////
</label>
<h3 align="left">
请选择日期查看方式:
</h3>
<label>
<input type="text" name="timeTextStart" id="timeTextStart" size="12" height="17.5">/////
</label>到
<label>
<input type="text" name="timeTextEnd" id="timeTextEnd" size="12" height="17.5">/////
</label>
</form>
<H3 align="right">当前在第<FONT SIZE = 4 COLOR = red>
<%= ShowPage %></FONT>页, 共
<FONT SIZE = 4 COLOR = red>
<%= PageCount %></FONT>页</H3>
<TABLE>
<TR valign=baseline align=center>
<%
if(ShowPage != 1)
{
%>
<TD Width=150>
<A Href=test.jsp?ToPage=<%= 1 %>>到第一页</A> //////////
</TD>
<TD Width=150>
<A Href=test.jsp?type=ToPage=<%= ShowPage - 1 %>>到上一页</A> ////////////
</TD>
<%
}
if(ShowPage != PageCount)
{
%>
<TD Width=150>
<A Href=test.jsp?ToPage=<%= ShowPage + 1%>>到下一页</A> ////////////
</TD>
<TD Width=150>
<A Href=test.jsp?ToPage=<%= PageCount %>>到最后一页</A> ////////////
</TD>
<%
}
%>
</TABLE>
</body>
</html>