81,077
社区成员
发帖
与我相关
我的任务
分享分页问题，请帮忙
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ page language="java" contentType="text/html; charset=gb2312"%>
<%@page import="java.util.ArrayList"%>
<%@page import="com.bean.Userbean"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>index </title>
</head>
<body>
<a href="/kaoqin/servlet/Liservlet?method=adduser">添加 </a> <br>
<table>
<tr>
<td>id </td>
<td>code </td>
<td>name </td>
<td>bumen </td>
<td>macadd </td>
<td>ip </td>
<td>psw </td>
<td>beizhu </td>
<td>修改 </td>
<td>删除 </td>
</tr>
<%
ArrayList ar=(ArrayList)session.getAttribute("list1");
for(int i=0; i <ar.size();i++){
Userbean vo=(Userbean)ar.get(i);
%>
<tr>
<td> <%=vo.getId() %> </td>
<td> <%=vo.getCode() %> </td>
<td> <%=vo.getName() %> </td>
<td> <%=vo.getBumen() %> </td>
<td> <%=vo.getMacadd() %> </td>
<td> <%=vo.getIp() %> </td>
<td> <%=vo.getPsw() %> </td>
<td> <%=vo.getBeizhu() %> </td>
<td> <a href="/kaoqin/servlet/Liservlet?method=rewrite&&uid= <%=vo.getId()%>">修改 </a> </td>
<td> <a href="/kaoqin/servlet/Liservlet?method=delete&&uid= <%=vo.getId()%>">删除 </a> </td>
</tr>
<%
}
%>
</table>
<form action="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=T" method="post">
当前共有 <%=request.getAttribute("PageCnt") %>页
当前是第 <%=request.getAttribute("CurPage")%>页
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=F">首页 </a>
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=P">上一页 </a>
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=N">下一页 </a>
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=L">尾页 </a>
跳转到第 <INPUT type="text" name="pagenum" size="3">页 <INPUT type="submit" value="提交">
</form>
</body>
</html>
这页程序点击尾页不好用，出现
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error reading data from static cursor cache.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error reading data from static cursor cache.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.listuser_jsp._jspService(listuser_jsp.java:278)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
哪位好心的高手帮忙看看，谢谢
上回有人说我这段程程序是因为字段为text类型，所以才会出错，必须加空字符串，可是怎么加空字符串呀
？
"http://www.w3.org/TR/html4/loose.dtd">
<%@ page language="java" contentType="text/html; charset=gb2312"%>
<%@page import="java.util.ArrayList"%>
<%@page import="com.bean.Userbean"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>index </title>
</head>
<body>
<a href="/kaoqin/servlet/Liservlet?method=adduser">添加 </a> <br>
<table>
<tr>
<td>id </td>
<td>code </td>
<td>name </td>
<td>bumen </td>
<td>macadd </td>
<td>ip </td>
<td>psw </td>
<td>beizhu </td>
<td>修改 </td>
<td>删除 </td>
</tr>
<%
ArrayList ar=(ArrayList)session.getAttribute("list1");
for(int i=0; i <ar.size();i++){
Userbean vo=(Userbean)ar.get(i);
%>
<tr>
<td> <%=vo.getId() %> </td>
<td> <%=vo.getCode() %> </td>
<td> <%=vo.getName() %> </td>
<td> <%=vo.getBumen() %> </td>
<td> <%=vo.getMacadd() %> </td>
<td> <%=vo.getIp() %> </td>
<td> <%=vo.getPsw() %> </td>
<td> <%=vo.getBeizhu() %> </td>
<td> <a href="/kaoqin/servlet/Liservlet?method=rewrite&&uid= <%=vo.getId()%>">修改 </a> </td>
<td> <a href="/kaoqin/servlet/Liservlet?method=delete&&uid= <%=vo.getId()%>">删除 </a> </td>
</tr>
<%
}
%>
</table>
<form action="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=T" method="post">
当前共有 <%=request.getAttribute("PageCnt") %>页
当前是第 <%=request.getAttribute("CurPage")%>页
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=F">首页 </a>
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=P">上一页 </a>
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=N">下一页 </a>
<a href="/kaoqin/servlet/Liservlet?method=listuser&&pageFlag=L">尾页 </a>
跳转到第 <INPUT type="text" name="pagenum" size="3">页 <INPUT type="submit" value="提交">
</form>
</body>
</html>
这页程序点击尾页不好用，出现
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error reading data from static cursor cache.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error reading data from static cursor cache.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.listuser_jsp._jspService(listuser_jsp.java:278)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
哪位好心的高手帮忙看看，谢谢
上回有人说我这段程程序是因为字段为text类型，所以才会出错，必须加空字符串，可是怎么加空字符串呀
？
...全文
请发表友善的回复…
发表回复
fanyuanwaifdl 2009-03-28
- 打赏
- 举报
up
therehere 2009-03-27
- 打赏
- 举报
感觉是你的分页函数有问题
问题出在边界的控制上
不建议你这样在页面写这么多 java
贴点后台的代码
我 sqlserver用得少 那个报的错没什么经验
问题出在边界的控制上
不建议你这样在页面写这么多 java
贴点后台的代码
我 sqlserver用得少 那个报的错没什么经验
wenhaiyu 2009-03-27
- 打赏
- 举报
如果加空串的话。后边（+""）就可以了。
但我看这个问题好像是在请求数据库或相应jsp的时候发生的错误。
但我看这个问题好像是在请求数据库或相应jsp的时候发生的错误。
