81,092
社区成员
发帖
与我相关
我的任务
分享为什么sqlserver2005模糊查询后的结果分页后结果对不上。
<%@ page contentType="text/html" pageEncoding="utf-8"%>
<html>
<head><title> </title></head>
<script language="javascript">
function go(num){
document.getElementById("cp").value = num ;
document.spform.submit() ; // 表单提交
}
</script>
<body>
<%
int currentPage = 1; //当前页数
int lineSize = 3; //每页显示数
int allRecorders = 0; //所有记录
int pageSize = 1; //全部页数
int lsData[] = {1,2,3,4,5,6,7,8,9,10};
String keyWord = request.getParameter("kw") ;
String url = request.getParameter("url") ;
%>
<%
try{
currentPage = Integer.parseInt(request.getParameter("cp")) ;
} catch(Exception e) {
//System.out.println("取currentPage错误，，，control----------------------------------------------------");
e.printStackTrace();
}
try{
lineSize = Integer.parseInt(request.getParameter("ls")) ;
} catch(Exception e) {
//System.out.println("取lineSize错误，，，control----------------------------------------------------");
e.printStackTrace();
}
try{
allRecorders = Integer.parseInt(request.getParameter("allRecorders")) ;
} catch(Exception e) {
//System.out.println("allRecorders，，，control----------------------------------------------------");
e.printStackTrace();
}
if(keyWord == null) {
keyWord = "";
}
%>
<%
pageSize = (allRecorders + lineSize - 1) / lineSize;
if(pageSize == 0) {
pageSize = 1;
}
%>
<center>
<form action = "<%=url%>" method = "post" name = "spform">
输入查询关键字：<input type="text" name="kw" value="<%=keyWord%>">
<input type="submit" value="查询"><br>
<input type = "button" value = "首页" onclick="go(1)" <%=currentPage==1?"DISABLED":"" %>>
<input type = "button" value = "上一页" onclick="go(<%=currentPage -1%>)" <%=currentPage==1?"DISABLED":"" %>>
<input type = "button" value = "下一页" onclick="go(<%=currentPage +1%>)" <%=currentPage==pageSize?"DISABLED":"" %>>
<input type = "button" value = "尾页" onclick="go(<%=pageSize%>)" <%=currentPage==pageSize?"DISABLED":"" %>>
第<%=currentPage%>页,共<%=pageSize %>页
跳转至第<select name = "selcp" onchange = "go(this.value)">
<%
for(int i = 1;i<=pageSize;i++) {
%>
<option value = "<%=i %>" <%=i==currentPage?"SELECTED":"" %>><%=i %></option>
<%
}
%>
</select>页
每页显示<select name = "ls" onchange = "go(1)">
<%
for(int i = 0;i<lsData.length;i++) {
%>
<option value = "<%=lsData[i]%>" <%=lsData[i]==lineSize?"SELECTED":""%>><%=lsData[i] %></option>
<%
}
%>
</select>条
<input type = "hidden" name = "cp" value = "1">
</form>
</body>
</html>
包含页在下图
<%@ page contentType="text/html" pageEncoding="utf-8"%>
<html>
<head><title> </title></head>
<script language="javascript">
function go(num){
document.getElementById("cp").value = num ;
document.spform.submit() ; // 表单提交
}
</script>
<body>
<%
int currentPage = 1; //当前页数
int lineSize = 3; //每页显示数
int allRecorders = 0; //所有记录
int pageSize = 1; //全部页数
int lsData[] = {1,2,3,4,5,6,7,8,9,10};
String keyWord = request.getParameter("kw") ;
String url = request.getParameter("url") ;
%>
<%
try{
currentPage = Integer.parseInt(request.getParameter("cp")) ;
} catch(Exception e) {
//System.out.println("取currentPage错误，，，control----------------------------------------------------");
e.printStackTrace();
}
try{
lineSize = Integer.parseInt(request.getParameter("ls")) ;
} catch(Exception e) {
//System.out.println("取lineSize错误，，，control----------------------------------------------------");
e.printStackTrace();
}
try{
allRecorders = Integer.parseInt(request.getParameter("allRecorders")) ;
} catch(Exception e) {
//System.out.println("allRecorders，，，control----------------------------------------------------");
e.printStackTrace();
}
if(keyWord == null) {
keyWord = "";
}
%>
<%
pageSize = (allRecorders + lineSize - 1) / lineSize;
if(pageSize == 0) {
pageSize = 1;
}
%>
<center>
<form action = "<%=url%>" method = "post" name = "spform">
输入查询关键字：<input type="text" name="kw" value="<%=keyWord%>">
<input type="submit" value="查询"><br>
<input type = "button" value = "首页" onclick="go(1)" <%=currentPage==1?"DISABLED":"" %>>
<input type = "button" value = "上一页" onclick="go(<%=currentPage -1%>)" <%=currentPage==1?"DISABLED":"" %>>
<input type = "button" value = "下一页" onclick="go(<%=currentPage +1%>)" <%=currentPage==pageSize?"DISABLED":"" %>>
<input type = "button" value = "尾页" onclick="go(<%=pageSize%>)" <%=currentPage==pageSize?"DISABLED":"" %>>
第<%=currentPage%>页,共<%=pageSize %>页
跳转至第<select name = "selcp" onchange = "go(this.value)">
<%
for(int i = 1;i<=pageSize;i++) {
%>
<option value = "<%=i %>" <%=i==currentPage?"SELECTED":"" %>><%=i %></option>
<%
}
%>
</select>页
每页显示<select name = "ls" onchange = "go(1)">
<%
for(int i = 0;i<lsData.length;i++) {
%>
<option value = "<%=lsData[i]%>" <%=lsData[i]==lineSize?"SELECTED":""%>><%=lsData[i] %></option>
<%
}
%>
</select>条
<input type = "hidden" name = "cp" value = "1">
</form>
</body>
</html>
图中第一，二页结果是一样的，我在sql server2005的查询分析器上自己查询出来却又是正确，不过不用模糊查询的话，分页显示的结果倒是正确的。为什么会导致这样的结果？求大神指点。
...全文
请发表友善的回复…
发表回复
tony4geek 2014-10-24
- 打赏
- 举报
你这个debug 看看呢？〉‘
